Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Data Sourcing & Preparation
Determine the data required for reporting purposes, identifying the right sources and the appropriate fields to meet them.
Build and prototype datasets structured for clean, efficient consumption in the reporting platform, using AI to accelerate preparation and…
Experience
5+ years
Education
Bachelor's degree
Must-have skills
Power BISQL
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
About the role
The Senior Analyst, Marketing Analytics is a data specialist on CBRE's Global Digital Marketing Analytics team, responsible for building and maintaining trustworthy, well-structured datasets and dashboards behind the team's marketing reporting. The focus is reliable data - correctly sourced, assembled, and validated - and reports the team can trust.
This is a role for someone who works with data fluently and independently: able to take a reporting goal, determine what data it requires, and shape it into a sound dataset and a clear dashboard. It suits someone who takes ownership of quality - checking for completeness, confirming data is merged correctly, validating against source systems, and catching problems before they reach a report.
It is also a role for someone who wants to work smarter, more efficiently. We expect this person to bring AI into how they work day to day - using it to speed up data preparation, validation, and dashboard development - and to continuously look for opportunities to automate repetitive work, so the team's reporting runs faster and more reliably.
What you'll do
Data Sourcing & Preparation
Determine the data required for reporting purposes, identifying the right sources and the appropriate fields to meet them.
Build and prototype datasets structured for clean, efficient consumption in the reporting platform, using AI to accelerate preparation and increase automation.
Combine data across multiple sources, ensuring it is merged and transformed correctly for the intended use.
Quality & Validation
Validate data for completeness and accuracy throughout the workflow and against source systems, applying AI to speed up checks and surface issues earlier.
Critically review and validate AI-generated output.
Own data quality as a standard, building checks into the process and serving as the quality backstop the team relies on.
Investigate and resolve discrepancies, recognizing when results do not hold up and tracing them to their source.
Reporting & Dashboards
Build, prototype, and maintain dashboards and BI products in the team's reporting platform.
Keep BI products accurate, current, and reliable over time, refining outputs as needs evolve.
Develop and maintain documentation for datasets, dashboards, and data processes, keeping it clear and current.
Identify and automate repetitive reporting tasks, reducing manual effort and turnaround time.
Handle ad-hoc data pulls and requests, turning them around with accuracy and appropriate context.
Coordinate with the broader BI and insights teams so datasets and dashboards support how reporting and interpretation are used.
Ways of working
Look for opportunities to work smarter - evaluating new AI tools and approaches and adopting them where they raise the quality or efficiency of the team's data and reporting work.
What you'll need
3 5 years of experience working hands-on with data analysis and reporting; experience in marketing analytics or digital analytics a plus.
Strong data preparation and transformation skills, with the ability to source, combine, and shape data from multiple systems into clean, reliable datasets. Proficiency in SQL for querying, combining, and transforming data; Python a plus.
Strong, hands-on skills building dashboards and BI products in Power BI; Data Studio (Looker) experience a plus.
Comfort using and experimenting with AI tools, and an interest in applying them to automate and improve data and reporting work.
Familiarity with the digital marketing stack a plus (e.g., Google Analytics, Google Tag Manager, Customer Data Platform).
Strong attention to detail and a sense of ownership over the accuracy of what the team produces.
Bachelor's degree in a quantitative, business, or related field.
Key skills
Required
Power BISQL
Preferred
Data AnalysisDigital MarketingGoogle AnalyticsPython
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?