Epicareer Might not Working Properly
Learn More

Database Architect (Medicaid Data Warehouse & Cognos)

Salary undisclosed

Apply on


Original
Simplified

Job Title: Database Architect- Expert

Task ID: HBITS-06-13632

Position Duration: 30 Months

Location: Albany, NY(Onsite)

Mandatory Qualifications

  • 84 months of experience writing complex SQL for queries, stored procedures/triggers/functions in DB2/Oracle for data extraction and data integration purposes in multi-terabyte database.
  • 84 months of experience in gathering reporting and analysis requirements and translating them into reporting structure data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts.
  • 84 months of experience with data modelling, including logical, conceptual, and physical modeling of data warehouse projects and data warehouse loading techniques (Change Data Capture (CDC) and Slowly Changing Dimensions).
  • 84 months of experience with various reporting tools, including COGNOS.
  • 84 months of experience working on ETL framework for data warehouse projects, which includes Informatica / Data stage tools.
  • 56 months of experience working with the Affordable Care Act or Medicaid.
  • 48 months of experience working with OSC and KPMG auditors for analysing and debugging Enrollment and Eligibility data.
  • 48 Months of experience with Medicaid Data Warehouse (MDW).
  • Bachelor's Degree in Information Technology or Computer Science or similar field of study.

Required Documentation

  • Rsum
  • Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job