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.
1) Dashboards and Reports
a) Design, build, and maintain business dashboards and reports
using Power BI, Microsoft Fabric, or Tableau depending on the
project stack
b) Ensure reports are accurate, visually clear, and aligned to
business objectives
c) Continuously refine and improve reports based on stakeholder
feedback
2) KPI and Metrics Design
a) Work with business teams to identify, define, and document Key
Performance Indicators (KPIs) and business metrics
b) Translate business requirements into structured data
visualization designs
c) Ensure consistency and standardization of KPI definitions across
all reports
3) Semantic Layer Development
a) Build and maintain the semantic layer including facts, dimensions,
hierarchies, and calculated measures
b) Design data models using Star Schema and Fact and Dimension
table structures
c) Ensure the semantic layer serves as a reliable and consistent
single source of truth for all reporting
4) Business Collaboration
a) Partner closely with business teams and stakeholders to
understand reporting needs.
b) Validate numbers, reconcile discrepancies, and ensure data
accuracy before reports go live
c) Gather and incorporate feedback iteratively to deliver reports
that truly serve business needs
5) Performance and User Experience Optimization
a) Optimize dashboard load times and query performance for large
datasets
b) Design reports with a focus on usability, clarity, and end-user
experience
c) Implement row-level security and access controls where required
Requirements
- Strong proficiency in Power BI, including DAX, Power Query, and data modelling
- Experience building semantic layers — facts, dimensions, and calculated measures
- Solid understanding of Star Schema and data warehousing concepts
- Strong attention to detail and a commitment to data accuracy
- Experience with SQL for data querying and validation
Similar Jobs
Fintech • Information Technology • Financial Services
Partner with investment, operations, and finance teams to translate business needs into BI dashboards, reporting, automation, and AI-enabled analytics using Power BI and SQL. Identify reporting gaps, capture requirements, and support adoption of AI-driven insights while liaising between business stakeholders and technical teams.
Top Skills:
Ai-Enabled AnalyticsAzurePower BIQlik/QlikviewSnowflakeSQLTableau
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
Business Intelligence
Design, develop, and maintain Power BI dashboards, reports, and data models. Translate business requirements into scalable BI solutions using DAX and Power Query, ensuring data accuracy, performance, governance, and effective visualization. Collaborate with stakeholders and cross-functional teams, troubleshoot reporting issues, and provide actionable insights. SQL, cloud data platforms, data integration, and AI exposure are advantageous.
Top Skills:
Agentic AiCloud-Based Data PlatformsData Integration ToolsDaxGenerative AiPower BIPower QuerySQL
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.
