Demo

Business Intelligence Analyst

Autocam Medical
Kentwood, MI Full Time
POSTED ON 2/9/2025
AVAILABLE BEFORE 5/9/2025

Description

We are seeking a skilled IT Data Analyst with 3-5 years of experience to join our team in Kentwood, Michigan. The ideal candidate will have a strong background in Power BI and SSRS report development, and experience working with Microsoft SQL, SSIS, SSAS, and REST APIs.

This position involves leading the development and management of a new reporting framework while creating reports and dashboards for Epicor Kinetic ERP and various web applications.

It also contributes to automating business processes by exploring and implementing robotic process automation (RPA), machine learning, and AI technologies.

Requirements

Why Join Us?

This is an exciting opportunity to join a company dedicated to investing in technology and innovation. You will be part of a forward-thinking team that values your input and expertise in driving the company's data-driven decision-making processes. If you are a motivated and experienced IT Data Analyst with a passion for technology and a desire to be part of an innovative team, we encourage you to apply.

Major Responsibilities

  • Develop Power BI dashboards and reports for Epicor ERP and various internal and external web applications.
  • Support the development and modification of existing SSRS reports.
  • Convert legacy Excel reports based on SSAS and SQL Stored Procedures to dynamic Power BI reports or Epicor Dashboards.
  • Connect to multiple data sources including SQL, SharePoint, and REST APIs.
  • Develop Epicor Business Activity Queries (BAQs).
  • Configure and administer the reporting framework, including on-premise gateways, workspaces, security, and deployment pipelines.
  • Oversee publishing and deployment to ensure data accuracy and consistency.
  • Identify and implement data warehousing opportunities within Microsoft Fabric.
  • Collaborate with managers to document BI requirements.
  • Train employees on using reporting tools for data analysis.

Skills and Abilities :

  • Advanced proficiency in Power BI Desktop and Power BI Service.
  • Experience with data modeling (star schemas, table relationships, DAX).
  • Experience with Power BI administration (gateways, security, deployment pipelines).
  • Strong understanding of SQL relational databases including various join types, primary and foreign keys, indexes, and stored procedures.
  • Excellent communication and training skills.
  • Ability to work in-person with staff at all levels of the organization to learn and document requirements, facilitate testing, and provide training on using reports.
  • Required Qualifications :

  • 3 years experience in developing Power BI reports for enterprise-level ERP systems, preferably within a manufacturing environment.
  • Microsoft Certification in Power BI, Fabric, or Power Platform
  • Experience connecting with SQL and REST data sources.
  • Ability to work on-premises at our corporate offices in Kentwood, Michigan.
  • Understanding of data warehousing concepts.
  • Advanced experience with Excel and Power Query.
  • Preferred Qualifications :

  • Experience with Epicor E10 or Kinetic ERP is a plus.
  • Familiarity with SSAS and other relevant analytics platforms is a plus.
  • Experience with Microsoft Power Apps and C# is a plus.
  • Experience with UI Path, Power Automate, or other RPA solutions is a plus.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Business Intelligence Analyst?

    Sign up to receive alerts about other jobs on the Business Intelligence Analyst career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $152,365 - $200,973
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Autocam Medical

    Autocam Medical
    Hired Organization Address Grand Rapids, MI Full Time
    Description We are seeking a skilled IT Data Analyst with 3-5 years of experience to join our team in Kentwood, Michigan...
    Autocam Medical
    Hired Organization Address Kentwood, MI Full Time
    Description We are seeking a skilled IT Data Analyst with 3-5 years of experience to join our team in Kentwood, Michigan...
    CAD
    Autocam Medical
    Hired Organization Address Kentwood, MI Full Time
    Brief Description Advanced level of non-supervisory technical drafting work, typically requiring completion of a formal ...

    Not the job you're looking for? Here are some other Business Intelligence Analyst jobs in the Kentwood, MI area that may be a better fit.

    Business Intelligence Analyst

    Technical Intelligence Solutions, LLC, Reston, VA

    Business Analyst With Capital Market

    Business Value Intelligence Services, Irvine, CA

    AI Assistant is available now!

    Feel free to start your new journey!