FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Data Platform Engineer – BI
Lighthouse Autism Center. Design and maintain dimensional data models for clinical, operations, and finance reporting .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and maintaining dimensional data models, with advanced skills in Power BI and T-SQL. Proficient in data governance, quality assurance, and compliance with HIPAA regulations, while effectively collaborating with stakeholders to drive data-driven decision-making.
Highest-signal resume keywords
Expert T-SQLDimensional Modeling ExpertiseAdvanced Power BI SkillsAzure Data Factory ExperienceHIPAA Compliance Familiarity
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Dimensional Data ModelingDAXPower Query MData GovernanceData Quality RulesStored-Procedure DevelopmentIncremental LoadsPipeline OrchestrationSemantic Model DesignData Dictionary Maintenance
Soft Skills
Stakeholder CollaborationProblem-SolvingDocumentation Discipline
Tools & Technologies
Power BIAzure SQLSQL ServerAzure Data FactorySSDTGit
Industry Keywords
Healthcare Data PrivacyOperational ComplianceBusiness IntelligenceAnalytics EngineeringData Freshness Monitoring
Tech Stack
Tools & technologiesAzureSQL
About the role
Key responsibilities & impact- 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
What you’ll need- 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
Comp & perks- Remote work setting
- Support for user adoption through training, office hours, and self-service enablement