Job Summary:
We are seeking a skilled Data Engineer with a strong background in Google Cloud Platform (GCP) and BigQuery to join our team. The ideal candidate will have extensive experience in building data dashboards using Looker Studio, developing webhooks and scripts with Google Apps Script, and creating comprehensive Google reporting. This role also involves matching and combining data from various sources, including Google Ads and backend CRM systems, to generate insightful data analyses and reports. We are also open to using Tableau, Power BI if you are highly experienced in these areas.
Key Responsibilities:
-Design, develop, and maintain data dashboards in Looker Studio.
-Utilize Google Apps Script to build webhooks and automate data workflows.
-Create and manage Google reporting, ensuring data accuracy and consistency.
-Match and combine data from Google Ads, backend CRM systems, and other data sources.
-Conduct data analysis to generate actionable insights and support business decisions.
-Collaborate with cross-functional teams to understand data needs and deliver solutions.
-Ensure data integrity and security across all platforms.
Qualifications:
-Proven experience as a Data Engineer or similar role, with a focus on GCP and BigQuery.
-3-5 years of experience in data analysis, business intelligence, or data dashboard development.
-Proficiency in Looker Studio for building interactive and dynamic dashboards.
-Proficiency in data visualization tools such as Google Looker Studio, Tableau, Power BI, or similar.
-Strong knowledge of Google Apps Script for automating tasks and creating webhooks.
-Experience with data matching and combining data from various sources.
-Familiarity with Google Ads and its data structure.
-Excellent analytical and problem-solving skills.
-Strong communication and collaboration abilities.
-Ability to work independently and manage multiple tasks simultaneously.
Preferred Skills:
-Experience with other GCP services such as Cloud Functions, Cloud Storage, and Dataflow.
-Knowledge of SQL and other data querying languages.
-Understanding of data warehousing concepts and ETL processes.
-Familiarity with backend CRM systems and their data structures.
-Previous experience in a similar role within the advertising or marketing industry.
How to Apply:
If you are a data enthusiast who excels in a dynamic, agile startup environment and can craft data dashboards that empower informed decision-making, we want to hear from you! Please submit your resume, accompanied by a cover letter outlining your relevant experience. If available, include any portfolio pieces or work samples that showcase your expertise.
APPLY FOR THIS JOB:
Company: Mercian Accountants / Clarke & Wright
Name: Chris Roy
Email: