Database Architect

This is a 30 month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension).

Required Experience:

• 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.
• 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.
• 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.
• 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.
• 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.
• 48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements.
• 48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision-support solutions.
• 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.
• 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.
• Bachelor’s degree in IT field

GENESYS Consulting Services, Inc. is proud to be an equal opportunity employer.