We use cookies. You have options. Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.
We’d like to use cookies on your device. Cookies help us keep the site running smoothly and inform some of our advertising, but how we use them is entirely up to you. Accept our recommended settings or customise them to your wishes.
×

Media Analytics - Power BI & Python - Sr. Associate

Location: London, England.
Company Description:

About Merkle

Merkle is a leading data-driven, technology-enabled, global performance marketing agency that specialises in the delivery of unique, personalised customer experiences across platforms and devices. We call it ‘people-based’ marketing, and with over 25 years’ experience, we are proud to be recognised as a global leader.

Merkle’s heritage in data, technology and analytics is the foundation for our understanding of consumer insights that drives our people-based marketing strategies. Combined with our expertise in performance creative and media, we can then offer our clients content-driven, contextual and compelling customer experiences that drive business growth.

In 2016, the agency joined dentsu, one of the world’s biggest media companies to form the Customer Experience Management (CXM) Line of Business.

Job Description:
  • Translate business needs to technical specifications
  • Design, build and deploy BI solutions (e.g. reporting tools)
  • Maintain and support data analytics platforms (e.g. MicroStrategy)
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing Power BI dashboards and reports
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
Qualifications:
  • Proven experience as a Power BI on Development side
  • More than 4 years of experince 
  • Excellent knowledge of Python
  • Having clear understanding of Media Analytics KPI, Data analysis and building dashboards
  • Proven experience as a Power BI on Development side
  • Excellent knowledge of Python
  • Having clear understanding of Media Analytics KPI, Data analysis and building dashboards
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Proficient in making DAX queries in Power BI desktop.
  • Expertise in using advance level calculations on the data set.
  • Responsible for design methodology and project documentation.
  • Able to develop tabular and multidimensional models that are compatible with warehouse standards.
  • Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
  • Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
  • Should have knowledge and experience in prototyping, designing, and requirement analysis.
  • Should have knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc.
  • Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Also, one must be experienced in developing custom visuals for Power BI.
  • Familiarity with BI technologies (e.g. Datorama, Tableau etc)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Proven abilities to take initiative and be innovative
  • Analytical mind with a problem-solving aptitude
Additional Information:

At the point of application, the candidate must have the legal right to work in the UK as we are unable to sponsor visas as this time.

Merkle does not discriminate against job applicants on the basis of age, disability, gender reassignment, marital or civil partner status, pregnancy or maternity, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation. Experience stipulated in this job description serves as a guide only and all applications will be considered on their merits, irrespective of experience.

As part of our Diversity and Inclusion agenda, and as an Equal Opportunities employer, if you require reasonable adjustments during the selection process please engage directly with your Recruiter.

More Information:

Our Culture: Merkle’s energy and personality lives through everything we say and do. Learn all about what defines our people and our vibe.

Students & Recent Graduates: Start your career at Merkle and get on the path to success.

Experienced Hires: Leverage your expertise, challenge the status quo and grow your career at Merkle.