Lighthouse Autism Center
Lighthouse Autism Center
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.

विवरण

  • 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.

आवश्यकताएँ

  • 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.

लाभ

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

संबंधित नौकरियाँ

System Automation Corporation

Data Engineer, Remote (United States)

System Automation Corporation

Implement ETL migrations and integrations for System Automation’s Evoke regulatory SaaS platform serving government agencies. Build scalable data pipelines and apply AI driven automation to data workflows.

खोलें
CrowdStrike

Senior Platform Data Engineer

CrowdStrike

Build and run CrowdStrike’s analytics platform, supporting cybersecurity data services at scale. The role uses Airflow, Superset, Terraform, cloud platforms, and secure data tooling.

खोलें
Redhorse Corporation

Senior Lead Data Engineer

Redhorse Corporation

Lead the design of Databricks, Python, and SQL data pipelines for Redhorse Corporation’s government technology work. Help modernize critical U.S. defense systems and support national security missions.

खोलें
The Baldwin Group

Senior Data Engineer, MSI

The Baldwin Group

Build secure, scalable data pipelines for MSI’s specialized insurance solutions. Manage ETL, cloud data platforms, governance, and large-scale processing.

खोलें
MSI

Senior Data Engineer, Insurance Data Platform

MSI

Build governed data pipelines and models for MSI’s specialized insurance platform. Support insurance operations with scalable ETL, cloud data systems, and data quality controls.

खोलें