General Motors Data Engineer – Digital Ecosystem in Detroit, Michigan
There’s never been a more exciting time to work for General Motors.
To achieve our vision of a world with Zero Crashes, Zero Emissions and Zero Congestion, we need people to join us who are passionate about creating safer, better and more sustainable ways for people to get around. This bold vision won’t happen overnight, but just as we transformed how the world moved in the last century, we are committed to transforming how we move today and in the future.
Why Work for Us
Our culture is focused on building inclusive teams, where differences and unique perspectives are embraced so you can contribute to your fullest potential as you pursue your career. Our locations feature a variety of work environments, including open work spaces and virtual connection platforms to inspire productivity and flexible collaboration. And we are proud to support our employees volunteer interests, and make it a priority to join together in efforts that give back to our communities.
Connected Operations is a part of the larger Customer Experience organization and are at the fore front of the transition to a digital eco system where our interactions with our customers, our partners (dealers) now have more digital footprints. There are some major digital initiatives in the areas of NLP (Natural Language Processing) engines including speech to Text for IVR (Interactive Voice Response systems), transition to using Intelligent Bots handling customer queries, using machine learning tools to improve our systems.
The Individual would be leading the effort to develop “first in line” insights, Key performance indicators and effectiveness of the digital solutions that are being implemented. The individual is responsible to provide technical expertise to develop analytics driven solutions to help GM achieve their business goal. The individual will also work as a member of a multi-disciplinary and cross organizational team of various experience levels that will be driving solution by designing, developing, and deploying analytic models to measure performance to support critical business areas.
As a data engineer, you will work with a wide variety of data sources including Oracle, Teradata , Greenplum, Hadoop ,Cassandra databases to extract information and integrate to help create “key performance indicators” - The KPI’s would serve as a benchmark of the digital initiative’s success . The KPI’s would cover the aspects of operational health, effectiveness and pain points of the digital implementation.
You will do effective gap analysis to understand the failure rates and the cause of the failures is also a key responsibility.
You would also be responsible for implementation of machine learning algorithms to better our understanding of business analytics, train models to act as better predictors of the conversational intents (Text parsing and topic modelling), volumetric trends towards specific lines of business and overall pain point understanding.
With multiple digital initiatives going on, there would be holistic integration in the strategy employed as to achieve a unified picture of all programs.
You will gather the data through mining computer data through software, to improve performance and reduce costs. Effectiveness of the solutions through a cost model would also be a critical responsibility that the individual would work with along with a broader team.
Identify the right data across multiple data platforms and analyze the data in those respective data platforms
Integrate using ETL techniques (Extract, Transform and Load) , all the different data points to common data lake to support the creation of Key performance indicators
Ability to drive insights out of structured, unstructured and semi structured data
Self-starter and ability to form initial impressions from ambiguous data
Synthesize trend data to support recommendations for action to improve performance.
Work in an agile environment with a fast-paced team to quickly Key Performance Indicators.
Recommend and apply the right machine learning algorithms to satisfy the appropriate business requirements.
Identify and monitor current performance and potential service failure modes in delivering digital products to customers using analytics
Maintain knowledge management article with model documents, templates, detailed process flow diagram, value stream mapping diagram, swim lane diagrams, playbook and other reusable knowledge assets.
Communicate with leadership to determine the service level agreement for performance of information technology and our back office
Troubleshoot production issues caused due to production incidents by providing tactical and innovative solutions by working closely IT teams in resolving identified systemic issues affecting system performance
Big data performance tuning for data ingestion and data retrieval, with modeling tools like Erwin, Visio and advanced level expertise in performance optimization, data transformation methods with languages/tools like SQL, PL/SQL, NoSQL, Hive, Hadoop, Spark
Gap analysis in compliance with operational excellence program (lean six sigma principals) of the system to provide insights and improving system performance.
Additional Job Description
Required Technical Skills/Tools
5+ years of experience in using SQL across postgres databases, Hadoop/Hive & Oracle systems. Text Parsing, Analytic functions are critical
3+ years of experience with implementing machine learning models ( Create data sets , train models, explain correlations between dependent and independent variables)
Familiarity with statistics and ability to explain why a specific model was chosen
5+ years of experience with extraction and loading into Hadoop/Hive
Business intelligence and data analysis software — IBM Cognos Impromptu; Tableau, Oracle Business Intelligence Enterprise Edition
5+ years of experience in ETL systems – Via Batch SQL, Data Stage (awareness)
Data base management system software — Apache Hadoop; Oracle PL/SQL; Teradata Database, Apache Cassandra, Apache Hive, NoSQL
Object or component-oriented development software — Python; Java
Operating system software — Bash, UNIX, Shell script
Presentation software — Microsoft PowerPoint
Project management software —Microsoft Project; Microsoft SharePoint;
Development environment software —; Eclipse IDE; Microsoft Visual Studio
Bachelor's degree in related field
Preferred Technical Skills/Tools
Analytical or scientific software — Minitab
Knowledge and awareness of Customer relationship management CRM software
Understand process flows and prior experience with Chat Bots
Understand Natural Language Processing
Knowledge of Kafka streaming systems, Microservices architecture
Understand architectural tenets of clouds ecosystems
Understand ETL methodologies across multiple product ecosystems
The goal of the General Motors total rewards program is to support the health and well-being of you and your family. Our comprehensive compensation plan incudes, the following benefits, in addition to many others:
• Paid time off including vacation days, holidays, and parental leave for mothers, fathers and adoptive parents;
• Healthcare (including a triple tax advantaged health savings account and wellness incentive), dental, vision and life insurance plans to cover you and your family;
• Company and matching contributions to 401K savings plan to help you save for retirement;
• Global recognition program for peers and leaders to recognize and be recognized for results and behaviors that reflect our company values;
• Tuition assistance and student loan refinancing;
• Discount on GM vehicles for you, your family and friends.
General Motors is committed to being a workplace that is not only free of discrimination, but one that genuinely fosters inclusion and belonging. We strongly believe that workforce diversity creates an environment in which our employees can thrive and develop better products for our customers. We understand and embrace the variety through which people gain experiences whether through professional, personal, educational, or volunteer opportunities. GM is proud to be an equal opportunity employer.
We encourage interested candidates to review the key responsibilities and qualifications and apply for any positions that match your skills and capabilities.
The policy of General Motors is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual's age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity/expression or veteran status. Additionally, General Motors is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including individuals with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, email us at Careers.Accommodations@GM.com .In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.
- General Motors Jobs