Milton CAT

Business Intelligence Analyst

Milton CAT  •  $100k - $120k/yr  •  Milford, MA (Hybrid)  •  3 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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.

Milton CAT

About Milton CAT

Milton CAT is the Caterpillar Dealer for the Northeast region of the United States. Our territory includes Massachusetts, Rhode Island, Maine, New Hampshire, Vermont and upstate New York.

We are a private company, founded in 1960, owned by the family who started the business fifty years ago. Since those early days, Milton CAT has grown to 12 locations, and close to 1000 employees. We're consistently named one of the world's top CAT dealers in terms of sales volume and we're well-known for our progressive practices. In addition to the complete range of Caterpillar equipment, we also sell and service several other top brands that complement the Caterpillar brand.

The company has two main divisions; Earthmoving and Power Systems.

The Earthmoving Division sells, rents and supports machinery and work tools for segments that include the construction, landscaping, forestry, mining, quarry, crushing and screening and municipal sectors.

The Power Systems Division sells, rents and supports power generators and air compressors, and has a specialized engineering group that works with customers to develop customized power systems. Those Milton CAT locations close to water have a marine focus; an industrial group markets engines to manufacturers to power their own machines; and the on-highway truck engine business is an important component for all of our locations.

Industry
Manufacturing & Production
Company Size
501-1,000 employees
Headquarters
Milford, Massachusetts
Year Founded
1960
Social Media