Data Architect

Introduction:

The Data Architect will play a key role in designing and maintaining scalable enterprise data warehouse architecture. 

Responsibilities:

• Design and maintain scalable enterprise data warehouse architecture
• Develop logical, conceptual, and physical data models
• Translate business requirements into technical data designs
• Analyze source systems and map data into EDW structures
• Support data migration and modernization initiatives
• Review and validate vendor-created data models and database objects
• Identify gaps, inconsistencies, and architectural risks
• Partner with analytics, BI, and reporting teams to ensure data usability and availability
• Support data governance processes, including data standards and definitions
• Produce clear technical documentation and architecture diagrams

Requirements:

Required Knowledge, Skills & Abilities:

• Enterprise Data Warehouse (EDW) concepts and architectures
• Dimensional modeling (star schemas, snowflake schemas, etc.)
• Relational database design principles
• Data integration and data pipeline architecture
• Data quality, data validation, and reconciliation methodologies
• Metadata management and data lineage concepts
• Master data management and reference data strategies
• Cloud-based data warehouse platforms (e.g., AWS, Azure, or similar)
• Data governance frameworks and best practices
• Healthcare data concepts, including Medicaid claims, eligibility, providers, encounters, or managed care data
• Experience with AWS, IBM Infosphere, IBM Cognos, Splunk Enterprise, and other relevant tools

Preferred Experience:

• Experience supporting public sector EDW implementations
• Experience transitioning EDW ownership
• Familiarity with CMS reporting, federal data submissions, or analytics support
• Experience working in hybrid vendor/state environments

LEVEL BACKGROUND SCREENING REQUIRED.  NO THIRD PARTY INQUIRIES.