Data Engineer, Dealer Training & Productivity - Ford Motor Company

We are the movers of the world and the makers of the future. We get up every day, roll up our sleeves and build a better world -- together. At Ford, we're all a part of something bigger than ourselves. Are you ready to change the way the world moves? 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. We are currently seeking a seasoned GCP Cloud Data Engineer with at least 4 years of experience in designing data models and leading/implementing GCP data projects., You will design data warehouse/data marts, build ETL pipelines to ingest and land data from heterogeneous sources into our system. You should have excellent business and communication skills and be able to work with business owners to understand their data requirements and help them make data-related decisions. You should be an excellent coach and help upskill the subject matter experts build data engineering skills/toolsets. The job role might also require you to learn new tools and technologies fast, and you should have in-depth database knowledge as well as basic programming (Java, Python) and scripting skills. You will help to build efficient and stable data pipelines which can be easily maintained in the future. You should have expertise in the design, creation, management, and business use of large datasets. **In this position...** + Work with Product owner, Architect teams, functional SMEs to design and implement modern, scalable data solutions using a range of new and emerging technologies from the Google Cloud Platform. + Migrate on Prem Applications to GCP products. Ensure data model redesign is done by understanding business needs from functional SMEs. + Understand business requirements, lead design discussions, create logical data models, physical data models and data dictionaries for data warehouse/data marts. Manage and maintain data models in Power Designer repository. **What you'll do...** + Use architecture recommended existing ingesting patterns and build pipeline from different sources and create data warehouse / data marts in GCP Big Query. + Analyze and profile data from different source systems and provide data architecture design recommendations. + Work with Agile and DevOps techniques and implementation approaches in the delivery. + Be required to build and deliver Data solutions using GCP products and offerings. + Help team Upskill themselves in GCP data technologies. + Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. + Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users. + Ensure that the data architecture is scalable and maintainable. + Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions. **You'll have...** + Bachelors Degree in Computer Science, Engineering, or similar technology discipline. + Total of 6+ years of experience in IT including a minimum of four years in dataengineering. + Deep knowledge and understanding of Data Warehouse and Data Mart Concepts. + Experience in designing logical data models, creating physical data models for transactional systems and/or data warehouse and data marts. + Ability to create and manage data models using Power Designer / ERWIN / Data Modeling tools. + Experience working in Hadoop, particularly with HDFS and Hive. + In-depth knowledge and hands-on experience in GCP cloud-native services such as BigQuery, Dataflow, Pub/Sub, Cloud Data Fusion, Cloud Composer and Google Data Studio etc. + Experience in architecting and designing solutions leveraging services like Cloud Bigquery, Cloud Data Flow, Cloud Pub OR Sub, Cloud BigTable. + Familiarity with the technology stack available in the industry for metadata management: Data Governance, data quality. + Familiarity with the Technology stack available in the industry for data management, data ingestion, capture, processing and curation. + Extensive experience in Data migration. + Experience with object-oriented/object function scripting languages: Java/Python. + Build/maintain ETL pipelines, auditing, Dataplex. **Even better, you may have...** + GCP Data engineer certification. + Experience with object-oriented/object function scripting languages: Java, Terraform etc. + Experience with CICD pipeline and GitHub. + E2E Data Engineering and Lifecycle (including non-functional requirements and operations) management. + E2E Solution Design skills - Prototyping, Usability testing and data visualization literacy. + Exposure to the Looker BI tool/Alteryx is a plus. You may not check every box, or your experience may look a little different from what we've 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 builder...or all of 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 Year's Day - Paid time off and the option to purchase additional vacation time. For a detailed look at our benefits, click here: https://fordcareers.co/GSR-HTHD This position is a salary grade 8. Visa sponsorship is available for this position. Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. We are an Equal Opportunity Employer committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660. \#LI-Remote **Requisition ID** : 26123