Business Intelligence Analyst

Southworth-Milton, Inc.
Milford, MA, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$100,000 - $120,000
Working hours
Regular working hours

Tech stack

Business Analytics Applications Data Analysis Microsoft Dynamics AX Microsoft Azure Information Systems Databases Continuous Integration Data Governance Data Integrity Data Warehousing Dimensional Modeling Executive Information Systems
+9 more
Microsoft Dynamics Power BI SQL Databases Delivery Pipeline Git Powerquery Microsoft Fabric Information Technology Microsoft Dynamics 365 Finance & Operations

Job description

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

Requirements

Business Intelligence, Analysis Skills, Finance, Business Intelligence, Sales, Microsoft Dynamics AX, Trend Analysis, Microsoft Dynamics, Power BI, Analysis Skills, * 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.

About the company

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…