Description
At Ford Motor Company, we believe freedom of movement drives human progress. We're seeking a Full Stack Software Engineer to join our Enterprise Technology team. As a Full Stack Software Engineer, you will lead the design, development, and deployment of robust, scalable, and high-performance data pipelines on Google Cloud Platform (GCP). Your responsibilities will include driving the migration of on-premise and legacy data processes to native GCP services, implementing and managing Continuous Integration/Continuous Deployment (CI/CD) pipelines using Tekton, and utilizing Terraform to provision and manage GCP infrastructure as code.
You will work extensively with GCP services such as BigQuery, Dataflow, IBM CloudPak, and Apache Airflow. Collaboration with cross-functional teams to understand data requirements and translate them into technical solutions is essential. Conducting thorough analysis of existing data systems, identifying areas for improvement, and integrating diverse data sources are also key responsibilities.
As a Full Stack Software Engineer, you will perform rigorous performance tuning and optimization of data pipelines and queries. Providing proactive production support, diagnosing and resolving complex technical challenges efficiently, is crucial. Actively participating in code reviews, mentoring junior engineers, and contributing to the evolution of engineering best practices and coding standards are also expected.
You will contribute to data modeling efforts, potentially using tools like Power Designer. A bachelor's degree in Computer Science or Information Technology and 7 years of progressive, post-baccalaureate experience in the job offered or a related occupation are required. 5 years of experience with each of the following skills are required: using Teradata ecosystem, designing and building ETL pipelines and data warehouses using PL/SQL, understanding of data warehousing concepts, using SQL with performance tuning complex queries, UNIX/Linux environments and shell scripting, and data modelling and designing logical and physical database schemas.
3 years of experience with each of the following skills are required: developing complex ETL workflows with IBM DataStage, systems analysis, production support, and root cause analysis for data-related issues, and creating and executing test plans for data quality and reconciliation. 1 year of experience with each of the following skills is required: understanding of data governance principles, working with sensitive data (PPI) and understanding the associated security and handling requirements.