Aftersales Business Intelligence Analyst

at  Nissan

The mission of Aftersales Business Intelligence Analyst is to develop various reports and visualizations in Tableau in an effort to support specified client groups within the business function.

EXPERIENCE:

• 5+ years of directly related professional-level experience required. Business, Aftersales, Purchasing, or Marketing experience is preferred. Technical automotive parts experience beneficial.
• Experienced in development of Performance Scorecard/KPI related dashboards related to data-driven business analysis.
• Experience in designing effective data models, trend forecasts, and data analytics visualizations.
• Proficiency in Snow SQL / Python required.
• Relational database modeling fundamentals required. Ability to create an analyze complex business calculations in order to synthesize data insights. Experienced with ETL Self-Service Applications desired. Web Development is a plus.
• Proficiency with data visualization tools such as Tableau required.
  Language: Advanced English
  ETL and data visualization Skills: Tableau, Power Bi, Python, SQL and Snowflake.

JOB KNOWLEDGE AND SKILLS:

• Advanced analytical skills.
• Advanced ETL capabilities using SQL, Snow SQL and/or Python to data mine Aftersales business insights and create data pipelines to support business use-case execution.
• Intermediate to advanced data visualization development skills (i.e. Tableau, Power BI, etc…).
• Excellent written and oral communication skills.

1. Create and design technical solutions to meet business needs by translating end user’s requirements and develop innovative and creative visualizations and tools. Must be capable of strategizing and brainstorming with the team to create a viable solution.
2. Provide insights to the business and drive key learnings and recommendations using available internal and external data
3. Assist in development, maintenance and management of advanced reporting, analytics dashboards and other BI solutions primarily using SQL, Python, Informatica Prep, Snowflake, Tableau and SAP Business Objects. Extracts, validates, and analyzes desired data using aforementioned data extraction tools.
4. Conduct end user tests and develop database queries to analyze analytics and reporting deliverables. Capable of participating in the ongoing iterative development process of the team’s projects.
5. Participate in gathering requirements to improve existing systems from teams within the business to streamline workflow and processes.
6. Document processes and terms in an electronic data glossary.
7. Perform and document data analysis, data validation and data mapping/design by accessing/leveraging multiple data sources in order to achieve end user deliverables.
8. Ability to balance multiple tasks simultaneously and transition between projects while working both independently and effectively in teams.
9. As necessary, performs other related duties of which the above are representative.
   Education: Bachelor’s degree in Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology. Master’s degree preferred.