Analytics Engineer (UK)

Chromalox; Pittsburgh (Allegheny County); On-site; GBP 65,000 - 95,000; Full time

Job summary

Chromalox, a leading provider of electrical thermal solutions, seeks an Analytics Engineer to expand data usage for performance and operational improvement. You will own end-to-end data pipelines and develop Power BI analytics for stakeholders across the organisation.

Join a global Data & Analytics team, applying Azure Databricks, Synapse, PySpark, and SQL to deliver timely, trusted insights while ensuring governance and documentation are maintained.

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• Hands-on data pipelines with Azure data engineering tech (Databricks, Synapse, Fabric).
• Proficient in Python/PySpark for transformations and notebooks.
• Strong SQL skills for data extraction, validation, and troubleshooting.
• Experience creating Power BI reports, dashboards, datasets, and modelling.
• Familiar with Git and CI/CD deployment practices.

Responsibilities

• Partner with stakeholders to understand reporting needs and KPIs.
• Design and deliver Power BI reports, dashboards, and semantic models.
• Build and maintain data pipelines with Azure tools and SQL queries.
• Apply DAX, Power Query, and data modelling to optimize solutions.
• Maintain documentation, governance, and data quality checks.
• Provide user support and contribute to BI workspace governance.

Skills

Power BI

DAX

Power Query

Data Modelling

SQL

Education

Bachelor's degree in a related field

Tools

Azure Databricks

Azure Synapse Analytics

Synapse Link

Microsoft Fabric

Git

CI/CD

Job description

Composed of Chromalox, Durex Industries, Vulcanic, and Thermocoax businesses, Electrical Thermal Solutions (ETS), part of Spirax Group, creates electrical process heating and temperature management solutions, including industrial heaters and systems, heat tracing, and a range of component technologies.

At Chromalox, we build advanced thermal technologies for the world's most challenging industrial heating applications.

Headquartered in Pittsburgh, Pennsylvania, we got our start 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.

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

Under the guidance of the team and the Head of Data & Analytics, the Analytics Engineer will contribute to expanding the company's use of data as a driver of business performance and operational improvement. This is an end-to-end data role, covering both the engineering of data pipelines and the development of Power BI reporting and analytics solutions.

Your Responsibilities

Business Partnering and Requirements Gathering

• Work with business stakeholders to understand reporting needs, business objectives, and decision‑making requirements.
• Support requirements discovery sessions, stakeholder workshops, and report design reviews.
• Translate business requirements into clear BI specifications, including KPIs, metrics, dimensions, and data definitions.
• Ask clarifying questions to ensure BI solutions address the true business need rather than simply recreating existing manual reports.
• Support prioritization of BI requests in collaboration with senior team members.

BI Solution Design and Delivery

• Design and develop Power BI reports, dashboards, datasets, and semantic models for defined business requirements.
• Build clear, performant, and well‑structured Power BI solutions that support operational and tactical decision‑making.
• Apply DAX, Power Query, data modelling, and report optimisation techniques.
• Take ownership of small‑to‑medium reporting solutions from design through deployment and support.
• Apply established design patterns, templates, and reusable components to improve consistency.
• Support the review and improvement of existing Power BI solutions.

Data Engineering

• Build and maintain data pipelines using Azure Databricks, Azure Synapse Analytics, Synapse Link, or Microsoft Fabric.
• Write and troubleshoot SQL to extract, validate, and reconcile data from source systems.
• Use Python and PySpark for data transformation and pipeline development tasks.
• Support source‑to‑target mapping, data validation, and data quality checks.
• Follow source control practices (Git) and contribute to CI/CD deployment processes for data and BI assets.

Standards, Documentation and Governance

• Follow agreed BI and data engineering standards, naming conventions, and development practices.
• Maintain clear documentation for reports, datasets, data definitions, and pipelines.
• Support workspace and dataset governance, including certified datasets and access management.
• Identify data quality or process issues and elevate them for resolution.

User Support and Adoption

• Provide day‑to‑day support for Power BI reports, dashboards, and datasets.
• Help users navigate reports, interpret KPIs, and apply filters or drill‑throughs.
• Create and maintain user guides, data dictionaries, and training materials.
• Troubleshoot report, data, and refresh issues, escalating complex cases to senior team members.

Requirements

• Bachelor's degree in a related field, or an equivalent combination of education and directly relevant experience.
• Hands‑on experience designing and building data pipelines using Azure data engineering technologies, such as Azure Databricks, Azure Synapse Analytics, Synapse Link, or Microsoft Fabric.
• Experience using Python and PySpark within Azure Databricks or Synapse Spark pools for data transformation and notebook‑based workflows.
• Working knowledge of source control with Git and exposure to CI/CD or automated deployment practices.
• Solid experience developing Power BI reports, dashboards, and datasets, including DAX, Power Query, and data modelling.
• Strong SQL skills, including the ability to query, validate, and troubleshoot datasets.
• Understanding of modern data architecture patterns, including medallion architecture, lakehouse design, and Delta Lake.
• Good understanding of data visualization and dashboard design principles.
• Good communication and stakeholder engagement skills.
• Ability to manage own workload across data engineering and BI tasks and deliver to agreed deadlines.
• Ability to work effectively as part of a global Data & Analytics team.

Preferred Skills And Experience

• Experience in manufacturing, engineering, industrial, or global operational environments.
• Experience working with ERP, CRM, finance, supply chain, sales, service, manufacturing, or operational data.
• Exposure to Power BI deployment pipelines, row‑level security, or workspace governance.
• Familiarity with Agile delivery methods, backlog management, and iterative analytics delivery.
• Understanding of master data, data cataloguing, and metadata management.
• Interest in developing toward a senior data engineering or BI leadership role.

At Chromalox, we are not just an employer but a champion of equal opportunities and inclusivity. We are dedicated to fostering a workplace that adheres to the highest hiring standards and is free from discrimination and harassment.

Chromalox is an equal opportunity employer; our commitment extends to all aspects of employment, ensuring that no individual is mistreated or discriminated against based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as defined by federal, state, or local laws.