Data Engineer

At IEM, we’re not just building innovative electrical distribution systems, we’re shaping the future. IEM is dedicated to delivering world-class solutions for complex power needs. After 75 years, we continue to push the boundaries of what’s possible. Whether you’re an experienced professional or just starting out, you’ll have the opportunity to contribute, grow, and make a lasting impact on industries that power the world’s most dynamic markets.

Location: US Remote

Reports To: Director of Data and Analytics

Salary Range: $130,000 - $170,000

Position Summary:

The Data Engineer is a core builder on IEM’s data and analytics team. This role develops and maintains the data pipelines and transformation models that power Tableau dashboards and business decisions across the organization. Working within an established modern data stack (Fivetran, Snowflake, dbt, Tableau. The Data Engineer turns raw source data into reliable, well-tested, and well-documented analytics-ready datasets. This is a hands-on individual contributor role with real ownership of production data models and growing influence on engineering standards.

Ideal Candidate Profile

You have 3–5 years of experience building data pipelines and transformation workflows in cloud environments. You’re proficient with SQL and Python, comfortable working in Snowflake, and have hands-on experience with dbt or similar transformation tools. You write clean, tested code and take pride in documentation. You’re curious about the business context behind the data and can translate stakeholder questions into well-modeled datasets. You work well on a small team, take feedback constructively, and are eager to grow your skills in analytics engineering, data modeling, and cloud data architecture. You’re excited about AI’s role in modern data work and comfortable using AI coding assistants and agents to accelerate your output.

Key Responsibilities:

• Data Pipeline Development: Build and maintain ELT pipelines using Fivetran and custom integrations that ingest data from source systems including Procore, Salesforce, ERP platforms, and internal databases into Snowflake

• dbt Transformation Models: Develop, test, and document dbt models that transform raw data into clean, reliable datasets for analytics and reporting across Finance, Production, Supply Chain, and Engineering

• Data Modeling: Build dimensional models and staging layers following team conventions, ensuring data is structured for optimal Tableau dashboard performance and ad-hoc analysis

• Data Quality: Write and maintain dbt tests, monitor data freshness, and investigate data quality issues when they arise, owning resolution through to root cause

• Source System Integration: Work with APIs and data connectors to integrate new data sources, troubleshoot ingestion issues, and ensure reliable data flow into the warehouse

• Documentation: Maintain clear documentation for data models, pipeline configurations, and business logic so the team can understand and extend your work

• Collaboration: Partner with business stakeholders to understand data needs, clarify requirements, and deliver datasets that answer real operational questions

• Performance: Monitor query performance and pipeline efficiency, identifying opportunities to optimize warehouse costs and model run times

• Engineering Standards: Participate in code reviews, follow Git workflows and CI/CD practices, and contribute to improving the team’s development processes

• Continuous Learning: Stay current with modern data stack tools and practices, bringing ideas for improvement back to the team

• AI-Assisted Development: Use AI coding assistants and agent-based tools to accelerate pipeline development, code generation, testing, and documentation. Manage AI agents as part of your daily workflow to increase throughput and quality

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field, or equivalent experience

• 3–5 years of experience in data engineering, analytics engineering, or BI development with hands-on experience building production data pipelines

• Strong SQL skills including CTEs, window functions, complex joins, and query optimization

• Experience with Snowflake or similar cloud data warehouses

• Working experience with dbt (data build tool) for building and testing data transformation workflows

• Proficiency in Python for data processing, scripting, and API integrations

• Experience with data integration platforms such as Fivetran or similar ELT tools

• Familiarity with Tableau or similar BI tools and understanding of how data structure impacts dashboard performance

• Comfortable with Git version control and modern development workflows including code review and CI/CD

• Strong problem-solving skills with ability to debug data issues systematically

• Clear written and verbal communication skills with ability to document work and explain technical concepts to non-technical stakeholders

• Self-motivated with ability to work independently in a remote environment while collaborating across a distributed team

• Experience using AI coding assistants (e.g., Claude, GitHub Copilot) and comfort directing AI agents to perform data engineering tasks such as writing SQL, generating dbt models, and debugging pipeline issues

• Preferred: Experience with manufacturing, construction, or project management data systems such as Procore, ERP platforms, or supply chain tools

• Preferred: Familiarity with dimensional modeling concepts (star schemas, fact/dimension tables)

Location

Fully remote within the United States. May require up to 10% travel to IEM facilities for team collaboration, project kickoffs, and stakeholder meetings.

Why Join IEM

At IEM, you’ll join a team that powers some of the world’s most ambitious projects. We’re engineers, makers, and problem-solvers who thrive on tackling complex challenges and delivering solutions that keep industries moving forward. If you’re driven, collaborative, and ready to make an impact, we’d love to hear from you. Your creativity and passion can help us achieve great things—come be part of the journey.

Learn more about IEM at https://www.iemfg.com

We offer comprehensive and competitive benefits package designed to support our employees' well-being, growth, and long-term success. View a snapshot of our benefits at https://www.iemfg.com/careers

Recruiting Scams

Beware of recruiting scams. IEM never charges candidates fees, and all recruiter emails come from an @iemfg.com address. If you suspect fraudulent activity, do not share personal information and report it to us at iemfg.com/contact

Non-Discrimination Statement

IEM does not discriminate against any applicant based on any characteristic protected by law.

Privacy

Information collected and processed as part of your IEM Careers profile, and any job applications you choose to submit is subject to IEM's Workforce Member Privacy Policy.