Data Platform and BI Engineer

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.