Sia Partners Logo

Sia Partners

Senior Data Analyst

Posted 9 Hours Ago
Be an Early Applicant
In-Office
Mumbai, Maharashtra
Senior level
In-Office
Mumbai, Maharashtra
Senior level
Lead the development and maintenance of business intelligence dashboards using Power BI, manage ETL processes, and mentor junior analysts.
The summary above was generated by AI
Company Description

Sia is a next-generation, global management consulting group. Founded in 1999, we were born digital. Today our strategy and management capabilities are augmented by data science, enhanced by creativity and driven by responsibility. We’re optimists for change and we help clients initiate, navigate and benefit from transformation. We believe optimism is a force multiplier, helping clients to mitigate downside and maximize opportunity. 

With expertise across a broad range of sectors and services, our 3,000 consultants serve clients worldwide from 48 locations in 19 countries. Our expertise delivers results. Our optimism transforms outcomes.

Job Description

We are hiring a Power BI Developer to support our global internal teams (Finance, HR, Strategy, Corporate Functions) by maintaining, improving, and delivering high-impact business intelligence dashboards, datasets, and analytics solutions. This role is critical for strengthening our internal reporting systems and driving data-backed decision-making across the organization.

Key Responsibilities

  • Lead the design, implementation, and upkeep of ETL / data pipelines (from source files through staging layers into the DWH), ensuring data correctness and efficiency.
  •  Architect and evolve semantic models / reusable datasets: define dimensions, hierarchies, and KPI definitions that align with business needs.
  • Build, review, and optimize complex SQL-based transformations and views that feed into dashboards and reports.
  • Develop, optimize, and maintain all aspects of Power BI dashboards: DAX measures, visuals and UXUI design, Power Query (M), security through RLS, OLS, and access rights, report publication and refresh.
  • Lead and manage complete BI projects with Corporate teams from Business requirement to delivery thus including : requirements gathering, scoping, estimating work and timeline, designing specs, developing, validating with business stakeholders, deploying, and monitoring in production.
  • Identify performance bottlenecks (in SQL queries or the data model) and optimize query speed, resource usage, and refresh times to improve user experience.
  • Maintain and initiate documentation of data schema, data lineage, dashboards, and datasets; QA and perform tests / validation to ensure data integrity.
  • Mentor junior analysts; raise and enforce standards and best practices in SQL, data modelling, and BI development.

Qualifications

  • Bachelor's or Master’s in Computer Science, Data Analytics, Information Systems, Statistics, or a related field.
  • 5-8+ years in analytics / BI roles with strong exposure to the Microsoft Power BI Suite.
  • Deep hands-on experience in SQL: complex joins, aggregations, window functions, subqueries, optimizations.
  • Solid experience with Power BI: semantic modelling, DAX, Power Query (M), report/dashboard design, RLS, publishing.
  • Understanding of data warehousing / ETL architecture (ODS / staging / fact & dimension layers).
  • Demonstrated ability to work on end-to-end projects: gathering requirements, specifying, implementing, testing, and monitoring dashboards.
  • Strong communication skills; ability to engage with both technical and non-technical international audiences.
  • Proven problem solving and performance tuning skills: recognizing bottlenecks, refactoring models or queries as needed.
  • Certifications :
    • Mandatory: PL-300 (Microsoft Certified: Data Analyst Associate)
    • Preferred: PL-200: Power Platform Functional Consultant or PL-600: Power Platform Solution     

Nice to Have

  • Experience in cloud analytics environments (Azure preferred).
  • Familiarity with tools enhancing BI model maintenance (Tabular Editor, DAX Studio, ALM / version control for BI assets).

Additional Information

Sia is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs.

Sia is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs. 

Top Skills

Azure
Data Warehousing
Dax
ETL
Power BI
Power Query
SQL

Similar Jobs

8 Days Ago
Easy Apply
Remote or Hybrid
India
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
The Senior Data Analyst II will drive data-informed decisions within the Sales organization by building analytics, conducting analyses, and developing data products.
Top Skills: PythonRSQLTableau
19 Days Ago
Remote or Hybrid
India
Senior level
Senior level
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The role involves leading discovery sessions, performing gap analysis, eliciting and documenting requirements, creating user stories, and providing operational support for COTS/SaaS solutions, while collaborating with cross-functional teams.
Top Skills: AgileCotsDev OpsSaaSService Oriented Architecture
8 Hours Ago
In-Office
Mumbai, Maharashtra, IND
Mid level
Mid level
Fintech • Consulting
The Senior Data Analyst will manage and optimize ETL processes, design data warehouses, collaborate with teams, and ensure data quality at Equifax.
Top Skills: Pyspark,Hive,Hadoop,Hdfs,Impala,Spark,Spark Sql,Kafka

What you need to know about the Mumbai Tech Scene

From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account