Business Intelligence Analyst

Milton CAT•Londonderry, NH
•$100,000 - $120,000•Hybrid

About The Position

Milton CAT is seeking a Business Intelligence Analyst to turn complex business questions into trusted data, meaningful insights, and better decisions. As part of the BI/Data team, this person will develop and support Power BI dashboards and reports used by leaders across Sales, Finance, Service, Parts, Power & Energy, and other business areas. The role combines technical skills and business curiosity to identify trends, risks, and opportunities and translate findings into actionable recommendations. The analyst will also support Milton CAT’s transition from Dynamics AX to Microsoft Dynamics 365. The position can be based in Massachusetts, New Hampshire, or Rhode Island, with hybrid schedule options based on proximity. Office attendance is required at least one to two times per month. Milton CAT operates in six Northeast states and describes itself as a collaborative organization focused on technology, innovation, and growth. The stated salary range is $100,000–$120,000 annually, plus bonus. This job description is not intended to be all-inclusive; the supervisor may request and assign similar duties. Applications must be submitted online; resumes mailed, emailed, or hand-delivered to Milton CAT or an employee will not be considered. Milton CAT is an equal opportunity employer and a VEVRAA Federal Contractor, and it is a drug-free workplace.

Requirements

  • 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, including the ability to turn ambiguous business questions 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.

Nice To Haves

  • 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.

Responsibilities

  • Design, build, enhance, and support Power BI reports and executive dashboards that present meaningful KPIs, trends, and business insights.
  • Partner with leaders and subject-matter experts to understand business needs and translate them into 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 using the team’s Power BI semantic models and propose new or changed measures and relationships while following team security standards, including row-level security.
  • Validate data and troubleshoot reporting or data-quality issues to provide business users with accurate, trusted information.
  • Support migration of reporting from the legacy ERP environment to Dynamics 365 Finance & Operations and Microsoft Fabric.
  • Promote Power BI adoption through user training and support dashboard certification, consistent KPI definitions, and data governance initiatives.
  • Collaborate with internal teams and external partners and contribute to an agile, backlog-driven BI environment.
  • Perform similar duties as requested and assigned by the supervisor.

Benefits

  • Annual bonus
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service