Analytics Engineer

Chromalox; Pittsburgh (Allegheny County); On-site; USD 100,000 - 150,000; Full time

Job summary

Chromalox is expanding its Data & Analytics capability by embedding an Analytics Engineer who will own end-to-end data pipelines and Power BI reporting for multiple business units. You will work across Azure Databricks, Synapse Analytics, and Microsoft Fabric to deliver scalable data models and dashboards for stakeholders worldwide.

The role emphasizes strong SQL and Python skills, governance, and hands-on development of BI solutions. A preference for Eastern time zone is noted but not required.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Hands-on experience designing and building data pipelines using Azure data engineering technologies (Azure Databricks, Azure Synapse Analytics, Synapse Link, or Microsoft Fabric).
• Experience using Python and PySpark for data transformation in Azure Databricks or Synapse Spark pools.
• Working knowledge of Git and CI/CD for data/BI assets.
• Strong experience developing Power BI reports, dashboards, and datasets (DAX, Power Query, data modeling).
• Strong SQL skills for querying, validating, and troubleshooting datasets.
• Understanding of modern data architectures (medallion/lakehouse/Delta Lake).
• Good data visualization and dashboard design principles.
• Excellent communication and stakeholder engagement skills.
• Ability to manage workload across data engineering and BI tasks in a global team.

Responsibilities

• Understand reporting needs and business objectives with stakeholders.
• Translate requirements into BI specifications including KPIs and data definitions.
• Design and develop Power BI reports, dashboards, datasets, and semantic models.
• Build and maintain data pipelines using Azure Databricks, Synapse, or Fabric.
• Write/troubleshoot SQL for data extraction and validation; use Python/PySpark for transformations.
• Follow Git CI/CD practices and maintain documentation.
• Provide user support and drive BI adoption across regions.

Skills

SQL proficiency

Stakeholder communication

Data interpretation

Education

Bachelor's degree in a related field

Tools

Azure Databricks

Azure Synapse Analytics

Synapse Link

Microsoft Fabric

Power BI

DAX

Power Query

Git / CI/CD

Job description

Analytics Engineer

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.

This role sits within the central, global Data & Analytics team. The successful candidate will build and maintain data pipelines using Azure technologies and will develop Power BI reports and dashboards for business stakeholders across functions, regions, and business units. They will work with a good degree of independence on well‑defined requirements, while drawing on the Senior Analytics Engineer for guidance on more complex or ambiguous problems.

The role requires hands‑on experience with SQL and Azure data engineering technologies, including Azure Databricks, Azure Synapse Analytics, Synapse Link, and Microsoft Fabric. The successful candidate will build and maintain data pipelines and data models and will also develop the Power BI reports and dashboards that sit on top of those pipelines. This is not a pure reporting role, and candidates who only have Power BI experience without data engineering skills will not be suitable.

The successful candidate will design, build, test, deploy, and support both data pipelines and Power BI reporting solutions, working across the data lifecycle from ingestion and transformation through to reporting and user support.

Strong preference for candidates located in the Eastern time zone.

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

• Strong preference for candidates located in the Eastern time zone.
• 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.