Data Analytics Engineer

Valeo is a tech global company, designing breakthrough solutions to reinvent the mobility. We are an automotive supplier partner to automakers and new mobility actors worldwide. Our vision? Invent a greener and more secured mobility, thanks to solutions focusing on intuitive driving and reducing CO2 emissions. We are leader on our businesses, and recognized as one of the largest global innovative companies.

Mission

Support organizations need for creating analytics platforms, by creating data pipelines, performing data

transformation, combining data from multiple sources and helping to make business decisions with

dashboards.

Responsibilities

Creating data pipelines :

Read source data from different formats (excel, csv, txt, pdf etc) and transform the data using

suitable scripts in a way to bring out business value from the data

Transfer flat files from on-prem to Cloud platforms (preferably GCP) via ELT or ETL process

Load the data into servers ensuring good data quality, right quantity, technical accuracy and

sufficiency to meet project objectives

Use java / python UDF, Beam scripts to batch process or to stream the data

Knowledge of Cloud Shell, SDK to manage GCP resources

Perform data transformation :

Use appropriate language (Python or R) and SQL to read and clean the data

Transform unstructured data into structured data to make relational databases

Write custom queries to transform data dynamically in a visualization tool

Combine data from multiple sources and make Key Parameter estimates :

Use SQL / Bigquery to query data from multiple sources (Bigquery, Bigtable etc)

Transform the query results to calculate complex parameters

Come up with solution to combine data when key columns have missing values or non-obvious

values

Use ML techniques to identify missing / ambiguous values and make the combined data to be

have more utilization

Driving business decisions and alert stakeholders :

Coordinate with the source teams to ensure right data collection, data quality

Help the internal customers to make business decisions with proper visuals, KPI metrics in a live

dashboard

Participate in the internal discussions to clarify the stakeholders to ensure the outcomes are inline

to meet business needs

Education / Training

BE / B.Tech Information Technology, Computer science, Mechanical

Professional Experience

3-5 years in SQL,BigQuery,GCP, Dashboarding, Python, java, and any visualization tool