Database Architect

Systems, Web, OLTP, OLAP, Computer, Architect, Rational, SQL, Data Analysis, Software, Development, SAS, Java, JSP, CMS, IT, Security
Full Time

Job Description

For 20 years, FEI Systems has been a proven provider of health information technology solutions for Federal, State, and local governments and now, Managed Care Organizations. Our Long-Term Services and Supports solution Carity provides an integrated platform for application and eligibility determinations across Medicaid waiver and incentive programs. Our Web Infrastructure for Treatment Services (WITS) solution tracks behavioral health services, allowing agencies and providers to securely administer and share client treatment information. In addition, FEI provides a wealth of information technology services to Federal Government agencies, from requirements gathering and application development through independent testing, help desk services, and maintenance.

At FEI Systems, we recognize that our employees are an important part of our success. We promote a team environment where all employees have the opportunity to achieve professional and personal success. Currently FEI is looking for highly skilled, self-motivated and creative individuals to join our talented team of experts. FEI is an equal opportunity employer that believes in growing and promoting a diverse work force. Our employee compensation and benefits package is competitive within the industry and is designed to help employees meet varying needs throughout their careers and lives. If you're looking for a rewarding work environment that will challenge your mind and expand your horizons, then joining the FEI team may be right for you.

Principal Responsibilities
  • Collaborate with analysts, developers and architects to capture meaningful data definitions, build data models, and document results throughout the project life cycles
  • Responsible for as-is data architecture analysis and to-be state implementation
  • Responsible for target data design including the OLTP design and OLAP design, source to target mappings, data migration, and metadata modeling
  • Functions as a liaison with external and/or internal clients
  • Analyzes clients' existing systems and business models
  • Understands software development lifecycle
  • Translates client requirements into highly specified project briefs
  • Identifies options for potential solutions and assesses them for both technical and business suitability
  • Coordinates with client to define problem, determine data availability, report requirements, and resolve system design problems

Required Skills/Experience
  • Bachelor's Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
  • 8-10 years of directly related computer systems analysis and/or programming experience.
  • Data migration, data ETL, DW set-up and life cycle.
  • 5 years' hands-on technical experience as Data Architect.
  • Strong Conceptual, Logical and Physical data modeling skills
  • Strong Rational, Dimensional and Object modeling experience and skills
  • Strong SQL and Data Analysis skills.
  • Strong Metadata management. Strong understanding of Extract-Transform-Load (ETL) basics as well as tools used.
  • Strong experience with multiple database formats (e.g., SQL Server, PostgreSQL).
  • Strong understanding of database security principles
  • Strong understanding of Software Development Lifecycles (process, methodologies and best practices) with a strong analytical/technical background within a multi-tier system.
  • Experience in Healthcare industry business practices and data.
  • Strong customer and business focus with presentation skills.

  • Experience with leading BI platform or tools, such as MicroStrategy, Tableau, Qlik, PowerBI, SAS etc, in addition to traditional SQL Server platform
  • Experience with Medicare/Medicaid data, and HIPAA
  • Experience with Java and JSP are plus
  • Experience with CMS IT support projects and CMS shared services are plus.

Location: Columbia, MD, Full time position with full company benefits

NOTICE: EO/AA/VEVRAA/Disabled Employer – Federal Contractor. FEI Systems participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. For more information on E-Verify, please contact DHS at (888) 464-4218.

Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. FEI Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of FEI Systems’ Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and/or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during FEI Systems’ normal business hours.

Dice Id : 10408081
Position Id : 1267
Originally Posted : 2 months ago
Have a Job? Post it