Data Platform and BI Engineer

Lighthouse Autism Center; Illinois; On-site; USD 120,000 - 160,000; Full time

Job summary

Lighthouse Autism Center seeks a Data Platform and BI Engineer to design, build, and support data models, semantic layers, and analytics for clinical, operational, and financial decisions. You will own the path from source data to trusted insights, ensuring performance, governance, and end-user usability.

Responsibilities include dimensional modeling, creating reusable semantic models in Power BI and Fabric, and delivering dashboards with efficient DAX and Power Query while aligning to HIPAA and

Qualifications

• Experience with dimensional modeling (star schemas) and SCDs (Type 1/2).
• Strong SQL skills including window functions and MERGE/upsert patterns.
• Proficiency in Power BI, DAX, and Power Query (M).
• Familiarity with HIPAA, PHI protection, and access controls.
• Experience with data governance, data dictionaries, and lineage.

Responsibilities

• Design and maintain enterprise data models for clinical, operations, and finance.
• Build semantic models in Power BI/Microsoft Fabric as single source of truth.
• Define conformed dimensions, grain, and security rules; govern data quality.
• Collaborate with engineering on data ingestion, transformation, and warehouse design.
• Develop dashboards, reports, and alerts in Power BI; optimize performance.

Skills

T-SQL

Dimensional modeling

Power BI

Git

HIPAA knowledge

Agile

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

Azure Data Factory

SSDT / Database projects

Power BI / Fabric

Git deployment pipelines

Job description

Job Summary

The Data Platform and BI Engineer will partner with business and technology teams to design, build, and support the data models, semantic layers, and analytics that drive clinical, operational, and financial decisions across the organization. This role owns the path from source data to trusted insight: modeling data correctly, making it performant and governed, and turning it into reporting people actually use.

• Design and maintain dimensional data models that support enterprise reporting across clinical, operations, and finance domains
• Build and manage reusable, certified semantic models in Power BI/Microsoft Fabric to serve as a single source of truth
• Define and maintain conformed dimensions, fact table grain, slowly changing dimensions, and business logic
• Partner with engineering on source ingestion, transformation, and warehouse design
• Maintain a data dictionary, business glossary, and lineage documentation for key data assets
• Contribute to data governance standards, including data quality rules, naming conventions, and master data definitions
• Work with stakeholders to gather requirements, define KPIs, and prioritize analytics work
• Develop dashboards, reports, paginated reports, and alerts primarily in Power BI
• Write efficient, well-structured DAX and Power Query (M), and optimize model and report performance
• Implement row-level and object-level security aligned to HIPAA and least-privilege access requirements
• Apply Agile practices to deliver iteratively and refine solutions with the business
• Use source control and deployment pipelines (Git, Fabric/Power BI deployment pipelines) to manage development, test, and production environments
• Build monitoring and operational reporting for data freshness, pipeline health, SLAs, and error tracking
• Troubleshoot and resolve BI-related support tickets
• Create technical, troubleshooting, and end-user documentation
• Manage workspace, app, and dataset access in coordination with the infrastructure team
• Support user adoption through training, office hours, and self-service enablement
• Develop deep expertise in LAC's data sources, including clinical/practice management, billing, HR, and financial systems
• Serve as a trusted advisor to business leaders, making consultative recommendations on data-driven approaches to reporting, process improvement, and decision-making
• Support, maintain, and enhance existing reports, semantic models, and data structures to ensure accuracy, performance, and continued relevance

Description

Job Summary

The Data Platform and BI Engineer will partner with business and technology teams to design, build, and support the data models, semantic layers, and analytics that drive clinical, operational, and financial decisions across the organization. This role owns the path from source data to trusted insight: modeling data correctly, making it performant and governed, and turning it into reporting people actually use.

Essential Duties And Responsibilities

• Design and maintain dimensional data models that support enterprise reporting across clinical, operations, and finance domains
• Build and manage reusable, certified semantic models in Power BI/Microsoft Fabric to serve as a single source of truth
• Define and maintain conformed dimensions, fact table grain, slowly changing dimensions, and business logic
• Partner with engineering on source ingestion, transformation, and warehouse design
• Maintain a data dictionary, business glossary, and lineage documentation for key data assets
• Contribute to data governance standards, including data quality rules, naming conventions, and master data definitions
• Work with stakeholders to gather requirements, define KPIs, and prioritize analytics work
• Develop dashboards, reports, paginated reports, and alerts primarily in Power BI
• Write efficient, well-structured DAX and Power Query (M), and optimize model and report performance
• Implement row-level and object-level security aligned to HIPAA and least-privilege access requirements
• Apply Agile practices to deliver iteratively and refine solutions with the business
• Use source control and deployment pipelines (Git, Fabric/Power BI deployment pipelines) to manage development, test, and production environments
• Build monitoring and operational reporting for data freshness, pipeline health, SLAs, and error tracking
• Troubleshoot and resolve BI-related support tickets
• Create technical, troubleshooting, and end-user documentation
• Manage workspace, app, and dataset access in coordination with the infrastructure team
• Support user adoption through training, office hours, and self-service enablement
• Develop deep expertise in LAC's data sources, including clinical/practice management, billing, HR, and financial systems
• Serve as a trusted advisor to business leaders, making consultative recommendations on data-driven approaches to reporting, process improvement, and decision-making
• Support, maintain, and enhance existing reports, semantic models, and data structures to ensure accuracy, performance, and continued relevance

Requirements

Qualifications

• Expert T-SQL: window functions, set-based loaders, MERGE/upsert patterns, hashing for change detection, index-aware query design, and stored-procedure development on Azure SQL / SQL Server.
• Dimensional modeling: star schemas, conformed dimensions, SCD Type 1 and 2, surrogate-key strategy, grain design, and event-sourced versus snapshot tradeoffs.
• Azure Data Factory: incremental and watermark loads, pipeline orchestration, triggers, integration runtimes, and JSON source control.
• Power BI: advanced DAX (context transition, relationship functions, performance), Power Query M, PBIP/TMDL source control, and report design for operational users.
• SSDT / database projects: Schema Compare, disciplined manual deployment, and dev/prod parity.
• Git and documentation discipline.
• Strong data-quality instincts: you reconcile across systems before you trust a number, and you fix problems at the source.
• Familiarity with HIPAA, healthcare data privacy, access controls, audit readiness, and operational compliance expectations.

Qualifications (Preferred)

• Working knowledge of predictive analytics techniques, such as forecasting, trend analysis, or statistical modeling, to extend BI beyond historical reporting
• Familiarity with database administration, including performance tuning, indexing, backups, and security in SQL Server or Azure SQL

Key Competencies

• Dimensional modeling: designs star schemas with clear grain, conformed dimensions, and reusable semantic models
• Power BI & Fabric expertise: writes efficient DAX and Power Query, and tunes model and report performance
• Advanced SQL: writes complex, performant queries and traces data issues back to the source
• Data governance & security: protects PHI through row-level security, clear definitions, and quality standards
• Business partnership: turns vague questions into defined KPIs and drives agreement on metric logic
• Disciplined delivery: works iteratively with Agile, source control, and thorough testing
• Clear communication: explains technical concepts plainly to clinical, operational, and executive audiences
• Ownership: works independently in a remote setting and takes end-to-end accountability for production solutions

Education/Experience Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field, or equivalent experience
• 5+ years in data engineering, BI development, or analytics engineering, with at least 2 years owning a production warehouse

Physical Requirements

While performing the duties of this job, the employee is regularly required to sit for prolonged periods of time. The team member is occasionally required to stand, walk, and use hands to operate a computer keyboard. The team member may occasionally lift and or move up to 25 pounds. Vision requirements include close vision, distance vision, depth perception and the ability to adjust focus.