Media Analytics - Power BI & Python - Sr. Associate

  • 10 Triton St, London NW1 3BF, UK
  • Full-time

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.

Privacy Policy