Develop and maintain advanced Power BI dashboards and reports for marketing analytics clients. Gather stakeholder requirements, define reporting solutions, transform and model data, implement Power BI Service features, and deliver actionable insights. Serve as the reporting subject matter expert, provide best-practice guidance, collaborate with data teams, support client presentations, and ensure reporting projects meet goals and milestones.
Job Description:
Business Intelligence – Lead Analyst (DCF Level - 30)
Job Description:
A qualified professional with experience in developing highly visual dashboards and reports optimizing multiple marketing channels. The Senior 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 to identify reporting needs and deliver the solution.
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 problem, 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:
- 3+ year of experience in data analysis and visualization
- Expertise in in BI/Visualization tools, specifically Power BI (certification must have).
- Strong proficiency in:
- DAX (Data Analysis Expressions) for creating calculated columns, measures, and KPIs.
- Power Query (M language) for data transformation and ETL processes.
- Data Modelling including star schema, snowflake schema, and normalization techniques.
- 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.
Location:
DGS India - Pune - Indiqube OrchidBrand:
MerkleTime Type:
Full timeContract Type:
PermanentSimilar Jobs
AdTech • Marketing Tech
Develop and maintain interactive Power BI dashboards and reports for marketing effectiveness. Gather stakeholder requirements, define reporting best practices, perform data analysis, and deliver actionable insights. Serve as the reporting subject matter expert, coordinate with internal and external stakeholders, support client presentations, and oversee report design, development, deployment, maintenance, security, and refresh processes.
Top Skills:
DaxGoogle BigqueryGoogle ComposerGoogle DataformLookerM LanguagePower BIPower QuerySQL
Information Technology • Consulting
Designs, builds, maintains, and optimizes business dashboards and reports using Power BI, Microsoft Fabric, or Tableau. Defines KPIs, develops semantic layers and star-schema data models, validates data accuracy, collaborates with stakeholders, and implements performance improvements, usability enhancements, row-level security, and access controls.
Top Skills:
DaxMicrosoft FabricPower BIPower QuerySQLTableau
Marketing Tech • Social Impact • Analytics • Consulting
Designs, develops, and maintains Power BI dashboards, reports, and data models. Writes DAX calculations, performs data transformation with Power Query, connects to diverse data sources, and manages refreshes, workspaces, gateways, datasets, and row-level security. Collaborates with stakeholders to gather requirements, deliver actionable insights, optimize performance, document solutions, and troubleshoot user issues.
Top Skills:
APIsDaxExcelGoogle Cloud Platform (Gcp)Microsoft Power BiPower AutomatePower Bi ServicePower QueryPythonSQL
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
