Full Stack Software Engineer – TeradataETLDataStage
Dearborn, MI - USA
Job Summary
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 tomorrows transportation.
Enterprise Technologyplays a critical part in shaping the future of mobility. If youre looking for the chance to leverage advanced technology to redefine the transportation landscape enhance the customer experience and improve peoples 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.
Responsibilities
What youll be able to do:
Full Stack Software Engineer Teradata/ETL/DataStage - positions offered by Ford Motor Company (Dearborn Michigan). 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. 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.
Qualifications
Youll have...
Bachelors 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 each of the following skills is required: 1. Using Teradata ecosystem including BTEQ FastLoad MultiLoad and Tpump. 2. Designing and building ETL pipelines and data warehouses using PL/SQL. 3. Understanding of data warehousing concepts including dimensional modelling (star/snowflake schemas) and data integrity. 4. Using SQL with performance tuning complex queries. 5. UNIX/Linux environments and shell scripting. 6. Data modelling and designing logical and physical database schemas. 3 years of experience with each of the following skills is required:1. Developing complex ETL workflows with IBM DataStage. 2. Systems analysis production support and root cause analysis for data-related issues. 3. Creating and executing test plans for data quality and reconciliation. 1 year of experience with each of the following skills is required: 1. Understanding of data governance principles including coding standards code review processes and metadata management. 2. Working with sensitive data (PPI) and understanding the associated security and handling requirements.
We are offering a salary of$140629.00 - $178448.52/yr.
You may not check every box or your experience may look a little different from what weve outlined but if you think you can bring value to Ford Motor Company we encourage you to apply!
As an established global company we offer the benefit of choice. You can choose what your Ford future will look like: will your story span the globe or keep you close to home Will your career be a deep dive into what you love or a series of new teams and new skills Will you be a leader a changemaker a technical expert a culture builderor all the above No matter what you choose we offer a work life that works for you including:
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 Years Day
Paid time off and the option to purchase additional vacation time.
For a detailed look at our benefits click here:
#LI-DNI
#DNP
Required Experience:
IC
About Company
Ford® is Built for America. Discover the latest lineup in new Ford vehicles! Explore hybrid & electric vehicle options, see photos, build & price, search inventory, view pricing & incentives & see the latest technology & news happening at Ford.