Power BI Data Engineer

Legence • Minneapolis, MN

1d • $105,000 - $120,000 • Remote

About The Position

Legence is seeking a highly skilled Power BI Data Engineer who combines data engineering expertise with data visualization abilities. This hands-on role involves architecting data solutions and creating dashboards that turn complex data into actionable intelligence. The role interacts directly with end users on requirements, testing, and implementation. It is remote, with a preference for alignment to one of Legence’s office locations.

The position covers Power BI development and visualization, data engineering and architecture, and technical implementation. The engineer will build advanced reports and dashboards, scalable data pipelines, dimensional data models, and warehouse or lake solutions; configure Power BI and Fabric environments; protect data; and optimize performance across the BI development lifecycle. The role requires daily interaction with data, code, and visualization design, and ownership of solutions from the ground up.

The base salary is $105,000–$120,000 per year. The role may be eligible for a discretionary bonus plan based on company and individual performance. Sponsorship is unavailable; candidates must have current U.S. work authorization.

Requirements

• At least 3 years of hands-on Power BI development experience with Desktop, Service, and Report Server.
• Expert-level proficiency in DAX and Power Query (M language).
• Strong SQL skills, including database design, query optimization, and performance tuning.
• Solid understanding of data warehousing, dimensional modeling, and ETL principles.
• Experience with data visualization best practices and UI/UX design principles.
• Proficiency in Azure data services such as Azure SQL Database, Synapse Analytics, Data Factory, or Fabric.
• Deep understanding of data modeling techniques and relationships, including one-to-many, many-to-many, and bi-directional relationships.
• 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.
• Ability to create visually compelling, executive-level dashboards and reports.
• Strong problem-solving skills and a hands-on, solution-oriented approach.
• Excellent communication skills, including explaining technical concepts to non-technical stakeholders.
• Attention to detail and commitment to code quality and documentation.
• Demonstrated ability to use AI and automation in software engineering.
• Current U.S. work authorization; visa sponsorship is not available.

Nice To Haves

• Bachelor’s degree in Computer Science or Computer Information Systems.
• Microsoft certifications such as PL-300, DP-203, or DP-500.
• 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.
• Portfolio of Power BI dashboards demonstrating design excellence and technical complexity.
• Track record optimizing poorly performing reports and data models.
• Experience mentoring others in Power BI development and best practices.
• Contributions to the Power BI community, such as blog posts, speaking engagements, or open-source projects.

Responsibilities

• Create sophisticated Power BI dashboards and reports to support business decisions.
• Develop advanced DAX calculations, measures, and calculated columns.
• Design user-friendly reports with custom visuals, drill-through capabilities, and interactive features.
• Implement bookmarks, parameters, field parameters, dynamic formatting, composite models, aggregations, incremental refresh, and query folding.
• 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 dimensional modeling techniques, including star and snowflake schemas.
• Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms.
• Write and optimize SQL queries, stored procedures, and database functions.
• Establish data governance frameworks, data quality checks, validation rules, and documentation standards.
• Configure and manage Power BI/Fabric workspaces, deployment pipelines, and version control.
• Implement row-level and object-level security for data protection.
• Optimize report performance through query optimization, data model refinement, and DAX tuning.
• Integrate Power BI with SQL databases, APIs, SharePoint, Excel, and cloud platforms.
• Automate data refresh schedules and monitor gateway configurations.
• Interact directly with end users regarding requirements, testing, and implementation.

Benefits

• 401(k) plan with company match, currently dollar-for-dollar up to 4% of eligible pay, with immediate vesting.
• Employer-provided medical, dental, vision, prescription drug, Employee Assistance Program, and accident and illness coverage.
• Employer-provided basic life insurance and AD&D coverage valued at $50,000, with the option to buy additional voluntary coverage.
• Flexible non-accrual vacation and company holidays per policy.
• Business travel and related expenses reimbursed per company policy.
• The role may be eligible for a discretionary bonus plan based on company and individual performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed