Job Summary

We are seeking an experienced Data Architect to lead the design, governance, and strategic coordination of data across multiple systems and platforms. This individual will serve as the technical authority on data architecture, driving the design of scalable, integrated data solutions that support operational and analytical needs across the organization. The ideal candidate brings deep expertise in Microsoft SQL Server, Business Intelligence (BI) platforms, and enterprise integration patterns.

Key Responsibilities
• Lead the end-to-end design of enterprise data models, including conceptual, logical, and physical data models across OLTP and OLAP environments.
• Define and enforce data standards, integration patterns, and interoperability strategies across multiple source systems, databases, and platforms, including claims, eligibility, enrollment, and EDI systems.
• Architect and oversee the design of data warehouses, data marts, and reporting layers that support BI dashboards, operational reports, and executive analytics.
• Establish and champion data governance policies, data dictionaries, lineage documentation, and master data management (MDM) strategies.
• Guide and review ETL/ELT pipeline design and collaborate with developers on SSIS packages, stored procedures, and data transformation logic.
• Conduct query and schema performance reviews and advise on indexing strategies, partitioning, and optimization for high-volume data environments.
• Partner with application developers, business analysts, DBAs, and business stakeholders to translate business requirements into effective data architecture decisions.
• Evaluate emerging data technologies and contribute to the organization's data platform roadmap, including cloud migration strategies such as Azure SQL and Azure Synapse.
• Maintain authoritative architecture documentation, ERDs, data flow diagrams, and standards guides.
• Provide technical leadership and mentorship to database developers and analysts.

Required Qualifications
• 8+ years of experience in data architecture, data engineering, or enterprise database design.
• Expert-level proficiency in Microsoft SQL Server, including schema design, T-SQL, performance tuning, and high availability.
• Demonstrated experience designing data warehouses and data marts, including star and snowflake schemas and Kimball methodology.
• Hands-on experience with the Microsoft BI stack, including SSRS, SSAS, SSIS, and Power BI.
• Strong understanding of ETL/ELT design patterns and data pipeline architecture.
• Experience with data governance, data cataloging, and metadata management.
• Proficiency with data modeling tools such as Erwin, ER/Studio, and SQL Server Data Tools.
• Excellent written and verbal communication skills, with the ability to present architecture decisions to both technical and non-technical audiences.

Preferred Qualifications
• Experience working with healthcare data environments, including claims processing, 835/834 EDI, eligibility, and enrollment.
• Familiarity with Azure data services, including Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake.
• Experience with HIPAA compliance and handling of PHI/PII data.
• Strategic thinking with strong attention to detail.
• Ability to manage competing priorities in a complex, multi-system environment.
• Collaborative leadership and stakeholder management skills.
• Data-driven decision-making and architectural trade-off analysis.

Notes:

Required Experience Skills

8+ Years Data Architecture, Enterprise Data Modeling, Data Strategy & Governance

8+ Years Microsoft SQL Server, T-SQL, Schema Design, Performance Tuning, High Availability (HA/DR)

5+ Years Data Warehousing, Data Marts, Star Schema, Snowflake Schema, Kimball Methodology

5+ Years ETL/ELT Architecture, Data Pipelines, Data Transformation Design

5+ Years Microsoft BI Stack (SSIS, SSRS, SSAS, Power BI)

5+ Years SQL Query Optimization, Indexing, Partitioning, Database Performance Tuning

4+ Years Data Governance, Metadata Management, Data Cataloging, Master Data Management (MDM)

4+ Years Cross-System Data Integration, Enterprise Integration Patterns, EDI Integration

4+ Years Data Modeling Tools (Erwin, ER/Studio, SQL Server Data Tools)

3+ Years Architecture Documentation, ERDs, Data Flow Diagrams, Stakeholder Management

Preferred Skills with Required Experience

Required Experience Skills

3+ Years Healthcare Domain (Claims, Eligibility, Enrollment, EDI 834/835)

2+ Years HIPAA, PHI/PII Data Compliance

2+ Years Azure SQL Database

2+ Years Azure Data Factory (ADF)

2+ Years Azure Synapse Analytics

2+ Years Azure Data Lake

2+ Years Cloud Data Migration & Modernization

Top 5 Mandatory Skills for Recruiter Screening

Required Experience Skills

8+ Years Data Architecture

8+ Years Microsoft SQL Server & T-SQL

5+ Years Data Warehousing (Star/Snowflake Schema, Kimball Methodology)

5+ Years SSIS, SSRS, SSAS, Power BI

5+ Years ETL/ELT Architecture, Data Governance & Data Integration