Help us maintain the quality of jobs posted on PowerToFly. Let us know if this job is closed.
Job Details
About the Role: Grade Level (for internal use):09 The Role: Data Transformation Engineer The Team: Automotive Aftermarket team provides to customers intelligence and insights on VIO (vehicles in operation) and automotive technologies through 20+ years of research and data acquisition. The Impact: The position is critical for the success of our products, and you will be part of the team that builds the customer solutions looking at the latest technology driving unprecedented change in the automotive industry. You will be responsible for leveraging multiple large datasets combined with advances data analytics and data science to create new products with focus on adoption of global automotive and mobility trends (powertrain electrification, autonomous driving, and mobility solutions). What’s in it for you: You will work in an international and creative team, building unique innovative solutions in exciting automotive field together with S&P Global automotive experts and data scientists. Responsibilities:
- Productionize and scale the already written python/pandas code.
- Identifying, designing, and implementing scalable data delivery pipelines and automating manual processes. Data cleaning and transformation/manipulation of raw data.
- Support data scientists in development of new product offers by writing scalable data engineering codes.
- ETL process design, implementation, maintenance, and documentation for large inter-connected data sets. Create and maintain detailed documentation of workflows.
- Employ creative techniques for data wrangling tasks, joining multiple datasets together, data exploration to create unique products while working with domain experts.
- Building required infrastructure for optimal data extraction, transformation and loading of data using cloud technologies like AWS
- Utilize existing database infrastructures and building new DB infrastructures as required.
- Use of data development software (ETL packages) and programming languages and tools (usually SQL and Python) to develop tools to extract, transform and load data, as well as to document the creation of these tools.
- Identifying, assembling, and enriching a wide range of structured and unstructured data to support new automotive forecasts and analysis.
- 3-5 years of experience in data manipulation/engineer role with an engineering background
- Strong understanding of data, including how to interpret it, perform Exploratory Data Analysis (EDA) if required, and extract meaningful insights from it. Highlight data issues and inconsistencies, if any.
- Expertise in Python and data manipulation libraries like Pandas, NumPy is a must.
- Ability to refactor, optimize and productionize the already written POC code.
- Proven experience with SQL databases like Oracle DB/SQL Server/MySQL
- Proven experience with AWS (EC2, S3, Lambda, RDS)
- Experience working with CI/CD, Infrastructure-as-Code, and other automation tools.
- Familiarity with DevOps tool
- Familiar with techniques to manage large datasets, including partitioning, indexes as well as data mining.
- Excellent communication skills as you will need to discuss technical principles and business processes in simple language to people at all levels.
- Be able to build relationships with global colleagues working remotely.
- Enthusiasm for learning, trying new things, sharing knowledge, and developing skills in others.
- Being independent and proactive to find information and raise questions.
- Data acquisition skills would be advantageous.
- Health & Wellness: Health care coverage designed for the mind and body.
- Flexible Downtime: Generous time off helps keep you energized for your time on.
- Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
- Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
- Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families.
- Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.
About the Company
S&P Global
United States
At S&P Global we transform data into Essential Intelligence®, pinpointing risks and opening up possibilities. We Accelerate Progress in the world.... Read more