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