Data Cloud Architect

Ford Motor • Dearborn, MI

22h • Remote

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, Computer Engineering, Data Engineering, Data Science or a related field and 7 years of progressive, post-baccalaureate experience in the job offered or a related occupation.
• 7 years of experience with each of the following skills is required: 1. Analyzing different Data Sources including DB2, SQL Server, Oracle and Flat files from which data is coming and understand the relationships by analyzing the source and build solution architecture.
• 2. Application of data warehousing, data lake architectures, and advanced data modeling techniques.
• 3. Utilizing SQL and Python programming languages for complex data processing, transformation, analysis, and automation tasks, integrated with version control (Git), CI/CD practices, and preparing data for consumption by Business Intelligence (BI) tools (Looker and Tableau).
• 3 years of experience with each of the following skills is required: 1. Using Tableau, Power BI, and IBM Cognos Analytics BI tools to develop numerous custom business intelligence reports, dashboards, and data extracts for business units/departments including Capital Markets, Secondary Markets, Quantitative Risk Management, Mortgage Subservicing, Mortgage Servicing, and Mortgage Origination.
• 2. Creating GitHub repository to manage ETL DataStage/Informatica and PL/SQL code versions.
• 3. Creating Python programs to parse and load complex source data into a target database.
• 4. Using Microsoft Access, SQL, and VBA to develop databases, data queries, reports, logic statements, database business rules, and graphical user interfaces (forms) for data entry by business users.

Responsibilities

• Provide technical stability and anchoring for a team of data scientists, data engineers, and BI specialists.
• Design and architect highly scalable and performant data solutions on GCP, leveraging services such as BigQuery, Dataflow, Dataproc, and Cloud Storage.
• Develop and maintain CI/CD pipelines using Tekton, ensuring automated deployments to Cloud Run and other GCP services.
• Implement robust data governance and security policies, adhering to OIC compliance standards.
• Develop and maintain Terraform infrastructure-as-code for consistent and repeatable deployments.
• Collaborate with stakeholders to define and implement key performance indicators (KPIs) and metrics.
• Oversee data modeling, data warehousing, and data lake design and implementation.
• Champion the adoption of best practices in data engineering and data architecture.
• Utilize GitHub for version control, code review, and collaborative development.
• Work closely with BI specialists to create interactive dashboards and reports using Looker, Data Studio, and other BI tools.
• Manage and mentor team members, fostering a collaborative and innovative environment.

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: Mid Level