Business Intelligence Analyst

Job Locations US-MA-Milford | US-NH-Londonderry
ID
2026-6770
Category
Information Technology
Type
Full-Time (FT)

Overview

Milton CAT is looking for a Business Intelligence Analyst to help turn complex business questions into trusted data, meaningful insights, and better decisions. Working as part of our BI/Data team, you’ll develop and support Power BI dashboards and reporting used by leaders across Sales, Finance, Service, Parts, Power & Energy, and other areas of the business. You’ll combine strong technical skills with business curiosity, digging into data to identify trends, risks, and opportunities and translating your findings into clear, actionable recommendations. You’ll also play an important role as Milton CAT continues its transition to Microsoft Dynamics 365 from Dynamics AX.

 

The role can be based in MA, NH or RI with hybrid schedule options based on proximity.  Working in office is required a minimum of 1-2 times per month.

 

Milton CAT operates in 6 Northeast states, combining a strong history and trusted reputation with a continued focus on technology, innovation, and growth. Joining Milton CAT means becoming part of a collaborative organization where your work can make a meaningful impact on the employees, customers, and communities we serve.

 

Salary Range: $100,000 – $120,000 annual + bonus

Responsibilities

What You’ll Do

  • Design, build, enhance, and support Power BI reports and executive dashboards that provide meaningful KPIs, trends, and business insights.
  • Partner with leaders and subject-matter experts to understand business needs and translate them into effective reporting and analytics solutions.
  • Analyze data to identify performance drivers, trends, risks, and growth opportunities and communicate actionable recommendations.
  • Use SQL, Power Query, DAX, and Microsoft Fabric to query, validate, shape, and analyze data.
  • Build reports on the team's Power BI semantic models and propose new or changed measures and relationships, following team security standards, including row-level security
  • Validate data and troubleshoot reporting or data-quality issues to ensure business users have accurate, trusted information.
  • Support the migration of reporting from our legacy ERP environment to Dynamics 365 Finance & Operations and Microsoft Fabric.
  • Help drive Power BI adoption through user training, and support dashboard certification, consistent KPI definitions, and data governance initiatives.
  • Collaborate with internal teams and external partners while contributing to an agile, backlog-driven BI environment.

Qualifications

What We’re Looking For

  • Bachelor’s degree in Information Systems, Computer Science, Business Analytics, Finance, or a related field, or equivalent education and experience.
  • 3-5 years of experience in business intelligence, analytics, reporting, or a closely related role.
  • Advanced experience developing reports and dashboards in Power BI, including Power BI Desktop, Power Query, Power BI Service, DAX, and semantic models.
  • Strong SQL/T-SQL skills, including complex joins, CTEs, and window functions.
  • Understanding of databases, dimensional modeling, star schemas, and data warehousing concepts.
  • Working knowledge of Microsoft Fabric or comparable Azure technologies such as Synapse or Data Factory.
  • Strong analytical and problem-solving skills with the ability to take an ambiguous business question and turn it into meaningful analysis.
  • Ability to communicate complex data and recommendations clearly to business leaders and executive stakeholders.
  • Strong attention to detail, organization, initiative, and commitment to data integrity.

Even Better If You Have

  • Experience with Microsoft Dynamics 365 Customer Engagement or Finance & Operations.
  • Experience with Azure DevOps, agile backlogs, or sprint-based delivery.
  • Familiarity with Power BI deployment pipelines, Git integration, or CI/CD practices.

 

This job description is not intended to be all-inclusive.  Your supervisor may request and assign similar duties.

   

Resumes that are mailed, emailed or hand-delivered to Milton CAT or any employee will not be considered.  You must apply online.

 

Milton CAT is an equal opportunity employer that values the strength diversity brings to the workplace. We encourage applications from individuals with disabilities, minorities, veterans, and women. Applicants receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, sexual orientation, gender identity, handicap, disability, veteran status, genetic data, or other legally protected status. We base all employment decisions to further this principle of equal employment opportunity. VEVRAA Federal Contractor. EEO/AA employer.  Milton CAT is a Drug-Free workplace.  

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed