GPSC Demand Supply Planning - Senior Database Developer - GM Global Technical Center - Michigan IT Innovation Center

Job Description

Work Arrangement

This role is categorized as hybrid. This means the successful candidate is expected to report to Austin, TX or Warren, MI three times per week, at minimum [or other frequency dictated by the business].

What You’ll Do :

We are looking for a Senior Database Developer to join our team and support our Oracle to PostgreSQL migration, data analytics, and machine learning initiatives. You will work with agile methodologies such as SAFe and collaborate with other developers, analysts, and stakeholders to deliver high-quality solutions. You will also be responsible for developing ETL to source data for business intelligence reporting.

As a Senior Database Developer, you will:

• Design, develop, test, and optimize database schemas, queries, functions, and procedures for Oracle and PostgreSQL platforms
• Implement data quality, security, and performance best practices
• Develop ETL pipelines to extract, transform, and load data from various sources into data warehouses and data lakes
• Support data analytics and machine learning projects by providing data access, integration, and validation
• Troubleshoot and resolve database issues and provide technical support
• Document database design, development, and maintenance processes
• Mentor junior developers and share knowledge and best practices

Additional Job Description

Your Skills & Abilities (Required Qualifications)

• Bachelor's degree in Computer Science, Engineering, or related field
• At least 7 years of experience in database development using Oracle, PostgreSQL, or SQL Server
• Proficient in SQL, PL/SQL, PL/pgSQL, Python, and shell scripting
• Experience with industry leading large-scale database platforms and speed layers (e.g. Dremio, Kubernetes, Elastic Storage System, Greenplum, Hadoop)
• In-depth understanding, and experience modeling, of dimensional data models (facts, dimension, star schema, etc.)
• Experience (5+ years) with implementing solutions using the complete Microsoft BI stack (SSIS. SSAS, Power BI)
• Experience with ERWIN or another data modeling tool (5+ years)
• Experience with ETL tools such as Informatica, DataStage, SSIS, etc.
• Excellent communication, problem-solving, and teamwork skills

What Will Give You A Competitive Edge (Preferred Qualifications)

• Experience in providing data/ analytics solution, subject matter expertise in data and processes for Automotive Supply Chain space (Specifically Demand and Supply Capacity Planning).
• Experience with data analytics and machine learning frameworks such as Spark, TensorFlow, or PyTorch
• Experience with optimization and performance tuning of database and analytics solution stack.
• Experience with database change management processes and tooling such as LiquiBase
• Strong problem solver with ability to evaluate a challenge and understand solution patterns
• Experience with enabling batch data process orchestration

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 aspire to be the most inclusive company in the world. 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. Our Work Appropriately philosophy supports our foundation of inclusion and provides employees the flexibility to work where they can have the greatest impact on achieving our goals, dependent on role needs. Every day, we want every employee, no matter their background, ethnicity, preferences, or location, to feel they belong to one General Motors team.

Benefits Overview

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.

Diversity Information

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.

Equal Employment Opportunity Statements

GM is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices laws. GM is committed to providing a work environment free from unlawful discrimination and advancing equal employment opportunities for all qualified individuals. As part of this commitment, all practices and decisions relating to terms and conditions of employment, including, but not limited to, recruiting, hiring, training, promotion, discipline, compensation, benefits, and termination of employment are made without regard to an individual's protected characteristics. For purposes of this policy, “protected characteristics" include an individual's actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, weight, height, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state or local laws and ordinances.  If you need a reasonable accommodation to assist with your job search or application for employment, email us at Careers.Accommodations@GM.com or call us at 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.​