Google · google.com · checked today
Senior Data Engineer, Product Analytics, Payments
As a Technical Solutions Consultant, you will be responsible for the technical relationship of our largest advertising clients and/or product partners. You will lead cross-functional teams in Engineering, Sales and Product Management to leverage emerging technologies for our external clients/partners. From concept design and testing to data analysis and support, you will oversee the technical execution and business operations of Google's online advertising platforms and/or product partnerships.
Skills, with evidence
- Data modelling
5 years of experience designing and deploying data pipelines, including managing data schemas and processing data volume workflows.
must have - Data quality
Drive data quality, reliability, and governance standards across critical analytics systems.
must have - Python
5 years of experience coding in Python and SQL.
must have - SQL
5 years of experience coding in Python and SQL.
must have - Machine learning
5 years of experience working with machine learning operations and data architecture design.
must have · not practised here - Governance & security
Drive data quality, reliability, and governance standards across critical analytics systems.
not practised here
Your plan
- The SQL screen: correct, then fast≈ 2 h
Data quality · SQL
- Median delivery time per cityIntermediate
- Bucket deliveries into quartilesIntermediate
- Median order value without a median functionIntermediate
- New and repeat orders by monthIntermediate
- Every order against its customer's averageIntermediate
- Python: the data-wrangling round≈ 3 h
Python
- Diff two snapshots of a tableIntermediate
- Explode an array column into rowsIntermediate
- Flatten nested event payloadsIntermediate
- Pivot a long metrics table to wideIntermediate
- Choose what an incremental run should readIntermediate
- Data modelling: the round most people fail≈ 3 h
Data modelling
- Addresses that stay true to the pastIntermediate
- Seat holds and the release-night raceIntermediate
- Subscription warehouse grainIntermediate
- Campaign efficiencyIntermediate
- Catalogue: products, variants and sellersIntermediate
- Say it out loud≈ 1 h
Not covered by the plan: Machine learning, Governance & security.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 6 dremoved the moment Google closes it