**Who we are: **

Headquartered in Pittsburgh, Pennsylvania, at Chromalox a Spirax-Sarco Engineering company, we build advanced thermal technologies for the world’s most challenging industrial heating applications. We do it better and have been doing it longer than anyone else.

Chromalox started with an innovative solution 100 years ago when a self-taught engineer invented the first metal-sheathed resistance heating element. It was this then-advanced thermal technology that launched an entire industry.

That pioneering, innovative spirit continues today. Built on opportunity and innovation, Chromalox has grown to serve an increasing number of global markets and industries. We excel in industries that have high expectations. We are acknowledged as experts at delivering solutions that exceed specifications, limit risk, and reduce operating costs.

Join us as we continue to provide solutions to our customers and the world!

The Role:

While this position will sit within Chromalox, our Enterprise Solution Architect will report to the Director of IT of ETS (Electrical Thermal Solutions) and work with the broader organization of the ETS team's technology leadership team.

As the Enterprise Data & Integration Manager, you will oversee our organization's data warehouse infrastructure's design, implementation, and maintenance, focusing specifically on the Microsoft Azure platform for all ETS. The Enterprise Data & Integrations Manager is crucial in developing and executing data integration strategies, ensuring seamless data flow across various systems, and optimizing data storage and retrieval processes.

Additionally, you will partner with the other businesses in the Spirax-Sarco Engineering portfolio to build and implement a cohesive common data model. This role will require international & domestic travel.

This position can be located in one of our USA Central to East Coast offices, in addition to being remote (US preferred, UK, France)

Responsibilities:

• Develop and build a team focused on data, analytics, and system integration.
• Collaborate with cross-functional teams, including business analysts and IT professionals, to align data, integration, and reporting initiatives with business goals.
• Oversee system integration development related to business systems platforms, including internal & third-party resources.
• Design, develop, and maintain the Microsoft Azure data warehouse environment, ensuring its reliability, scalability, and performance.
• Implement and manage data security measures, access controls, and data governance policies within the data warehouse.
• Develop efficient data integration and Extract, Transform, Load (ETL) processes to extract data from multiple sources, transform it into a unified format, and load it into the data warehouse.
• Optimize data integration workflows to ensure data accuracy, completeness, and timeliness, while minimizing data redundancy and latency.
• Monitor and troubleshoot data integration processes to identify and resolve issues, ensuring smooth and uninterrupted data flow.
• Design, develop, and implement integration solutions using Microsoft Azure integration services, including Azure Logic Apps, Azure Functions, Azure Service Bus, and Azure API Management.
• Develop comprehensive data dictionaries, mappings, and lineage documentation to ensure data quality and consistency.
• Partner with the business intelligence and analytics teams to design and build dashboards, reports, and visualizations that provide actionable insights to stakeholders.
• Apply performance tuning strategies to optimize query execution, data retrieval, and overall system performance within the Azure data warehouse.
• Monitor system health and proactively identify bottlenecks or performance issues, implementing appropriate solutions to ensure optimal data warehouse performance.

Required Skills

Required Experience

• At least 6+ years of proven working experience and success in designing, implementing, and managing data warehouse solutions is required.
• At least 2+ years of managing a team.
• Proficiency in data integration and ETL tools is required.
• Solid understanding of data modeling concepts, governance, and best practices for data quality and security.
• Experience with data visualization tools is required.
• Strong SQL programming skills and proficiency in scripting languages, like Python or R, are required.
• Proven experience with Business Intelligence, System Integration roles, and a focus on Microsoft Azure services is a plus.
• Excellent problem-solving and analytical skills, with the ability to identify and resolve complex technical issues.
• Experience working with technical and operational teams with strong meeting management, relationship building, and negotiating skills; able to gain the trust of diverse stakeholders.