Data Warehouse Engineer

Location:

1100 ATWATER DR, Malvern, PA, , United States

At ifm efector, we combine innovation, quality, and collaboration to deliver reliable industrial and digital solutions worldwide. Our teams are empowered to continuously improve, take ownership, and build technologies that make data meaningful.

We are looking for a Data Warehouse Engineer to support and expand our Azure-based data platform, enabling scalable, high‑quality data solutions across the organization.

As a Data Warehouse Engineer, you will design, develop, and support modern data pipelines and cloud‑based data infrastructure. You will collaborate across teams to ensure seamless data integration, reliable operations, and continuous optimization of performance and cost efficiency.

• Design, build, and maintain ETL/ELT pipelines to support efficient data integration and transformation (Python, PySpark, SQL)
• Develop and manage data models and database components (e.g., stored procedures) to orchestrate and optimize data workflows
• Drive and enhance Dev Ops best practices
  , including CI/CD pipelines and automation
• Continuously improve data platform capabilities by evaluating and leveraging emerging technologies
  , tools, and methodologies
• Identify opportunities to incorporate AI and advanced analytics to improve data processes, platform capabilities, and the solutions delivered to business users
• Partner with data scientists and analysts to deliver impactful, data‑driven solutions
• Collaborate with upstream and downstream system owners to ensure smooth and reliable integration
• Monitor data pipelines and Azure cloud infrastructure to ensure stable day‑to‑day operations
• Track, analyze, and improve platform performance metrics to identify bottlenecks and data pipeline issues
• Troubleshoot and optimize systems to improve performance, efficiency, and cloud cost (Fin Ops awareness)
• Create and maintain clear technical documentation
  , including test execution and validation
• Resolve service requests as part of 2nd and 3rd level support
• Mentor and support team members, trainees, and students

Education/Experience

• A bachelor’s degree in Computer Science, Data Science/Engineering or related is required
• 5+ years experience in data engineering, software engineering or similar roles is required
• Experience working on international teams is desired
• Some minimal international travel is required
• Demonstrated ability to work independently as well as within a team

• Experience working within the Microsoft Azure cloud environment
• Hands‑on experience with:
  • Azure Synapse Analytics
  • Azure Data Factory
  • Microsoft Fabric
  • Azure Data Lake Storage Gen2 / One Lake
  • Azure SQL Server

• Strong proficiency in SQL development
• Experience with Python and/or Py Spark
• Solid understanding of data pipelines, ETL/ELT processes, and data modeling
• Experience with Azure Dev Ops
  , including Git and CI/CD pipelines (YAML)
• Strong analytical, troubleshooting, and problem‑solving skills
• Structured, reliable, and collaborative working style
• Top‑tier medical plan with no deductible, plus voluntary dental and vision plans
• Company‑paid Long‑Term Disability and Short‑Term Disability, and other insurances
• 401K program with 100% company match of up to 6% of pay after six months
• Eleven paid holidays per calendar year
• 15 paid vacation days and 5 days paid sick time

ifm efector, inc., headquartered in Malvern, PA, has earned the distinguished Top Employers certification for 2020 and 2021 in North America for our outstanding people practices. ifm efector is the US subsidiary of ifm electronic gmbh, a global company with over 8,700 employees in 165 countries serving 155,000 customers worldwide. Our core business is the development and production of sensors and controls for industrial automation and process applications.

“Exceptional success can only be achieved when the employees believe in the company and when they know that they are treated in a fair and honest way.” - ifm philosophy

ifm is a privately‑owned company whose success can be attributed to three guiding principles:
Employees First, Customer Loyalty, and Safe Growth. With a supportive and collaborative culture, ifm welcomes new ideas and fosters honest communication and trust. Distinguished by their individual capabilities and contributions, every employee plays a role in the success of our business, so that we may provide innovative solutions to meet and exceed our customer’s business needs. ifm is dedicated to ensuring employees are engaged, enabled, and empowered to realize their full potential in a positive, diverse, and inclusive work environment filled with meaning and a shared sense of purpose.

“We have amazing products, but best of all we have amazing people. This is a core value of our success.” - Roger Varma, CEO, ifm efector