Business Intelligence Analyst

Job Description

Job Description

Together We Build – Partnership, Innovation, Excellence, and Safety

At Kelso Industries, 3,500+ employees across 30 companies work together to deliver exceptional HVAC, mechanical, plumbing, refrigeration, and electrical solutions nationwide. Join us to grow your career, make an impact, and be part of a team where innovation, excellence, and safety come first.

Recruiter Notice: We respectfully ask external recruiters and staffing agencies not to submit candidates. We only accept direct applications.

Position Overview

We are seeking a highly analytical and technically strong Business Intelligence (BI) Analyst to support data-driven decision-making across the organization. This role will be responsible for building and maintaining scalable reporting and data pipelines, with a primary focus on Domo as our core BI platform.

This individual will play a critical role in connecting data across systems (ERP, HCM, CRM, and operational platforms), transforming it into reliable datasets, and delivering insights that support Finance, Operations, and executive leadership. A strong emphasis will be placed on data integration (APIs), Power Query transformation, and building sustainable, automated reporting solutions.

The ideal candidate combines technical BI expertise with business acumen, particularly in financial and operational analytics and thrives working with large, complex datasets.

Key Responsibilities

Domo Development & Administration

• Build and maintain scalable dashboards, dataflows, and datasets in Domo.
• Manage connectors, pipelines, and platform administration (access, governance, performance).
• Establish and maintain trusted, business-ready datasets.

Data Integration & Transformation

• Integrate data across systems using APIs, connectors, and automated pipelines.
• Transform and model data using Power Query (M language), Domo (Magic ETL/SQL), and other tools.
• Ensure reliable, efficient data flow and troubleshoot pipeline issues.

Analysis & Business Partnership

• Analyze large datasets to deliver actionable insights for Finance, Operations, and leadership.
• Support reporting on key financial and operational metrics (e.g., revenue, margin, utilization).
• Translate business needs into scalable reporting and data solutions.

BI Tooling & Automation

• Leverage Power BI, SQL, Excel, and Python (preferred) for reporting, analysis, and automation.
• Reduce manual reporting through scalable, repeatable data processes using AI where possible.

Data Quality & Governance

• Ensure data accuracy, consistency, and integrity across systems.
• Maintain documentation, definitions, and governance standards for datasets.

Qualifications

Required

• 4–5 years of experience in Business Intelligence, Data Analytics, or a related field.
• Bachelor's degree in Computer Science, Data Analytics, Information Systems, or related field of study.
• Hands-on experience with Domo (dashboarding, ETL/dataflows, dataset management).
• Strong experience with Power Query (M language) for data transformation and automation.
• Advanced Excel skills, including Power Query.
• Experience working with large, complex datasets.
• Proficiency in SQL and data modeling concepts.
• Experience integrating data from multiple sources using APIs, connectors, or ETL tools.
• Experience with Power BI for reporting and visualization.

Preferred

• Experience supporting Finance or FP&A teams with financial and operational reporting.
• Experience with building and supporting AI analytic tools.
• Familiarity with key financial metrics (revenue, margin, forecasting, etc.).
• Experience with Python for data analysis, automation, or API interaction.
• Familiarity with REST APIs, JSON, and modern data integration patterns.
• Exposure to data warehousing or cloud data platforms.
• Experience integrating data from ERP, HCM, CRM, or other enterprise systems.
• Experience in construction, field services, or project-based environments is a plus.

Key Competencies

• Strong analytical and problem-solving skills with attention to detail.
• Ability to translate ambiguous business needs into structured data solutions.
• Strong data visualization and storytelling capabilities.
• Ability to manage multiple priorities and stakeholders effectively.
• Bias toward automation and building scalable, repeatable solutions.
• Commitment to data accuracy, governance, and building trust in reporting.

Why Join Kelso Industries?

Join us and be part of a team dedicated to creating efficient, sustainable, and high-performance environments that make a lasting impact across the industrial, commercial, and institutional sectors.

Here you will experience:

Growth Opportunities: Develop new skills, take on exciting challenges, and advance your career in meaningful ways.

Company Culture: You'll thrive in an environment that supports your growth, values your contributions, and makes work fulfilling and enjoyable.

Impact: Your work directly contributes to meaningful outcomes, allowing you to see the difference you make and feel a sense of purpose every day.

Competitive Compensation & Benefits: You'll be rewarded fairly for your contributions while enjoying perks that enhance your financial security, health, and overall well-being.

Kelso Industries celebrates diversity and is committed to creating an inclusive environment for all employees. We do not discriminate in any aspect of employment based on race, color, religion, national origin, ancestry, gender, sexual orientation, gender identity and/or expression, age, veteran status, disability, or any other characteristic protected by federal, state, or local employment discrimination laws where Kelso does business