Data Engineer

Posted One Month Ago
Hiring Remotely in Minneapolis, MN, USA
In-Office or Remote
105K-120K Annually
Mid level
Professional Services • Energy • Industrial • Renewable Energy
The Role
Build and maintain Power BI dashboards, reports, data models, pipelines, ETL/ELT processes, and data warehouses. Develop advanced DAX and SQL solutions, optimize performance, implement security and governance, manage Fabric and Power BI deployments, and integrate diverse data sources. Translate business requirements into technical solutions while collaborating with end users on testing and implementation. The role also requires strong visualization, data quality, documentation, communication, and automation skills.
Summary Generated by Built In

About Legence
Legence (Nasdaq: LGN) is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. The company specializes in designing, fabricating, and installing complex HVAC, process piping, and other mechanical, electrical, and plumbing (MEP) systems—enhancing energy efficiency, reliability, and sustainability in new and existing facilities. Legence also delivers long-term performance through strategic upgrades and holistic solutions. Serving some of the world’s most technically demanding sectors, Legence counts over 60% of the Nasdaq-100 Index among its clients.

Data Engineer

Position Overview

We are seeking a highly skilled Data Engineer to design, develop, and maintain scalable data solutions that support analytics, reporting, and business operations across the organization. This hands-on role requires expertise in data architecture, data integration, cloud platforms, and modern data engineering practices.

The ideal candidate will be responsible for building robust data pipelines, optimizing data platforms, and ensuring the availability, quality, and reliability of enterprise data. This role will interact directly with business stakeholders and end users to gather requirements, support testing efforts, and deliver scalable solutions.

This position is remote, with preference given to candidates located near a Legence office location.

Key Responsibilities

Data Engineering & Architecture

  • Design, build, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, Python, SQL, and related technologies.
  • Develop and optimize enterprise data models utilizing dimensional modeling techniques, including star and snowflake schemas.
  • Implement and manage data warehouses, data lakes, and lakehouse architectures.
  • Integrate data from ERP systems, APIs, cloud platforms, databases, and third-party applications.
  • Build scalable frameworks for data validation, monitoring, and quality assurance.
  • Establish and maintain data governance standards, documentation, and lineage.

Cloud Data Platform Development

  • Configure and support cloud-based data platforms and environments.
  • Develop, optimize, and maintain complex SQL queries, stored procedures, and data transformations.
  • Improve performance and reliability of data pipelines through optimization and monitoring.
  • Implement security controls and access management to protect enterprise data.
  • Automate data processing workflows and scheduled jobs.

Stakeholder Collaboration

  • Partner with business stakeholders to understand data requirements and translate them into technical solutions.
  • Support solution testing, deployment, and ongoing maintenance activities.
  • Provide technical guidance and recommendations regarding data architecture and platform design.
  • Document technical designs, data flows, and operational procedures.

Required Qualifications

Technical Skills

  • 3+ years of hands-on Data Engineering experience.
  • Strong SQL skills, including database design, performance tuning, and query optimization.
  • Experience building and maintaining ETL/ELT pipelines.
  • Experience with Azure Data Factory, Microsoft Fabric, Azure Synapse Analytics, Azure SQL Database, or similar cloud-based data platforms.
  • Proficiency with Python for data transformation, automation, or integration tasks.
  • Solid understanding of data warehousing concepts, dimensional modeling, and data architecture best practices.
  • Experience integrating data from APIs, enterprise applications, and cloud services.

Data & Analytical Expertise

  • Strong understanding of data modeling techniques and relational database concepts.
  • Experience performing data profiling, validation, and quality assessments.
  • Ability to translate business requirements into scalable technical solutions.
  • Understanding of data governance, metadata management, and data lineage principles.

Professional Competencies

  • Strong problem-solving skills and a hands-on, solution-oriented mindset.
  • Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders.
  • Detail-oriented with a commitment to code quality, testing, and documentation.
  • Demonstrated ability to leverage automation and AI-enabled tools to improve development efficiency.

Preferred Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
  • Microsoft DP-203 (Azure Data Engineer Associate) certification or equivalent.
  • Experience with Databricks, Spark, or PySpark.
  • Familiarity with Git, Azure DevOps, and CI/CD pipelines.
  • Experience working with ERP, operational, financial, or construction-related datasets.
  • Experience developing data lake or lakehouse architectures.
  • Knowledge of data science concepts, machine learning workflows, or predictive analytics.

Technical Environment

  • Microsoft Fabric
  • Azure Data Factory
  • Azure Synapse Analytics
  • Azure SQL Database
  • Azure Data Lake Storage
  • SQL Server
  • Python
  • Databricks (preferred)
  • Git / Azure DevOps
  • APIs and Cloud Integration Services

What Makes You Stand Out

  • Experience designing and implementing enterprise-scale data platforms.
  • Proven success building and optimizing complex ETL/ELT processes.
  • Experience modernizing legacy data environments and improving data quality.
  • Strong understanding of cloud-native data architectures and governance practices.
  • Experience mentoring team members and promoting data engineering best practices.
  • Contributions to technical communities, open-source projects, blogs, or speaking engagements.

This is a hands-on technical role requiring daily interaction with data, code, integrations, and cloud-based data platforms. The ideal candidate thrives in environments where they can build scalable solutions from the ground up and take ownership of the full data lifecycle.

Base salary: $105,000-$120,000 per year. This role is also eligible for an annual performance‑based bonus. Bonus eligibility and payout are determined by role, individual performance, and company performance, and are not guaranteed.

Unable to provide sponsorship for this position.

#LI-SC1 #LI-Remote

Benefits Overview
401(k) Plan with Company Match: Currently match contributions dollar-for-dollar up to 4% of eligible pay; immediate vesting. 
Health & Welfare Benefits: Employer provided medical, dental, vision, prescription drug, Employee Assistance Program and accident & illness coverage. 
Life and Disability Insurance: Employer provided basic life insurance and AD&D valued at 50K coverage amount with the option for voluntary buy up for additional coverage.
Time Off: Flexible non-accrual vacation; company holidays per policy. (For California employees, this is separate from California paid sick leave, if applicable.)
Expenses: Business travel and related expenses reimbursed per company policy.

Reasonable Accommodations
If you need assistance or accommodations during the application or interview process, please contact us at [email protected] or your dedicated recruiter with the job title and requisition number.

Employment Eligibility
Candidates must have current work authorization in the U.S.; visa sponsorship is not available for this position.

Third-Party Recruiting Disclaimer
Legence and its affiliates do not accept unsolicited resumes from agencies; any such submissions without a prior signed agreement authorized by Legence Holdings LLC's CHRO or Director of Talent Acquisition will not incur fees and are considered property of Legence.

Pay Disclosure & Considerations
Where pay ranges are indicated, please note that a successful candidate’s exact pay will be determined based relevant job-related factors, including any of the following: candidate’s experience, skills, and qualifications, as well as geographic and market considerations.  We are committed to ensuring fair and competitive compensation for all employees and comply with all applicable salary transparency laws. 

Equal Employment Opportunity Employer
Legence and its affiliate companies are proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), marital or familial status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, other non-merit-based factors, and any other characteristic protected under applicable local, state or federal laws and regulations.

EEO is the Law 

Skills Required

  • 3+ years of hands-on Power BI development experience with Power BI 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
  • Understanding of data warehousing, dimensional modeling, and ETL principles
  • Experience with data visualization best practices and UI/UX design principles
  • Proficiency with Azure data services such as Azure SQL Database, Synapse Analytics, Data Factory, or Fabric
  • Understanding of data modeling techniques and relationships, including one-to-many, many-to-many, and bidirectional relationships
  • Strong understanding 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 executive-level dashboards and reports
  • Strong problem-solving, communication, documentation, and code-quality skills
  • Ability to use AI and automation in software engineering
  • Bachelor's degree in Computer Science or Computer Information Systems
  • Microsoft PL-300, DP-203, or DP-500 certification
  • Experience with Python or R for advanced analytics integration
  • Familiarity with Git or Azure DevOps 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
  • Current U.S. work authorization without visa sponsorship
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San Jose, CA
10,000 Employees
Year Founded: 1967

What We Do

Legence is a building-performance and energy-transition company that delivers engineering, consulting, installation, fabrication, and maintenance services for mission-critical and high-performance facilities. It designs and implements HVAC, mechanical, electrical, plumbing, process-piping, lighting, and building-control systems, while providing sustainability and energy-efficiency solutions. The company serves technology, life sciences, healthcare, education, data centers, manufacturing, and other essential sectors across the United States from more than 70 offices.

Similar Jobs

Toast Logo Toast

Data Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
Remote
US
5000 Employees
106K-170K Annually

Optum Logo Optum

Data Engineer

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office or Remote
Eden Prairie, MN, USA
160000 Employees
73K-130K Annually

Optum Logo Optum

Data Engineer

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office or Remote
Eden Prairie, MN, USA
160000 Employees
113K-193K Annually

Applied Systems Logo Applied Systems

Data Engineer

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
160K-260K Annually

Similar Companies Hiring

Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account