• You’ll lead client discovery to understand business goals, data landscape, constraints, and success metrics—then translate findings into a clear delivery plan. • You’ll design and recommend data lake, Lakehouse, data warehouse, and analytical data store architectures on Azure and Microsoft Fabric aligned to client needs. • You’ll implement (and/or guide implementation of) ingestion, transformation, and orchestration pipelines using Microsoft Fabric experiences and Azure services (e.g., Data Factory, Synapse, Databricks). • You’ll integrate data from operational systems, APIs, and third-party sources and transform raw data into curated datasets ready for consumption. • You’ll build and maintain analytics-ready data models and schemas; implement enrichment, business rules, and reusable patterns for consistency across projects. • You’ll enable multiple compute engines (SQL, Spark/PySpark, Spark SQL, KQL) to run against shared datasets, supporting diverse analytics scenarios. • You’ll design and build AI-enabled analytics and data products, including agentic workflows (e.g., retrieval-augmented generation patterns), ensuring solutions are scalable, secure, and aligned with responsible AI practices. • You’ll establish data quality practices (validation, reconciliation, testing) and monitoring, troubleshoot failures, and continuously improve pipeline resiliency. • You’ll optimize transformations, query performance, and pipeline execution to meet client SLAs and cost objectives. • You’ll implement logging, metrics, and operational runbooks, and support deployments, cutovers, and hypercare as needed. • You’ll design and implement security, governance, and compliance controls (access, least privilege, data protection, lineage) across Azure and Fabric. • You’ll facilitate workshops and communicate architecture tradeoffs, partnering with client stakeholders, architects, analysts, and BI developers to deliver trusted datasets. • You’ll produce clear consulting deliverables (design docs, diagrams, implementation guides) and enablement materials to support adoption and smooth handoff.

• Design and maintain conceptual, logical, and physical data models for the Medicaid EDW. • Define architecture standards for ODS, integration, dimensional, and reporting layers. • Lead source system onboarding into the EDW, including claims, eligibility, provider, encounters, finance, and other Medicaid domains. • Review new initiatives for data impacts, scalability, integration patterns, and downstream reporting implications. • Recommend improvements to warehouse performance, data structures, and overall platform architecture. • Administer and enhance the enterprise Dataedo platform. • Maintain data dictionaries, table/column definitions, business glossary, lineage, and stewardship assignments. • Build and govern source-to-target mapping documentation. • Ensure metadata standards are followed across projects and support teams. • Publish user-friendly documentation portals for business and technical users. • Establish governance processes for definitions, ownership, approvals, and change management. • Maintain end-to-end lineage from source systems through ETL pipelines to reporting assets. • Support impact analysis for schema changes, source changes, and reporting requests. • Partner with data owners and SMEs to standardize KPI and metric definitions. • Support reporting and traceability requirements for Medicaid operations and regulatory reporting. • Help ensure data assets meet privacy, security, and compliance requirements including HIPAA. • Assist with audit requests requiring data lineage, documentation, and control evidence. • Partner with ETL developers, BI teams, analysts, QA teams, DBAs, and business stakeholders. • Mentor technical staff on modeling standards, documentation expectations, and governance practices. • Participate in roadmap planning, release planning, and architecture reviews.

• Join a high-impact digital transformation initiative • Work on multiple projects focused on improving service delivery, modernizing data platforms, and enabling data-driven decision-making

• Support the development and maintenance of data pipelines for healthcare information • Assist in designing and implementing data integration solutions • Help optimize data storage and retrieval processes • Participate in data quality assurance and validation • Contribute to documentation of data flows and processes • Work with various healthcare data formats and standards • Assist in developing ETL (Extract, Transform, Load) processes • Support data security and privacy compliance efforts • Document and propose process improvements for data management workflows