GCP Data Engineer

What you will do:

• Grow into a Lead Google Cloud Platform Engineer responsible for development activities, and ensuring coherent roadmap and implementation. This includes landing processes, data cleansing and datamart processes and overall automation.
• Develop and maintain master data processes to allow us to bring all data together in a clean, coherent way.
• Develop database and data processing architecture that is efficient, flexible and accurate.
• Lead change management processes when updating data and reporting processes.
• Provide design validation and troubleshooting for new technology and major changes within the environment.
• Ensure reports follow best practices for visualization and usability.

Develop Analytical Resources

• Develop and maintain the databases, tables and views in BigQuery for all digital analytics datasources. This means understanding how analysts need to report on data and create those base-level tables to make that possible.
• Experience working with High Volume Datasets.
• Experience working with Advanced SQL in BigQuery.
• Understanding of google cloud composer, dataprep and transfer jobs
• Understanding of tableau and ability to investigate data anomalies.
• Create a Minimum Viable Product for analyst to demonstrate how new. features (released with each version) can enhance the tableau report.
• QA and verify accuracy of all data through transformations, ensuring accuracy.
• Do custom data pulls for specific analytics projects.

python-nice to have

ga360-nice to have

Manage Day-to-day operations

• Manage day-to-day data operations of the datamarts, data loads and our analytics requests. This includes emergency fixes, routine updates, general tending of processes.
• Create automation in Google Cloud Platform including monitoring
• Support analysis and predictive analysis development
• Help non-developer analysts access data through SQL coaching, pre-built queries and other resources
• Document data and analytics resources for general consumption
• Conduct regular training and ad-hoc coaching with analytics staff.

WHAT YOU WILL BRING:

• Experienced working directly with large volumes of data using cloud platforms, specifically Google Cloud Platform, SQL, Python, Alteryx, R and other large-scale data technologies.
• Experience with digital datasources such as Google Analytics, Google Ad Manager etc. preferred.
• Our business changes quickly so the ability to explore, understand new data, and resolve problems on deadline is key