Business Intelligence Analyst

CSP Composite•Auburn Hills, MI

About The Position

CSP is an industry leader in formulating and molding lightweight, advanced composite components for the transportation industries. This role supports the company’s business intelligence work across request discovery, requirements development, dashboard building, analysis, data quality, testing, deployment, training, and adoption. The analyst translates business needs into functional specifications for the Technical BI team and helps ensure dashboards are accurate, useful, and adopted by business users. The analyst works with the BI Manager, Dashboard Sponsors and Owners, BI Data Engineers, the dashboard development partner, and business users. They use SQL, Power BI, Excel, and BI practices to investigate data, validate metrics, reconcile outputs to source systems and financial statements, and communicate findings and recommendations to non-technical audiences. A bachelor’s degree in a quantitative or related field is required; experience in manufacturing or industrial settings is a plus.

Requirements

  • 2–4+ years of experience in business analysis, business intelligence, data analytics, or financial analysis.
  • Hands-on experience building reports and dashboards in a major BI platform.
  • Working SQL skills and an understanding of basic data modeling, including fact and dimension tables, joins, and relationships.
  • Advanced Excel skills, including pivot tables, lookups, and Power Query.
  • Solid grounding in finance and accounting, including the P&L, balance sheet, and cost accounting.
  • Experience gathering and documenting business requirements through user stories, process maps, or functional specifications.
  • Experience with data validation, reconciliation, and user acceptance testing.
  • Clear written and verbal communication skills, including the ability to explain analysis to non-technical audiences.
  • Ability to manage several requests at once, work independently or with a team, and maintain attention to detail.
  • Bachelor’s degree in Finance, Accounting, Information Systems, Computer Science, or another quantitative field.

Nice To Haves

  • Manufacturing or industrial experience.
  • Power BI experience is strongly preferred; Tableau or Qlik experience will also be considered.
  • Understanding of manufacturing and operations.
  • Enjoyment of investigating data and explaining findings to people who do not work with data every day.
  • Storytelling ability: turning numerical data into clear charts and concise explanations for busy plant managers.
  • Careful approach to numbers, including reconciling to source data before sharing results.
  • Curiosity about the reasons behind changes in metrics.
  • Collaborative approach to working with plant supervisors and data engineers and translating between them.
  • Interest in continued growth in analytics and BI skills.

Responsibilities

  • Stay informed about incoming dashboard, report, and analytics requests and support Discovery once requests are prioritized and assigned.
  • Support the BI Manager in Discovery sessions with Dashboard Sponsors and Owners, documenting current reporting processes, data sources, manual steps, and points of failure.
  • Own BI specification development by translating business needs into user stories, acceptance criteria, KPI definitions, data mappings, and dashboard mockups; submit each specification for BI Manager review and approval.
  • Prepare program metrics for the BI Manager, including request volume, cycle time, adoption, and data quality issues.
  • Support BI Data Engineers during data mapping by answering requirement questions and confirming KPI connections to source data.
  • Support the dashboard development partner during dashboard building by clarifying requirements and checking builds against specifications.
  • Write SQL queries and build Power BI prototypes to test requirements, explore data, and answer one-off business questions.
  • Conduct variance, trend, and driver analysis on financial and operational data, and document findings with recommendations.
  • Work with Dashboard Owners to reconcile BI outputs to source systems and financial statements, coordinating with owners and the technical team to resolve discrepancies.
  • Lead user acceptance testing with the Dashboard Owner before releases; write test scripts, log defects, and track them through resolution.
  • Log data quality issues and explain their business impact to the BI Manager to support corrective-action discussions with Dashboard Owners.
  • Own deployment preparation for each release, ensuring documentation and access are ready and coordinating rollout and training with the Dashboard Owner.
  • Develop user guides and quick-reference sheets for new dashboards and BI tools.
  • Answer first-line business-user questions about dashboards, data meaning, and access; route technical issues to the Technical BI team.
  • Track active users, report usage, and the share of reporting completed through self-service, and inform the BI Manager when adoption is falling behind.

Benefits

  • Affordable medical care
  • Dental care
  • Vision care
  • Flexible spending accounts
  • Life insurance
  • 401(k) with company match
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service