Database Architect

Job Title: Database Architect - Expert
Task ID: HBITS-08-14879
Position Duration: 30 Months
Client: State of NY
Agency: Department of Health

Please call | | or email at

Description
This is primarily a Data Modeler position focused on designing, developing, and maintaining enterprise data models to support analytics and reporting needs. In addition, the resource will serve as backup support for OBIEE and ETL processes, assisting with troubleshooting, production support, and issue resolution as needed.

1. Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs.
2. Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs.
3. Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design.
4. Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments.
5. Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts.
6. Develop, review, and optimize ETL processes and mappings for data migration, improving performance and efficiency.
7. Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements.
8. Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements.
9. Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization.
10. Implement and maintain database security, access controls, auditing, and compliance with organizational and state data privacy requirements.
11. Evaluate implementation strategies, identify risks and issues, and support resolution and mitigation planning.
12. Provide technical guidance, conduct design reviews, mentor team members, and support release planning and post-implementation reviews.
13. Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes. Administrative tasks: Perform administrative duties including attendance at meetings and completion of NYS LATS timecard and monthly timesheets.

Mandatory Qualifications 1 84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments. 2 84 Months Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices. 3 84 Months Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments. 4 72 months of experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity. 5 48 Months Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions. 6 48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements. 7 48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision-support solutions. 8 24 Months Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments. 9 24 Months Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments. 10 Bachelor's degree in IT field Required Documentation Resume
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