Overview
Design, develop and maintain enterprise-grade Power BI reports and dashboards that translate complex data from the GCP data platform into clear, actionable business insights for the O9 solution landscape, and contribute to the evaluation and adoption of Databricks AI BI Dashboards ahead of the mid-2027 platform migration.
What you'll do
- Design, build and publish production-quality Power BI reports and dashboards aligned to business KPIs and stakeholder requirements.
- Modify, enhance and optimise existing reports, improving visuals, DAX calculations, data models, query performance and user experience.
- Implement Power BI best practices: star-schema modelling, measure tables, row-level security (RLS), bookmarks, drill-throughs and consistent design standards.
- Manage report lifecycle, including version control, development/test/production promotion and scheduled refresh configuration.
- Troubleshoot and resolve report-level incidents (broken refreshes, incorrect aggregations, visual errors) as part of L2/L3 support.
- Understand the GCP backend (BigQuery datasets, tables, views and stored procedures) that feeds Power BI reports.
- Write and optimise SQL queries in BigQuery to validate data, investigate discrepancies and support ad-hoc analysis requests.
- Collaborate with the GCP Data Engineering pod on pipeline logic, data lineage, transformation rules and refresh schedules.
- Identify and flag data quality issues at the reporting layer and work with the DQ function (Ataccama) and data engineers to trace root causes and implement fixes.
- Document data mappings between GCP source objects and Power BI datasets to maintain clear lineage from source to report.
- Participate in the evaluation and POC development of Databricks AI BI Dashboards (formerly Lakeview Dashboards), connected to Databricks SQL warehouses.
- Assess migration pathways for existing Power BI content to Databricks AI BI, identifying candidates for migration versus those that remain on Power BI.
- Enforce data governance standards in the reporting layer, including consistent naming conventions, certified datasets, usage tracking and access controls.
- Support FMT governance activities for reporting objects, ensuring SLAs and defined rules are met for governed data objects.
- Implement and maintain data validation checks within Power BI (e.g. comparison measures, anomaly flags) to catch discrepancies before they reach business users.
- Partner with business stakeholders and product owners to gather requirements, translate them into report specifications and iterate through review cycles.
- Conduct report walkthroughs and training sessions to improve user adoption and self-service capability.
- Identify opportunities to consolidate or retire redundant reports, reducing maintenance overhead.
- Document report logic, common troubleshooting steps and design patterns for reuse in the team knowledge base.
What you'll need
- Using data analysis to make recommendations to analytic leaders.
- Understanding of best-in-class analytics practices.
- Knowledge of Indicators (KPIs) and scorecards.
- Bachelor's or Master's degree (Bancheros Degree or PG).
- 5–7 years of hands-on Power BI development experience, including report design, DAX, Power Query (M) and data modelling.
- Strong SQL skills: ability to write, read and optimise complex queries in BigQuery or equivalent cloud data warehouses.
- Solid understanding of data warehousing concepts: star/snowflake schemas, fact/dimension tables, slowly changing dimensions and ETL/ELT patterns.
- GCP familiarity: working knowledge of BigQuery (tables, views, scheduled queries), Cloud Storage and basic IAM/access concepts.
- Power BI Service administration experience with workspaces, dataset management, scheduled refresh, row-level security (RLS) and deployment pipelines.
- Data visualisation best practices: ability to design intuitive, accessible and performant dashboards that tell a clear story.
- Troubleshooting and support mindset: comfortable performing root-cause analysis on data discrepancies, refresh failures and performance issues.
- Strong communication skills to translate technical data concepts for business audiences and collaborate across global teams.
Nice to have
- Knowledge of BI tools such as Tableau, Excel, Alteryx, R, Python, etc.
- Databricks experience: exposure to Databricks SQL, AI BI Dashboards (Lakeview), Genie or Unity Catalog.
- Python or PySpark basics for data exploration or automation tasks.
- Experience with orchestration tools such as Talend, Aecorsoft or Apache Airflow.
- Familiarity with data quality tools such as Ataccama, Great Expectations or similar.
- Power BI embedded analytics or paginated reports experience.
- Exposure to Terraform or CI/CD for report deployment automation.
- Experience working in a global IT function with regional or global responsibilities.
Details
- Location: Mumbai, India.
- Job type: Regular.
- No relocation support available.
Read the full description and apply on the company’s own careers page.