HeartShare is building a modern, secure, AI-ready data platform to support people with developmental disabilities, children and families in foster care, and individuals receiving mental health services. We are seeking aData Engineer to own data pipelines, models, and analytics readiness across our Microsoft Azure and Fabric environment. This role is about making data usable, trustworthy, and scalable.

Primary Responsibilities and Essential Functions of Position:

Data Pipeline & Integration Ownership

· Design, build, and maintain reliable data pipelines into the Microsoft Fabric lakehouse from: EHR systems (e.g., PrecisionCare), HRIS (Paycom), Microsoft Onedrive Files, Finance systems (NetSuite)

· Program-level operational systems

· Partner with IT and vendors on ingestion patterns, APIs, and refresh schedules

· Ensure pipelines are documented, monitored, and resilient to upstream change

Data Modeling & Analytics Enablement

· Design and maintain clean, analytics-ready data models

· Build and manage:

· Curated lakehouse tables

· Power BI semantic models

· Enable self-service analytics while respecting role-based access patterns defined by governance partners

· Reduce reliance on manual extracts and shadow spreadsheets

Data Quality & Reliability

· Implement data quality checks (completeness, validity, timeliness)

· Monitor pipeline health and resolve issues proactively

· Partner with program teams to clarify definitions and resolve discrepancies

· Build trust in metrics, such as service utilization, program and individual health outcomes used by leadership, funders, and regulators

AI & Advanced Analytics Readiness

· Prepare data for AI and advanced analytics use cases, including:

· NLP-based documentation support

· Predictive analytics (health, employment, permanency outcomes)

· Retrieval-Augmented Generation (RAG) architectures (in collaboration with Data Scientist)

· Ensure datasets are well-structured, documented, and versioned

· Support experimentation without creating one-off or ungoverned pipelines

Collaboration & Platform Stewardship

· Work closely with: · SVP of Data & Innovation on roadmap and priorities

· Data Scientist on feature engineering and production pipelines

· VP of IT on system integrations and platform alignment

· Security and governance vendors to ensure compliance-by-design

· Contribute to documentation, runbooks, and onboarding materials

· Help transition from vendor-led build to sustainable internal ownership

Please note this position will be a hybrid position; 3 Days On-Site Required