Lead // Power BI // (6-9.5 years )

About the client

Join a premier global creative powerhouse with an unparalleled international outlook, shaping the future of advertising in India and worldwide. We are an integrated network where cutting-edge technology drives our solutions. Work on iconic national brands, leveraging advanced data and future-forward platforms to deliver massive, real-world impact. We foster an inclusive, high-performance culture that empowers you to own your career path and build your legacy on a global stage. This is your platform for unlimited growth and defining the next era of brand communication.

Job Description:

A qualified professional with experience in developing highly visual dashboards and reports, optimizing multiple marketing channels. The Lead Analyst role is focused on supporting our clients with reporting capabilities and will be driving the overall engagement in developing dashboards and reports on strategic clients and helping measure their overall marketing effectiveness. Will serve as a point of contact between multiple stakeholders, both internal and external,l to identify reporting needs and deliver the solution.

Requirements
Designation: Lead

Job Location: Coimbatore / Bangalore / Mumbai / Pune

In-person drive in Kolkata shortly

Key Responsibilities:

• Gather and analyse reporting requirements from stakeholders, including new data needs, report layout preferences, and business objectives.
  
• Develop and maintain advanced interactive dashboards and reports that provide actionable insights to stakeholders.
  
• Provides strategic, technical, and or operational reporting best practices and guidance.
  
• Reporting expertise and knowledge to solve business challenges and provide focus to team members.
  
• Ability to formulate analytical problems, summarize key findings/insights and make helpful recommendations.
  
• Thought leadership and guidance in the development of client-facing presentations and read-outs.
  
• Drives the overall client engagement as the reporting Subject Matter expert (SME) in delivering reporting solutions while collaborating with data team.
  
• Analysis of reporting requirements; including new data requirements, reporting layout and user needs.
  
• Define best practices and the design/development, deployment, and maintenance of reports. Ensures that project goals/milestones are met.
  

Required Skill:

Must have:

GCP tools: BigQuery, Dataform, Composer, Looker, PowerBI (Power BI certification is good to have)

• 6+ years of experience in data analysis and visualization
  
• Expertise in in BI/Visualization tools, specifically Power BI (certification must have).
  
• Strong proficiency in:
  

o DAX (Data Analysis Expressions) for creating calculated columns, measures, and KPIs.

o Power Query (M language) for data transformation and ETL processes.

o Data Modelling, including star schema, snowflake schema, and normalization techniques.

o Power BI Service: row-level security (RLS), workspace management, app deployment, gateway configuration, and scheduled refreshes.

• Degree in computer science, information systems, or another technology-related field.
  
• Intermediate proficiency in SQL, Google BigQuery.
  
• Strong analytical and problem-solving skills.
  
• Excellent communication and presentation abilities.
  
• Good to have - Familiarity with Google Dataform, Composer and Looker.
  
• Optional: Marketing Analytics experience.