Business Intelligence Analyst

Job Summary
:
Therma-Stor is an innovation leader in advanced heat-transfer and water management technologies. The Business Intelligence Analyst is responsible for extracting, analyzing, and interpreting data to support decision making and strategic planning, working closely with cross-functional teams to develop business intelligence solutions.

Responsibilities
:

• Use standard and ad hoc queries or reports to extract data from disparate databases or data sources

• Build, modify, and maintain SQL queries, data views, and datasets as needed

• Analyze data to produce dashboards, metrics, and insights that inform business decisions

• Identify trends, patterns, and anomalies within datasets and communicate findings to stakeholders

• Develop and optimize ETL/ELT processes using SQL, Power BI Dataflows, Microsoft Fabric, or other integration tools

• Ensure data quality by performing validation, reconciliation, and root‑cause analysis on discrepancies

• Contribute to overall data architecture decisions, ensuring alignment with governance and security standards

• Troubleshoot data pipeline issues, performance bottlenecks, and modeling errors

• Partner with IT, Sales, Finance, Operations, and Human Resources to design and implement business intelligence solutions that facilitate data gathering, storage, and retrieval

• Maintain documentation for reporting processes, data definitions, and system configurations

• Assist with establishing and reinforcing data integrity, data quality, and data governance practices

Qualifications
:
Required
:

• Education equivalent to a bachelor’s degree in Finance, Data Science, Information Systems or related field

• Proficiency with Microsoft Dynamics, Microsoft Fabric, and Power Automate

• Strong experience with SQL for data querying and manipulation

• Hands-on experience building dashboards and analytics in Power BI

• Advanced skills in Microsoft Office, especially Excel (pivot tables, formulas, Power Query)

• Strong analytical, project management, problem-solving, and critical-thinking abilities

• Ability to communicate technical concepts to non-technical users clearly and effectively

Preferred
:

• Experience with ETL processes or data integration tools

• Experience in a manufacturing, distribution, or similar operational environment

• Knowledge of data governance requirements, including internal controls, documentation standards, and audit support — especially as they relate to financial or system‑generated data

Company
:
Therma-stor is a consumer goods company that manufactures dehumidifiers and ventilation systems. Founded in 1977, the company is headquartered in Madison, USA, with a team of 201-500 employees. The company is currently Growth Stage.