Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Strong SQL skills, Strong knowledge of Star, Snowflake schemas, Data modeling , Ability to Handle things on Data by their own. Performs data dive data analysis and validation.  Perform analysis: Work on service, auction lifecycle of vehicle. Define business questions. Collaborate with engineering teams to identify data sources and queries. Tidy, clean and transform data. Analyze data and identify trends. Visualize data. Draw conclusions, present insights and tell compelling stories.  Help data-science and data-engineering teams perform and implement complex analyses. Select key problems to solve. Define goals. Source data. Share domain knowledge. Identify data features. Measure outcomes. Tune performance.  Build data processes: Lead projects to build better data processes. Understand input data, output data and transformations required to bridge the two. Work with data suppliers. Design, build and manage processes to deliver required data. Ensure data quality. Help manage projects to build new, and to improve existing, data pipelines. Drive deliverables. Measure KPI. Report progress to leadership.  Support product management: Understand opportunities and competition around service, pricing and repair data. Interview customers and stakeholders. Research new features and sources of product differentiation. Be the liaison between technology and product strategy. Define KPI. Be technology’s go-to person for questions related to Operational Data, integration with other systems. 

Information Analysis:

Performs data analysis and validation.  Strong knowledge of Start, Snowflake schemas, Data modeling.  Translates data into meaningful insights.  Develop complex Sql queries, reports and data visualizations to present insights in the most effective way to enable decision making.  Monitors and analyzes key metrics, and executes recurring analyses and reporting.  Mines and interprets data, monitors and analyzes key metrics and interprets performance and provides insight into the data and metrics generated.  Handles data preparation and data analysis portions of various projects.  Writes, maintains and/or updates SQL queries to develop analyses in response to queries from internal customers.  Ensures accuracy of results produced as a result of data analysis.     

Information Management:

Coordinates data feeds and updates and sources additional data required for analysis.  Determines the value of new internal and external data sources, merges disparate data sets, ingests data, cleans and munges data, derives metrics, and transforms the data into usable information.  Assists development teams in creating and maintaining data reporting models.  Develops monitoring mechanisms for quality and data management purposes.  Builds and validates new derived metrics and associated business rules.  Ensures the quality of specific data stores for collection, tracking and reporting of research data. 

Tools: PPT, Visio, SQL query tools, Rally or equivalent Agile Tools, Informatica, AWS Athena, RDBMS: Oracle, Mysql, SQL Server DB, Redshift, Postgres 

Required Qualifications:

8+ years of performing analysis and building data processes  5+ years of working with automotive industry  Bachelor's degree in math, science, computer science, economics or statistics. Master's degree preferred.  Power user of the MS Office suite, including Excel and PowerPoint, for doing business analysis.  Passion for analysis and focus on business results. Entrepreneurial mindset.  Effective written, listening and oral communications.  Collaborative nature and the ability to balance vision and execution. 

Experience required: 8 Years