Database Architect (Expert)
Remote
Full Time
Experienced
Job Title: HBITS-06-13632 - Database Architect (Expert)
Agency Name: New York State Department of Health
Full/Part Time: Full-Time
Location: 150 Broadway, Menands, NY 12204
Telecommuting: Negotiable
Requested 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 modeling, 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 analyzing 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.
Apply for this position
Required*