Job Title: Database Architect Expert Task ID: HBITS-05-13380 Position Duration: 30 months Client: State of NY Agency: Information Technology Services (ITS) Please call (703) ###-#### | (571) ###-#### or email at Description:
- Design and implement an Enterprise Data Warehouse solution using the Kimball methodology of data warehouse Star schema and dimensional data modeling.
- Implement and maintain Fine Grain Access Control Audit (FGACA) and Oracle Virtual Private Database(VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
- Guide the ETL team in shaping the ETL architecture and must be able to resolve difficult design and build issues. Expert level experience with the Informatica toolset is required to develop and maintain current and future data marts.
- Extract and Analyze data from numerous heterogenous patient and staffing data systems, used for the design, implementation and maintenance of complex reporting data marts.
- Liaison between technical staff, non-technical staff and business clients to gather business requirements needed to build and implement complex data warehouse database structures.
- Identify, troubleshoot, and resolve difficult data warehouse technical issues, including Production break/fix problems
M andatory Qualifications 1. 84 months of experience designing and implementing Enterprise Data warehouse architecture solutions using the Kimball methodology of dimensional modeling. 2. 84 months of experience designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment. 3. 84 months of experience in collaborating with ETL (Extract, Transform, Load) developers as a team lead in designing Informatica ETL process and data warehouse database architecture. 4. 84 months of experience working with non-technical and business clients to gather, analyze, and document business requirements for technical applications. 5. 84 months of experience analyzing, interpreting, and outputting patient mental health data from numerous heterogenous systems including pharmacy, Medicaid, incident, patient movement, and human resource systems. 6. 84 months of experience in relational data management disciplines and design and development experience using Oracle technologies. 7. Bachelor's Degree 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