Business Intelligence Analyst

1 Month ago • 5 Years + • Data Analyst

About the job

Job Description

This Business Intelligence Analyst role at Nissan Mexicana focuses on providing data-driven insights to improve service retention. Responsibilities include developing and maintaining advanced reporting and analytics using SQL, Python, Informatica Prep, Snowflake, and SAP Business Objects. The analyst will extract, validate, and analyze data, build dashboards, and conduct user testing. They will also participate in requirements gathering, process documentation, and data modeling. A strong understanding of automotive aftersales service retention and related KPIs is crucial. The position requires advanced analytical skills and proficiency in SQL and Python, with experience in ETL and data visualization preferred. The ideal candidate will have 5+ years of directly related experience.
Must have:
  • Advanced analytical skills
  • Automotive Aftersales Service Retention knowledge
  • SQL & Python proficiency
  • ETL capabilities
  • Data visualization expertise
  • Data modeling fundamentals
Good to have:
  • NNA Systems knowledge
  • Web development skills
  • Aftersales & Service Marketing experience
  • Technical automotive parts experience
  • Master's degree
  • Provide insights to the business and drive key learnings and recommendations using available internal and external data specifically around Service Retention and related KPI’s.
  • Assist in development, maintenance and management of advanced reporting, analytics, dashboards and other BI solutions primarily using SQL, Python, Informatica Prep, Snowflake, and SAP Business Objects. Extracts, validates, and analyzes desired data using extraction tools.
  • Understand and utilize tools to store data effectively within the data mart or data lake solutions, online analytical processing, as well as maintaining data analytics platforms so that data can effectively be mined for information by the end user body.
  • Conduct end user tests and develop database queries to analyze the effects and troubleshoot any issues that arise. Capable of participating in the ongoing iterative development process of the team’s projects.
  • Participate in gathering requirements to improving existing systems from teams within the business to streamline workflow and processes.
  • Document processes and terms in an electronic data glossary.
  • Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in source systems.
  • Ability to balance multiple tasks simultaneously and transition between projects while working both independently and effectively in teams.
  • As necessary, performs other related duties of which the above are representative.

1. Job Knowledge and Skills:

  • Advanced analytical skills required.
  • Automotive Aftersales Service Retention and Service Retention drivers or related knowledge required. Understanding of US Market and dealer Service operations required.
  • Advanced ETL capabilities using SQL, Python, Snowflake, and AWS to data mine Aftersales business insights and create data pipelines to support business use-case execution
  • Knowledge of NNA Systems highly preferred.
  • Excellent written and oral communication skills.

2. Years of Experience:

  • Experienced in development of Performance Scorecard/KPI related dashboards related to Automotive Service Retention analysis. Experience in designing effective data models, trend forecasts, and visualizations of analytics related to Automotive Service Retention.
  • Proficiency in SQL / Python required. Relational database modeling fundamentals required. Experienced with ETL Self-Service Applications desired. Web Development is a plus.
  • 5+ years of directly related professional-level experience required. Aftersales & Service Marketing  experience is +plus.
  • Technical automotive parts experience beneficial.

3. Education

  • Bachelor’s degree in Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology. Master’s degree preferred.
  • Advanced English

4. Specific Course/Certifications

  • Advanced knowledge of data-related end-user desktop applications (e.g. Tableau, Snowflake, SQL, Microsoft Excel, Word and PowerPoint). Proficient with mainframe applications to resolve complex problems in day to day situations. Technical and/or programming experience preferred.

By applying for the advertised position, candidates acknowledge that Nissan Mexicana and its subsidiaries reserve the right to conduct a public conduct search due to the sensitive nature of the assets and information involved in the role. This includes, but is not limited to, proprietary information, financial data, and other assets requiring safeguarding. Nissan Mexicana and its subsidiaries assure confidentiality and compliance with all legal requirements regarding the use of such information.  By applying for this position, you are consenting to this check.

Nissan (NMEX, NRFS, NRFM y ANZEN) realiza contrataciones con base al cumplimiento del perfil de puesto en la vacante, sin distinción, ni discriminación por género, identidad y/o expresión de género, orientación sexual, raza, color, idioma, religión, opinión política o de cualquier otra índole, origen nacional o social, posición económica, nacimiento o cualquier  otra condición.

Nissan (NMEX, NRFS, NRFM and ANZEN) hires based on the fulfillment of the job profile in the vacancy, without distinction or discrimination based on gender, gender identity and/or expression, sexual orientation, race, color, language, religion, political or any other opinion, national or social origin, economic position, birth or any other condition.

Mexico City Mexico
View Full Job Description

Add your resume

80%

Upload your resume, increase your shortlisting chances by 80%

About The Company

Smyrna, Tennessee, United States (On-Site)

Aguascalientes, Aguascalientes, Mexico (On-Site)

Aguascalientes, Aguascalientes, Mexico (On-Site)

Mexico City, Mexico City, Mexico (On-Site)

Avila Beach, California, United States (On-Site)

Smyrna, Tennessee, United States (On-Site)

Franklin, Tennessee, United States (On-Site)

Irvine, California, United States (On-Site)

Miramar, Florida, United States (On-Site)

Irving, Texas, United States (On-Site)

View All Jobs

Get notified when new jobs are added by Nissan

Similar Jobs

The Walt Disney Company - Sr Solutions Engineer (Project Hire)

The Walt Disney Company, United States (On-Site)

Dew Software - Test Automation Engineer

Dew Software, India (On-Site)

Paypal - Sr. Software Engineer, Data Governance

Paypal, United States (Hybrid)

Actian - Sr. Data Intergration Consultant

Actian, United States (Remote)

Ubisoft - Data Analyst

Ubisoft, Ukraine (On-Site)

Glean - Senior Technical Writer and Knowledge Manager

Glean, United States (On-Site)

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Nagarro - Principal Engineer, Java Fullstack

Nagarro, Singapore (On-Site)

Cult of the North - Senior Site Reliability Engineer

Cult of the North, Sweden (On-Site)

Notion - Channel Partner Manager, LATAM

Notion, Brazil (On-Site)

The Walt Disney Company - Sr Software Engineer (Roku/BrightScript/SceneGraph)

The Walt Disney Company, United States (On-Site)

Razer - Lead Site Reliability Engineer

Razer, China (On-Site)

Sumo Logic - Senior Software Engineer II, QE - ML/AI

Sumo Logic, India (On-Site)

Nisum - Mobile Engineer A5828

Nisum, India (Hybrid)

ION - Senior Java Developer - Italy

ION, Italy (On-Site)

Get notifed when new similar jobs are uploaded

Jobs in Mexico City, Mexico City, Mexico

Anthology  Inc  - Senior Project Manager

Anthology Inc , Mexico (Remote)

Jellyfish - Senior Resource Manager

Jellyfish, Mexico (Hybrid)

Buckman - Regional Sales Manager - Leather

Buckman, Mexico (On-Site)

Bounteous - Java L2 Support Specialist

Bounteous, Mexico (Hybrid)

Warner Bros Games - Senior Analyst, Deal Management

Warner Bros Games, Mexico (Hybrid)

Rackspace Technology - AWS Cloud Engineer II

Rackspace Technology, Mexico (Remote)

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

Integral Ad Science - Staff Software Engineer

Integral Ad Science, India (Hybrid)

CloudHire - Data Labeler

CloudHire, India (Remote)

Match Group - Senior Data Scientist (Product Analytics)

Match Group, United States (Hybrid)

Morning Star - Senior Data Scientist

Morning Star, India (Hybrid)

QUANTIC DREAM - Data Analyst (F/M/NB)

QUANTIC DREAM, France (Hybrid)

The Walt Disney Company - Decision Science Product Manager (Product Engineering)

The Walt Disney Company, United States (On-Site)

Argus Media - Associate Data Scientist (R & R Shiny)

Argus Media, India (Hybrid)

Varonis  - Data Scientist

Varonis , Israel (On-Site)

Playrix - Senior Data Analyst (Game)

Playrix, Ukraine (Remote)

Get notifed when new similar jobs are uploaded