Media Analytics - Power BI & Python - Sr. Associate (Ref Code : IDC 2021)

  • Full-time

Company Description

Merkle is a global data-driven, technology-enabled performance marketing agency and the largest independent agency in the US for CRM, digital, and search. For more than 28 years, Fortune 1000 companies and leading nonprofit organizations have partnered with us to build and maximize the value of their customer portfolios. We work with brands like Dell, T-Mobile, Samsung, Geico, Regions, Kimberly-Clark, AARP, Lilly, Sanofi, NBC Universal, DIRECTV, American Cancer Society, Susan G. Komen, and many others to build and execute customer centric business strategies.   

Job Description

 

  1. Translate business needs to technical specifications
  2. Design, build and deploy BI solutions (e.g. reporting tools)
  3. Maintain and support data analytics platforms (e.g. MicroStrategy)
  4. Conduct unit testing and troubleshooting
  5. Evaluate and improve existing Power BI dashboards and reports
  6. Collaborate with teams to integrate systems
  7. Develop and execute database queries and conduct analyses
  8. Create visualizations and reports for requested projects
  9. 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 aptitud 
Privacy Policy