Power BI Data Engineer
Legence· enterprise· Construction· Jun 17, 2026 · 4mo agoPosted 132 days ago
Minneapolis, MN, USA
In office
Full-time
Mid
$100K–$160K est.
3+ years exp
Before you apply
Ghost Signal:
Open since June 17, 2026 — 132 days, and still accepting applications.
Job description
Position Overview: We are seeking a highly skilled Power BI Data Engineer who combines deep technical expertise in data engineering with exceptional data visualization abilities. This hands-on role requires someone who can architect robust data solutions while creating compelling, insight-driven dashboards that transform complex data into clear, actionable intelligence. This role is expected to interact directly with end users regarding requirements, testing, and implementation. This position is remote with preference to align to one of Legence’ s office locations.
Key Responsibilities
Power BI Development & Visualization
Create sophisticated, visually stunning Power BI dashboards and reports that drive business decisions
Develop advanced DAX calculations, measures, and calculated columns to support complex analytical requirements
Design intuitive, user-friendly interfaces with custom visuals, drill-through capabilities, and interactive features
Implement dynamic report features including bookmarks, parameters, field parameters, and dynamic formatting
Build composite models and leverage advanced features like aggregations, incremental refresh, and query folding
Data Engineering & Architecture
Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data Factory
Develop and optimize data models using star schema, snowflake schema, and other dimensional modeling techniques
Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms
Write and optimize complex SQL queries, stored procedures, and database functions for performance and efficiency
Establish data governance frameworks, including data quality checks, validation rules, and documentation standards
Technical Implementation
Configure and manage Power BI/Fabric workspaces, deployment pipelines, and version control
Implement row-level security (RLS) and object-level security (OLS) for data protection
Optimize report performance through query optimization, data model refinement, and DAX tuning
Integrate Power BI with various data sources including SQL databases, APIs, SharePoint, Excel, and cloud platforms
Automate data refresh schedules and monitor gateway configurations
Required Qualifications
Technical Skills
3+ years of hands-on experience with Power BI development (Desktop, Service, and Report Server)
Expert-level proficiency in DAX (Data Analysis Expressions) and Power Query (M language)
Strong SQL skills with experience in database design, query optimization, and performance tuning
Solid understanding of data warehousing concepts, dimensional modeling, and ETL principles
Experience with data visualization best practices and UI/UX design principles
Proficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric)
Data & Analytical Expertise
Deep understanding of data modeling techniques and relationships (one-to-many, many-to-many, bi-directional)
Strong grasp of statistical concepts and analytical methodologies
Ability to translate complex business requirements into technical data solutions
Experience with data quality assessment and data profiling
Professional Competencies
Proven ability to create visually compelling, executive-level dashboards and reports
Strong problem-solving skills with a hands-on, solution-oriented approach
Excellent communication skills to explain technical concepts to non-technical stakeholders
Detail-oriented with commitment to code quality and documentation
Demonstrated ability to use AI and automation in software engineering
Preferred Qualifications
CS or CIS bachelor 's degree
Microsoft certifications: PL-300 (Power BI Data Analyst), DP-203 (Data Engineer), or DP-500 (Enterprise Data Analyst)
Experience with Python or R for advanced analytics integration
Familiarity with Git/Azure DevOps for version control and CI/CD pipelines
Knowledge of DAX Studio, and other Power BI development tools
Experience with Power BI Embedded or custom API development
Understanding of data science concepts and predictive analytics
Technical Environment
Power BI Desktop, Power BI Service, Power BI Premium/Fabric
SQL Server, Azure SQL Database, Azure Synapse Analytics
Azure Data Factory, Azure Data Lake Storage
DAX Studio, Tabular Editor, Power Query
Git/Azure DevOps for version control
What Makes You Stand Out
Portfolio of impressive Power BI dashboards demonstrating design excellence and technical complexity
Track record of optimizing poorly performing reports and data models
Experience mentoring others in Power BI development and best practices
Contributions to the Power BI community (blog posts, speaking engagements, open-source projects)
This is a hands-on technical role requiring daily interaction with data, code, and visualization design. The ideal candidate thrives in environments where they can build solutions from the ground up and take ownership of the entire BI development lifecycle.
Base salary: $105,000–$120,000 per year. This role may be eligible for participation in discretionary bonus plan based on company and individual performance.Notes: Actual compensation will be based on skills, experience, and work location, and may vary from the posted range. Hiring bonuses (and any guaranteed year-end bonuses) are administered under Company policy and are not earned until all stated conditions are met (e.g., active employment on the payment date). This posting reflects compensation at the time of posting and may be updated.
Unable to provide sponsorship for this position. #LI-JS1 #LI-Remote
Application prep
Use the role’s language and application details while tailoring your materials.
Keywords to mirror
azuresqlaipythonci/cdapi
- Platform
- dayforce
- Effort
- medium