Hiring.Camp

Business Intelligence Analyst

Thecsp

·

Yesterday

Location
Auburn Hills, United States of America
Type
Full-time
Seniority
Mid
Source
Workday

Description

CSP is the industry leader in the formulation and molding of lightweight, advanced composite components for the transportation industries. As an innovative, full-service Tier One supplier, we offer an entrepreneurial environment where you’re only limited by your own imagination. In addition to our team-focused environment, we provide industry-leading benefits, called BENEfits4U. Our comprehensive offering includes: affordable medical, dental, and vision care; flexible spending accounts; life insurance; 401k with company match and much, much more.

Job Description

1. Discovery and requirements: 

  • Stay informed on new dashboard, report, and analytics requests as they come through intake, so you are ready to support Discovery once a request is prioritized and assigned. 
  • Support the BI Manager in Discovery sessions with the Dashboard Sponsor and Dashboard Owner. Help map how business users produce their reports today, including data sources, manual steps, and where things break. 
  • Own BI Spec Development. Turn business needs into functional requirements the Technical BI team can build from, such as user stories, acceptance criteria, KPI definitions, data mappings, and dashboard mockups. The BI Manager reviews and approves each spec. 
  • Pull program metrics for the BI Manager’s reviews, including request volume, cycle time, adoption, and data quality issues. 

2. Build support and analysis: 

  • Support the BI Data Engineers during Data Mapping by answering requirement questions and confirming each KPI connects to the right source data. 
  • Support the dashboard development partner during Dashboard Building by clarifying requirements and checking that each build matches the spec. 
  • Write SQL queries and build Power BI prototypes to test requirements, explore data, and answer one-off business questions. 
  • Run variance, trend, and driver analysis on financial and operational data, and write up what you find with a recommendation. 

3. Data quality, definitions, and testing: 

  • Work with dashboard owners to reconcile BI outputs to source systems and financial statements. When the numbers don’t tie, work with dashboard owners and the technical team until they do. 
  • Lead user acceptance testing with the Dashboard Owner before each release. Write test scripts, log defects, and follow each one until it is fixed. 
  • Log data quality issues and explain their business impact to the BI Manager so the team can work with dashboard owners to discuss corrective actions 

4. Deployment, training, and adoption: 

  • Own Deployment Prep for each release. Make sure documentation, and access are ready before a dashboard goes live, and coordinate the rollout and training with the Dashboard Owner. 
  • Develop user guides, and quick-reference sheets for new dashboards and BI tools. 
  • Answer first-line questions from business users about dashboards, what the data means, and access. Pass technical issues to the Technical BI team. 
  • Track active users, report usage, and the share of reporting done through self-service. Tell the BI Manager where adoption is falling behind. 

Preferred experience and skills: 

We want an analyst who likes digging into data, asks good questions, and can explain a finding to someone who doesn’t work with data every day. If you enjoy chasing down the one number that doesn’t tie out, you will do well here. 

  • 2-4+ years in business analysis, business intelligence, data analytics, or financial analysis. Manufacturing or industrial experience is a plus. 
  • Hands-on experience building reports and dashboards in a major BI platform. Power BI is strongly preferred, and we will also consider Tableau or Qlik. 
  • Working SQL skills and an understanding of basic data modeling, such as fact and dimension tables, joins, and relationships. 
  • Advanced Excel, including pivot tables, lookups, and Power Query. 
  • A solid grounding in finance and accounting, including the P&L, balance sheet, and cost accounting. You need to understand the data well enough to question it. 
  • An understanding of manufacturing and operations would be helpful. 
  • Experience gathering and documenting business requirements through user stories, process maps, or functional specifications. 
  • Experience with data validation, reconciliation, and user acceptance testing. 
  • Clear writing and speaking, including explaining analysis to non-technical audiences. 
  • Ability to juggle several requests at once, work on your own or with a team, and keep the details right. 

Education: 

  • A bachelor’s degree in Finance, Accounting, Information Systems, Computer Science, or another quantitative field is required. 

Personal attributes: 

  • Storyteller. You can turn a table of numbers into one chart and two sentences a busy plant manager will read. 
  • Careful with numbers. You reconcile to the source before you hit send. You would rather find your own mistake than have a VP find it. 
  • Curious. When a number moves, you want to know why. 
  • Collaborative. You are comfortable working with plant supervisors and data engineers in the same week, and you can translate between them. 
  • Eager to grow. You take pride in your work and want to keep building your analytics and BI skills. 

If you enjoy innovation, and an opportunity to learn and contribute to a growing organization, CSP is the place for you! 

Skills

SQLExcelTableauPower BI

Similar Jobs

30

Business Intelligence Analyst

Dordt University·Iowa, US

Today

Business Intelligence Analyst

HEART OF OHIO FAMILY HEALTH CENTERS·Columbus, Ohio

Business Intelligence Analyst

Tmobile·WA-Headquarters, Building 2·Hybrid

1d ago

Business Intelligence Analyst

Tmobile·US·Hybrid

1d ago

Business Intelligence Analyst

Canadaeng Oslrs·Mississauga, Ontario

2d ago

Business Intelligence Analyst

Linjer·Hong Kong·Onsite

2d ago

Business Intelligence Analyst

Amat·Bengaluru, Karnataka

2d ago

Business Intelligence Analyst

Applied Materials·Bengaluru, Karnataka

2d ago

Business Intelligence Analyst

The Future of Health Starts with You·The Woodlands, Texas·Hybrid

3d ago

Business Intelligence Analyst

Cat·Mumbai, Maharashtra

3d ago

Business Intelligence Analyst

Global Partners·Newton, Massachusetts

3d ago

Business Intelligence Analyst

RENFROE (Roster)

Business Intelligence Analyst

Equiniti·US·Hybrid

1w ago

Business Intelligence Analyst

Uline·Glenview, Illinois +4·Onsite

1w ago

Analyst - Business Intelligence

WSP·Noida, Uttar Pradesh·Hybrid

1w ago

Business Intelligence Analyst

Elcomebackpr·San Juan, Puerto Rico

1w ago

Business Intelligence Analyst

Amat·Santa Clara, California

1w ago

Business Intelligence Analyst

Applied Materials·Santa Clara, California

1w ago

Business Intelligence Analyst

Crosscountry Consulting·Boston, Massachusetts +4·Hybrid

1w ago

Business Intelligence Analyst

Planet Fitness·L075 Springfield - Springfield, PA 19064·Onsite

Business Intelligence Analyst

Ziegler·Minneapolis, Minnesota

2w ago

Business Intelligence Analyst

Johnsonelectric·Mexico Zacatecas Plant 2·Onsite

2w ago

Business Intelligence Analyst

Arconic·Norcross, Georgia

2w ago

Business Intelligence Analyst

Jellyfish·Mexico City, Mexico·Hybrid

2w ago

Business Intelligence Analyst

Borrdrilling·Aberdeen, Scotland

2w ago

Business Intelligence Analyst

Whitaker Construction·Brigham City, Utah

2w ago

Business Intelligence Analyst

Continental Properties·Menomonee Falls, Wisconsin·Onsite

2w ago

Business Intelligence Analyst

"Loyalty Juggernaut, Inc"·Hyderabad, Telangana

2w ago

Business Intelligence Analyst

Canaan Valley Institute·Shanghai, China·Onsite

2w ago

Business Intelligence Analyst

Elanco Animal Health Incorporated·Hook, England

2w ago