설명
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
다양성 정보
General Motors는 법적으로 금지된 차별을 배제하는 것은 물론 포용성과 소속감을 진정으로 장려하는 직장이 되기 위해 노력하고 있습니다. 당사는 다양성이 보장되는 환경에서 직원들이 역량을 발휘하고 우리 고객을 위한 더 좋은 제품을 개발할 수 있다고 믿습니다. 따라서 입사에 관심 있는 사람이 있다면 포지션별 주요 업무와 자격을 확인하고 본인이 보유한 기술과 능력에 부합하는 모든 포지션에 적극적으로 지원하기를 장려합니다. 지원자는 채용 과정에서 역할 관련 평가(해당하는 경우) 및/또는 채용 전 스크리닝을 통과해야 합니다. 자세한 정보는 GM 채용 과정 안내를 참고하십시오.
공평한 취업 기회 선언 (미국)
General Motors는 공평한 기회를 제공하는 고용주임을 자부합니다. 자격을 만족하는 지원자는 인종과 피부색, 성별, 성적 지향, 성별 정체성, 국적, 장애, 재향 군인 보호법 적용 여부와 상관없이 채용 후보로서 심사를 받습니다.
숙소 (미국 및 캐나다)
General Motors는 장애인을 포함한 모든 구직자들에게 취업 기회를 제공합니다. 구직이나 취업 지원에 도움이 되는 합리적인 숙소가 필요한 경우 [email protected]으로 이메일을 보내시거나 800-865-7580으로 전화주십시오. 이메일에, 귀하가 요청하는 특정한 숙소에 대한 설명과 귀하가 지원하는 직무와 채용 요청서 번호를 포함해주세요.