Senior Data Analyst (Hyderabad)
Key Skills for This Role
Full Job Posting
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.
- Certifications:
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).
- 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 Partners is a next-generation global management consulting firm, founded in 1999 and headquartered in Paris, France. The firm is recognised for its innovative approach, combining strategy and management consulting with data science and creativity. Sia Partners serves a diverse range of sectors, including energy, banking, healthcare, and technology, providing services to over 1,000 clients worldwide, including many Fortune 500 companies. With a strong emphasis on delivering tangible results and superior value, Sia Partners is committed to helping clients navigate the digital revolution and achieve transformation. The firm operates with a global presence, employing over 3,500 consultants across 48 locations in 20 countries Our Mumbai office was launched in 2024, marking an exciting new chapter for us. We’re building the team with people who are eager to shape something from the ground up — combining the agility and entrepreneurial energy of a startup with the backing and reach of a global brand.
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
- Mandatory: PL-300 (Microsoft Certified: Data Analyst Associate)
- Preferred: PL-200: Power Platform Functional Consultant or PL-600: Power Platform Solution
- Experience in cloud analytics environments (Azure preferred).
- Familiarity with tools enhancing BI model maintenance (Tabular Editor, DAX Studio, ALM / version control for BI assets).
About Sia
Provide management and AI consulting for business transformation.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Sia
[UAE] AI Solution Architect
Abu Dhabi, UAE
Our AI Solution Architect will be the technical authority on Sia's Data & AI engagements in the Middle East, designing the AI and agentic architectures and the application modernization paths that take client ambitions f
Senior Full Stack Engineer (React + Python)
Mumbai, IND
We are looking for a skilled Senior Full Stack Engineer (React + Python) for our Mumbai location. This role involves developing scalable, high-performing web applications for our AI-powered SaaS solutions. You will work
[UAE] Data Scientist
Abu Dhabi, UAE
Our Data Scientist will build and productionize data science and machine learning solutions for Sia's clients across the Middle East, from data acquisition and exploration through modelling, evaluation and the presentati
Consultant - Financial Services
Charlotte, USA
We are seeking a highly motivated Consultant to join our Financial Services Consulting practice as a Forward Deployed Business Analyst (FDBA). Whether your expertise lies in wealth and asset management, capital markets,
Workday US Payroll and Benefits Analyst
Mumbai, IND
Role Summary The Workday US Payroll and Benefits Analyst supports the configuration, maintenance, and troubleshooting of the Workday Payroll and Benefits modules for Sia’s US employee population. The role partners closel
[UAE] Forward Deployed Engineer
Abu Dhabi, UAE
Our Forward Deployed Engineer will be embedded with Sia's clients across the Middle East, turning generative AI prototypes into production-grade solutions that create measurable value in daily operations. As part of the
Senior Backend Engineer (Python)
Mumbai, IND
We are looking for a skilled Senior Software Engineer to contribute to the development of AI and machine learning (ML) integrations and back-end solutions using Python. You will play a key role in developing our AI-power
[UAE] Data Scientist
Abu Dhabi, UAE
Sia is seeking a Data Scientist to build and productionize machine learning solutions for clients across the Middle East. The role covers data preparation, modelling, deployment, visualization, and client presentations;
[UAE] AI Solution Architect
Abu Dhabi, UAE
Senior Full Stack Engineer (React + Python)
Mumbai, IND
[UAE] Data Scientist
Abu Dhabi, UAE
Consultant - Financial Services
Charlotte, USA
Workday US Payroll and Benefits Analyst
Mumbai, IND
[UAE] Forward Deployed Engineer
Abu Dhabi, UAE
Senior Backend Engineer (Python)
Mumbai, IND
[UAE] Data Scientist
Abu Dhabi, UAE