Please scroll down, To apply

Database Architect

hiring now
New job

i-Link Solutions Inc

2024-10-03 23:44:01

Job location New York City, New York, United States

Job type: fulltime

Job industry: Construction

Job description

Job Title: Database Architect- Expert

Task ID: HBITS-(phone number removed)

Position Duration: 30 Months

Client: State of NY

Agency: NYS Department of Health

Please call (phone number removed) (phone number removed) (phone number removed) or email at

Description

The Database Architect will have responsibility for technical aspects at the New York Health State of Health. This includes analysis of business requirements, data analysis, and query development for reporting for business users at the NYSoH. Specific duties include, but are not limited to:

• Review and translation of business requirements into reporting structure data models

• Writing efficient complex Packages/procedures/Queries

• Working with policy regarding Affordable Care Act or Medicaid which includes Eligibility and Enrollment

• Automating of manual queries through Cognos and DataStage

• Data modeling, specifically for data warehouse projects

• ETL framework for data warehouse projects

Mandatory Qualifications

1
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.

2
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.

3
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).

4
84 months of experience with various reporting tools, including COGNOS.

5
84 months of experience working on ETL framework for data warehouse projects, which includes Informatica / Data stage tools.

6
56 months of experience working with the Affordable Care Act or Medicaid.

7
48 months of experience working with OSC and KPMG auditors for analyzing and debugging Enrollment and Eligibility data.

8
48 Months of experience with Medicaid Data Warehouse (MDW).

9
Bachelor's Degree in Information Technology or Computer Science or similar field of study.

Required Documentation
• Résumé

• Copy of Candidate Identification

(i.e., Driver's License/Green Card/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

Inform a friend!

<!– job description page –>
Top