Data Platform Engineer – BI

🔥 16 hours ago

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Lighthouse Autism Center

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🏥 Healthcare

⚕️ Healthcare Insurance

💰 Private Equity Round on 2021-07

Healthcare • Healthcare Insurance

Lighthouse Autism Center is a dedicated facility providing comprehensive therapy services for children with autism. With over a decade of experience, they offer a wide range of personalized, evidence-based therapeutic approaches such as ABA therapy, speech therapy, and school readiness programs. Their compassionate and clinically excellent team aims to unlock each child's unique strengths and potential in a nurturing environment, supporting families in the Midwest. Through innovative models like the Lighthouse Fusion approach, they make a significant difference in the developmental paths of children on the autism spectrum.

📋 Description

• Design and maintain dimensional data models for clinical, operations, and finance reporting • Build and manage reusable, certified semantic models in Power BI/Microsoft Fabric • Define conformed dimensions, fact table grain, slowly changing dimensions, and business logic • Partner with engineering on source ingestion, transformation, and warehouse design • Maintain data dictionaries, business glossaries, and lineage documentation • Contribute to data governance, data quality rules, naming conventions, and master data definitions • Gather stakeholder requirements, define KPIs, and prioritize analytics work • Develop dashboards, reports, paginated reports, and alerts primarily in Power BI • Write and optimize DAX and Power Query (M) • Implement row-level and object-level security aligned to HIPAA and least-privilege requirements • Use Agile practices, source control, and deployment pipelines across development, test, and production environments • Build monitoring and operational reporting for data freshness, pipeline health, SLAs, and error tracking • Troubleshoot BI support tickets and resolve data issues • Create technical, troubleshooting, and end-user documentation • Manage workspace, app, and dataset access with the infrastructure team • Develop expertise in clinical/practice management, billing, HR, and financial data sources • Advise business leaders on data-driven reporting, process improvement, and decision-making • Maintain and enhance existing reports, semantic models, and data structures

🎯 Requirements

• Expert T-SQL, including 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 expertise, including star schemas, conformed dimensions, SCD Type 1 and 2, surrogate-key strategy, grain design, and event-sourced versus snapshot tradeoffs • Azure Data Factory experience with incremental and watermark loads, pipeline orchestration, triggers, integration runtimes, and JSON source control • Advanced Power BI skills, including DAX, Power Query M, PBIP/TMDL source control, and operational-user report design • SSDT / database projects experience, including Schema Compare, disciplined manual deployment, and dev/prod parity • Git and documentation discipline • Strong data-quality instincts and ability to reconcile across systems and fix problems at the source • Familiarity with HIPAA, healthcare data privacy, access controls, audit readiness, and operational compliance expectations • 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, including at least 2 years owning a production warehouse

🏖️ Benefits

• Remote work setting • Support for user adoption through training, office hours, and self-service enablement