Data Analyst

Position summary: 

The Data Analyst serves as a key strategic partner to Sales Leadership, responsible for transforming complex business data into actionable insights while creating scalable, efficient business processes across the commercial organization.

This role goes beyond traditional reporting and analytics. The successful candidate will lead process improvement initiatives, identify automation opportunities, develop data-driven solutions, and implement tools that increase organizational efficiency. Acting as an extension of Sales Leadership, this individual will independently assess business challenges, create streamlined processes, leverage technology solutions, and drive adoption across cross-functional teams.

The ideal candidate thrives in ambiguity, is highly analytical, process-oriented, and possesses the technical aptitude to automate repetitive work through advanced Excel tools, database management, Power BI, SQL, Python, macros, and other business intelligence platforms.

Job Family: Engineer/Technical

Competencies:

1. Collaborates: Builds partnerships and works collaboratively with others to meet shared objectives. For example, finds many ways to add value to the team; probes to draw out richer input from others; is a valued resource who goes out of the way to help others.
2. Communicates Effectively: Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences. For example, pays attention to others’ insights, advice or instruction, grasping the main elements. Promptly shares relevant information with the right amount of detail.
3. Nimble Learning: Learns through experimentation when tackling new problems, using both successes and failures as learning fodder. For example, experiments to find the best possible solution and gains insight from test cases. Makes use of new concepts and principles when addressing problems. Learns from mistakes to avoid repeating them.
4. Situational Adaptability: Adapts approach and demeanor in real time to match the shifting demands of different situations. For example, sees even subtle cues to adapt; deploys a wide range of behaviors to stay effective. Exemplifies flexibility and resourcefulness; responds deftly to a variety of challenges and situations. 

Essential Responsibilities:

1. Data Analysis

1. Perform data mining, trend analysis, statistical analysis, and business forecasting.
2.  Translate complex data into actionable business recommendations.
3.  Support leadership decision-making through data-driven insights.
4. Assist with forecasting, budgeting, planning and capacity assessments
5. Conduct business, customer, tariff, and market related analysis
6. Business Process Improvement
7.  Analyze existing business processes and identify opportunities for simplification, automation, and efficiency gains.
8.  Design, document, implement, and maintain standardized business processes across commercial functions.
9.  Lead continuous improvement initiatives from concept through rollout.
10.  Partners with Sales, Finance, Program Management, Engineering, Capacity Management, Purchasing, and IT to improve workflows and data accuracy.
11.  Create process documentation, training materials, and standard operating procedures.
12.  Drive adoption of new processes and tools across the organization.
13. Manage and maintain large datasets supporting sales forecasting, customer demand, pricing, tariffs, market intelligence, and strategic planning.
14. Develop and maintain dashboards, KPI reporting, and executive-level presentations.
15. Automation & System Development
16. · Identify opportunities to reduce manual work through automation.
17. Develop tools utilizing advanced Excel, Power Query, Power BI, SQL, Python, VBA/macros, and other business applications.
18.  Collaborate with IT to implement scalable business system solutions.
19. Create automated reporting solutions and data management tools.
20.  Improve data integrity and governance across commercial databases.
21. Strategic Support
22. Support special projects and strategic initiatives for commercial leadership 
23. Conduct business, customer, tariff, and market0related analysis.
24. Serve as a trusted resource for solving complex operational and analytical challenges. 

Education & Experience: 

• Bachelor's degree required in Business, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, Education, Supply Chain, Finance, or a related field.
• 1 – 3 years pf experience in analytics, operations, process improvement, process coordination, business administration, supply chain, sales support, or related business functions.
• Equivalent combinations of education, technical training, internships, co-op experience, and demonstrated analytical capabilities will be considered.
• Experience working with data, reporting, process improvement, or systems administration preferred.
• Automotive industry experience is a plus but not required.

Non-Essential Responsibilities:

• Other duties as assigned by Management.

Other Knowledge, Skills & Abilities:

1. Technical Skills
   1. Advanced proficiency in Microsoft Excel, including complex formulas, Pivot Tables, Power Query, and data analysis tools.
   2. Experience working with large datasets and maintaining data accuracy.
   3. Ability to learn and utilize business intelligence and reporting tools.
   4. Familiarity with SQL, Python, Power BI, VBA, macros, or other automation tools preferred.
   5. Ability to identify opportunities for automation and implement practical solutions.
2. Ideal Candidate Characteristics
   1.  Is naturally curious and enjoys solving complex business problems.
   2.  Can quickly learn new processes, systems, and business functions.
   3.  Demonstrates initiative and does not wait for constant direction or coaching.
   4. Is highly organized, detail-oriented, and process-driven.
   5. Looks for ways to improve efficiency rather than simply maintain existing processes.
   6. Is comfortable challenging the status quo and proposing better solutions.
   7.  Can take ownership of projects from concept through implementation.
   8. Effectively communicates complex information to both technical and non-technical audiences.
   9. Thrives in a fast-paced environment where priorities and business needs evolve.

Supervision Received:

Supervisory Responsibilities:

1. Indirectly responsible to manage data from other departments 

Physical Requirements: 

Environmental Conditions: