Full Stack Software Engineer – Teradata/ETL/DataStage

Ford Motor • Dearborn, MI

2d • Hybrid

About The Position

At Ford Motor Company, we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility, we have a wide variety of opportunities for you to accelerate your career potential as you help us define tomorrow’s transportation. Enterprise Technology plays a critical part in shaping the future of mobility. If you’re looking for the chance to leverage advanced technology to redefine the transportation landscape, enhance the customer experience and improve people’s lives, this is the opportunity for you. Join us and challenge your IT expertise and analytical skills to help create vehicles that are as smart as you are.

Requirements

• Bachelor’s degree or foreign equivalent in Computer Science or Information Technology and 7 years of progressive, post-baccalaureate experience in the job offered or a related occupation.
• 5 years of experience with using Teradata ecosystem, including BTEQ, FastLoad, MultiLoad, and Tpump.
• 5 years of experience with designing and building ETL pipelines and data warehouses using PL/SQL.
• 5 years of experience with understanding of data warehousing concepts, including dimensional modelling (star/snowflake schemas) and data integrity.
• 5 years of experience with SQL with performance tuning complex queries.
• 5 years of experience with UNIX/Linux environments and shell scripting.
• 5 years of experience with data modelling and designing logical and physical database schemas.
• 3 years of experience with developing complex ETL workflows with IBM DataStage.
• 3 years of experience with systems analysis, production support, and root cause analysis for data-related issues.
• 3 years of experience with creating and executing test plans for data quality and reconciliation.
• 1 year of experience with understanding of data governance principles, including coding standards, code review processes, and metadata management.
• 1 year of experience with working with sensitive data (PPI) and understanding the associated security and handling requirements.

Nice To Haves

• Note, this is a hybrid position whereby the employee will work both from home and from the aforementioned worksite. Hence, the employee must live within a reasonable commuting distance from the worksite.

Responsibilities

• Lead the design, development, and deployment of robust, scalable, and high-performance data pipelines on GCP.
• Drive the migration of on-premise and legacy data processes to native GCP services.
• Implement and manage CI/CD pipelines using Tekton for automated data pipeline deployments and testing.
• Utilize Terraform to provision and manage GCP infrastructure as code, ensuring consistency and repeatability.
• Manage source code, collaborate on development, and enforce best practices using GitHub.
• Work extensively with GCP services such as Big Query, Dataflow, IBM CloudPak, and Apache Airflow.
• Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
• Conduct thorough analysis of existing data systems, identify areas for improvement, and integrate diverse data sources.
• Perform rigorous performance tuning and optimization of data pipelines and queries.
• Provide proactive production support, diagnosing and resolving complex technical challenges efficiently.
• Actively participate in code reviews, mentor junior engineers, and contribute to the evolution of engineering best practices and coding standards.
• Contribute to data modeling efforts, potentially using tools like Power Designer.

Benefits

• Immediate medical, dental, and prescription drug coverage
• Flexible family care, parental leave, new parent ramp-up programs, subsidized back-up child care and more
• Vehicle discount program for employees and family members, and management leases
• Tuition assistance
• Established and active employee resource groups
• Paid time off for individual and team community service
• A generous schedule of paid holidays, including the week between Christmas and New Year's Day
• Paid time off and the option to purchase additional vacation time.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior