Lighthouse Autism Center
Lighthouse Autism Center
1,001 – 5,000 Employees
HealthcareHealthcare Insurance
Lighthouse Autism Center provides therapy services for children with autism, including applied behavior analysis (ABA), speech therapy, and school readiness programs. Its Midwest team uses evidence-based approaches, including the Lighthouse Fusion model, to support children’s development and work with their families. The organization’s clinical and therapy services make it relevant to candidates exploring healthcare careers in autism care.

Senior Data Platform and BI Engineer

Build governed data models and Power BI solutions at an autism care provider, supporting clinical, operational, and financial decisions. Work across data engineering, analytics, and reporting in a remote U.S. role.

Description

  • Design dimensional data models for clinical, operational, and financial reporting.
  • Build and maintain certified, reusable semantic models in Power BI and Microsoft Fabric.
  • Set standards for conformed dimensions, fact table grain, slowly changing dimensions, and business logic.
  • Collaborate with engineering on source ingestion, data transformation, and warehouse design.
  • Keep data dictionaries, business glossaries, and lineage records current.
  • Support governance through data quality rules, naming standards, and master data definitions.
  • Collect stakeholder needs, establish KPIs, and set analytics priorities.
  • Create Power BI dashboards, standard and paginated reports, and alerts.
  • Develop and tune DAX and Power Query M.
  • Apply row-level and object-level security consistent with HIPAA and least-privilege access.
  • Use Agile methods, source control, and deployment pipelines across development, test, and production.
  • Monitor data freshness, pipeline health, service levels, and errors through operational reporting.
  • Investigate BI support requests and resolve data problems.
  • Write technical, troubleshooting, and user documentation.
  • Coordinate with infrastructure staff to manage workspace, app, and dataset access.
  • Build knowledge of clinical and practice management, billing, HR, and finance data sources.
  • Guide business leaders on reporting, process improvement, and data-informed decisions.
  • Maintain and improve existing reports, semantic models, and data structures.

Requirements

  • Advanced T-SQL skills, including window functions, set-based loading, MERGE/upsert patterns, hashing for change detection, index-aware query design, and stored procedures on Azure SQL or SQL Server.
  • Expertise in dimensional modeling, including star schemas, conformed dimensions, Type 1 and Type 2 slowly changing dimensions, surrogate keys, grain design, and event-sourced versus snapshot tradeoffs.
  • Experience with Azure Data Factory incremental and watermark loads, orchestration, triggers, integration runtimes, and JSON source control.
  • Advanced Power BI capability, including DAX, Power Query M, PBIP/TMDL source control, and reports designed for operational users.
  • Experience with SSDT or database projects, Schema Compare, controlled manual deployments, and development and production parity.
  • Consistent use of Git and sound documentation practices.
  • Strong data quality judgment, including reconciling information across systems and resolving issues at their source.
  • Familiarity with HIPAA, healthcare data privacy, access controls, audit readiness, and operational compliance.
  • Bachelor's degree in computer science, information systems, data analytics, or a related field, or equivalent experience.
  • At least five years in data engineering, BI development, or analytics engineering, including two or more years owning a production warehouse.

Benefits

  • Remote work setting.
  • Training, office hours, and self-service resources to support user adoption.

Related Jobs