Senior Full Stack ETL Engineer

Job Description

Workplace Classification:

Hybrid: This role is categorized as hybrid. This means the candidate is expected to report to their primary work location (Austin, TX or Warren, MI) three times per week, at minimum, or other frequency dictated by the business

The Team:

The Quality Issue & Incident Management group is a persistent team that supports the Global Quality business organization. The team is compromised of developers and Business Analysts that support GIMS, Partlink, QPS, and RedX applications. Partlink deals with warranty claims and supplier cost recovery.

All of the applications in this space have the following tech stack: Java/Springboot/Angular/Kubernetes/Oracle or Postgres DB. The roadmap for this team is a cloud first approach (Postrgres and Azure migration) and business enhancements for the next two years.

The Role

As a Senior Full Stack ETL Engineer, you will have the opportunity to work hands-on writing software or solutions, based on detailed requirements and system specifications. Using sound, repeatable, industry standard methodologies, you will support the VEQ organization responsible for developing Nextgen applications. As part of development activities, we will update existing software and/or develop new software solutions to target specific business obstacles. A repeatable, systematic, and quantifiable approach to the development process will also be applied along with the use of appropriate methodologies.

As a coach/mentor, you will provide feedback on the software being developed to software developers. Ensure code alignment with design patterns/frameworks by working closely with architects and data scientists.

What You’ll Do (Responsibilities):

• Developing enterprise-grade applications using Kubernetes/Docker, Quarkus, Java, Angular, and PostgreSQL, among other tools.
• Collaborate with cross-functional teams to lead GM’s transition to cloud technologies.
• Collaborating with developers, analysts, and other stakeholders to understand data requirements and deliver appropriate solutions.
• Proactively engage in the identification / remediation of software issues such as code quality, pattern mismatch, and security issues related to the code or solution/configuration.
• Providing guidance and mentoring of fellow software engineers and other team members.
• Ability to navigate complex corporate environments and processes to remove project roadblocks.
• Understands code quality analysis results and remediation mechanisms.
• Strong Knowledge of maintaining and debugging live software systems.
• Demonstrable experience in database development and management, including designing, building, and optimizing database solutions.
• Proven ability to identify and resolve performance bottlenecks, optimize queries, implement indexing strategies, and utilize database monitoring tools.
• Experience in implementing various branching strategies and sharing that expertise with your team.
• Advanced CI/CD knowledge including automated builds and deployments and developing pipelines with GitHub Actions.
• Document software solutions and ensure that technical documentation meets GM standards.
• Understand and maintain compliance with GM standards and industry standard methodology.

What You'll Need (Required Qualifications):

• At least 7 years experience in Full-Stack Development
• Proficiency in SQL is crucial, including writing complex queries, stored procedures, functions, triggers and views in PostgreSQL
• 3+ years experience in Kubernetes/Docker or Quarkus, and cloud platforms such as AWS, Azure, or GCP
• 3+ years experience working in a SCRUM development methodology
• Demonstrate mastery of many programming languages, tools and/or technologies primarily Spring Boot, Angular, Hibernate, Postgres, HTML, Java, JavaScript
• Strong Knowledge of maintaining and debugging live software systems
• Strong debugging capabilities in the remediation of software issues related to code/solutions quality and/or security
• Automates unit/end-to-end testing of software systems within their domain, focused on software quality and maintainability
• Integrate software with existing software/systems
• Aggressively engage in the identification / remediation of software issues related to code or solutions quality, security, and/or pattern/frameworks and software usability or end user related issues
• Good understanding of software development be