Data Analytics Engineer

General Motors

Warren, MI

JOB DETAILS
SKILLS
Advanced Product Quality Planning (APQP), Business Intelligence Software, Business Solutions, Change Requests/Orders, Computer Science, Cross-Functional, Data Analysis, Data Cleaning, Data Collection, Data Entry, Data Formats, Data Modeling, Data Quality, Data Science, Decision Support, Electrical Engineering, Electronic Engineering, Equal Employment Opportunity (EEO), Leadership, Metrics, Microsoft Excel, Microsoft Product Family, Microsoft SharePoint, Microsoft Visual Basic for Applications (VBA), Oracle Database, Performance Analysis, Performance Metrics, Pivot Tables, Power BI, Powertrain, Problem Solving Skills, Process Improvement, Product Development, Production Part Approval Process (PPAP), Python Programming/Scripting Language, Quality Engineering, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), Software Development, Software Engineering, Trend Analysis, Vendor/Supplier Quality Management
LOCATION
Warren, MI
POSTED
2 days ago
**Job Description** **DUTIES** : Use modern data analytics and Business Intelligence tools such as Microsoft Power BI, Microsoft Excel, Microsoft SharePoint, Python and Oracle SQL Developer to perform Complex data analysis to support General Motors’ Global Supplier Quality and Development organization by creating reports and dashboards. Support leadership in data driven decision making by developing reports and tools to aid in Advanced Product Quality Planning (APQP). Support Supplier Quality Launch Engineers by reporting on Component Readiness Valves (CRV), Production Part Approval (PPAP) and Run at Rate processes throughout the Global Vehicle, Powertrain, and Software Development Process (GxDP). Lead integration of the Supplier Process Change Request (SPCR) into Supplier Quality’s value stream, ensuring the right data is available to all stakeholders to quickly act on change requests. Assist Supplier Quality Engineers to analyze Quality Performance Rating (QPR) metrics of suppliers to highlight trends and failure modes using customized Key Performance Indicators (KPIs). Gather functional and technical requirements from Supplier Quality Engineers and Leadership to create reports with data drill-down capabilities that can address users of different organizational hierarchy levels. Design, develop, validate, and create reports in Microsoft Power BI by utilizing Data Analysis Expressions (DAX) and Power Query M formula language to gather and clean data. Create meaningful dashboards utilizing visualizations such as histograms, bar and pie charts and line plots to highlight data analysis results and support critical decision making by leadership. Perform regular maintenance and updates to reports deployed to Microsoft Power BI Service. Schedule reports refresh to ensure accurate and reliable data is readily available. Perform cross-functional activities such as creating Change Requests to have reports deployed to Production servers from Pre-Production servers. Utilize Pivot Tables, Data Models and formulas in Microsoft Excel to create reports. Create Macros using Visual Basic for Applications (VBA) to automate data entry tasks and report creation. Utilize Oracle SQL Developer and write Structured Query Language (SQL) queries to explore and identify data tables containing relevant data and fields required to achieve the goal and successfully complete the task. Perform data wrangling to extract relevant data fields required to create reports. Perform role of Subject Matter Expert (SME) on Supplier Quality business systems such as Supplier Practical Problem Solving (SPPS), Supplier Quality Management System (SQMS) and Supplier Certification Management System (SCMS) in cross-functional and cross-departmental projects. Identify errors in data systems and advise on changes and updates to be made. Hybrid Work Policy - 3 days In-office, 2 days remote - Must be able to report to local office. **REQUIREMENTS** : Bachelor's degree in Data Science, Computer Science, Electrical Engineering, Electronics Engineering, or related field of study and Two (2) years of experience as a Data Analyst or related role. Two (2) years of experience with: Microsoft Excel. One year of experience with: Microsoft Power-BI; SQL and Oracle; Microsoft VBA macros; and Microsoft SharePoint. \#LI-DNI **About GM** Our vision is a world with Zero Crashes, Zero Emissions and Zero Congestion and we embrace the responsibility to lead the change that will make our world better, safer and more equitable for all. **Why Join Us** We believe we all must make a choice every day – individually and collectively – to drive meaningful change through our words, our deeds and our culture. Every day, we want every employee to feel they belong to one General Motors team. **Benefits Overview** From day one, we're looking out for your well-being–at work and at home–so you can focus on realizing your ambitions. Learn how GM supports a rewarding career that rewards you personally by visiting Total Rewards resources (https://search-careers.gm.com/en/working-at-gm/total-rewards) . **Non-Discrimination and Equal Employment Opportunities (U.S.)** General Motors is committed to being a workplace that is not only free of unlawful discrimination, but one that genuinely fosters inclusion and belonging. We strongly believe that providing an inclusive workplace creates an environment in which our employees can thrive and develop better products for our customers. All employment decisions are made on a non-discriminatory basis without regard to sex, race, color, national origin, citizenship status, religion, age, disability, pregnancy or maternity status, sexual orientation, gender identity, status as a veteran or protected veteran, or any other similarly protected status in accordance with federal, state and local laws. We encourage interested candidates to review the key responsibilities and qualifications for each role and apply for any positions that match their skills and capabilities. Applicants in the recruitment process may be required, where applicable, to successfully complete a role-related assessment(s) and/or a pre-employment screening prior to beginning employment. To learn more, visit How we Hire (https://search-careers.gm.com/en/how-we-hire) . **Accommodations** General Motors 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 (Careers.Accommodations@GM.com) us or call us at 1-800-865-7580. 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. We are leading the change to make our world better, safer and more equitable for all through our actions and how we behave. Learn more about: **Our Company (https://search-careers.gm.com/en/working-at-gm/)** **Our Culture** **How we hire​​​​​​​ (https://search-careers.gm.com/en/how-we-hire/)** Our diverse team of employees bring their collective passion for engineering, technology and design to deliver on our vision of a world with Zero Crashes, Zero Emissions and Zero Congestion. We are looking for adventure-seekers and imaginative thought leaders to help us transform mobility. Explore our global locations (https://search-careers.gm.com/en/locations/) We are determined to lead change for the world through technology, ingenuity and harnessing the creativity of our diverse team. Join us to help lead the change that will make our world better, safer and more equitable for all by becoming a member of GM’s Talent Community (beamery.com) (https://flows.beamery.com/generalmotors/talcom) . As a part of our Talent Community, you will receive updates about GM, open roles, career insights and more. Please note that filling out the form below will not add you to our Talent Community automatically; you will need to use the link above. If you are seeking to apply to a specific role, we encourage you to click “Apply Now” on the job posting of interest. 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.

About the Company

G

General Motors

LEADING THE CHARGE INTO TOMORROW
AtGeneral Motors, we are passionate about earning customers for life. This vision unites us as a team each and every day and is the hallmark of our customer-driven culture. In fact, there are a lot of exciting things to share about our company.

Our story starts on November 18, 2010, when we completed the world’s largest initial public offering, emerging with a solid financial foundation that enables us to produce great vehicles for our customers and build a bright future for employees, partners and shareholders.Leading the way is our seasoned leadership team who set high standards for our company so that we can give you the best cars and trucks.
COMPANY SIZE
10,000 employees or more
INDUSTRY
Automotive Sales and Repair Services
FOUNDED
1908