Tech Stack
AWSBigQueryCloudETLGoogle Cloud PlatformHadoopInformaticaPythonSQL
About the role
- Pro 360 Product Group responsible for strategy & delivery of 360 data services empowering Ford Pro modern business intelligence and advanced analytics solutions
- Develop EL/ELT/ETL pipelines to make data available in BigQuery analytical data store from disparate batch and streaming sources for the Business Intelligence and Analytics teams
- Work with on-prem data sources (Hadoop, SQL Server), understand data models and business rules and build data pipelines (with GCP, Informatica) landing data in GCP BigQuery
- Build cloud-native services and APIs to support and expose data-driven solutions
- Partner closely with data scientists to ensure the right data is made available in a timely manner
- Design, build and launch shared data services for internal and external partner developer community
- Build scalable data pipelines and choose the right tools; manage, optimize and monitor data pipelines
- Provide extensive technical and strategic advice and guidance to stakeholders around data transformation efforts
Requirements
- Bachelors Degree
- 3+ years of experience with SQL and Python
- 2+ years of experience with GCP or AWS cloud services; Strong candidates with 5+ years in a traditional data warehouse environment (ETL pipelines with Informatica) will be considered
- 3+ years of experience building out data pipelines from scratch in a highly distributed and fault-tolerant manner
- Comfortable with a broad array of relational and non-relational databases
- Proven track record of building applications in a data-focused role (Cloud and Traditional Data Warehouse)