Data Analyst

The interview process at Sia Partners typically starts with a timed online aptitude test followed by a technical interview that dives deep into Power BI, DAX, SQL queries, and Python data handling. The final HR round assesses cultural fit, communication skills, and motivation. Candidates report a moderate difficulty level, with emphasis on practical problem‑solving and clear articulation of analytical approaches.

Sia Partners promotes a performance‑driven yet supportive culture where collaboration and knowledge sharing are encouraged. Employees benefit from regular skill‑upgradation programs, mentorship, and a balanced work‑life approach that respects personal time while delivering client value.

Graduates with a B.Tech/B.E. or B.Sc. in Computer Science, Information Technology, Statistics, Mathematics, Economics or related fields; minimum 60% aggregate (or CGPA 6.0/10); batch years 2025‑2027; maximum one active backlog allowed; strong analytical mindset and proficiency in English communication.

Round 1: Online aptitude test (quantitative, logical reasoning, verbal) → Round 2: Technical interview (Power BI, SQL, Python, data modeling) → Round 3: HR interview (culture fit, career aspirations)

Sia Partners is a leading global management consulting firm that blends deep industry expertise with innovative analytics to help clients navigate complex business challenges. With a strong presence in India, particularly in Mumbai, the firm has built a reputation for delivering data‑driven strategies across sectors such as finance, technology, and consumer goods. The Indian office offers a collaborative environment where fresh talent works alongside seasoned consultants, gaining exposure to high‑impact projects for multinational corporations and fast‑growing startups alike. Sia Partners emphasizes continuous learning, encouraging employees to upskill through internal academies, certifications, and cross‑functional rotations, making it an attractive destination for ambitious graduates. The Data Analyst role is positioned within the Corporate Finance analytics team and is responsible for turning raw data into actionable insights that drive strategic decisions. The incumbent will design, develop, and maintain Power BI dashboards that serve finance, operations, and senior leadership. By leveraging Power BI add‑ons such as Tabular Editor, DAX Studio, and ALM Toolkit, the analyst will create reusable data models that ensure consistency and scalability across the organization. The role also involves data ingestion, transformation, and enrichment using SQL and Python, as well as supporting ad‑hoc reporting requests from various business units. Interaction with the broader Power Platform ecosystem, including PowerApps and Power Automate, will be essential for automating workflows and enhancing data accessibility. Key responsibilities include: designing and enhancing internal Power BI dashboards; managing Power BI Service administration (access control, workspace setup, gateway configuration); developing reusable data models with Tabular Editor, DAX Studio, and ALM Toolkit; performing data ingestion, transformation, and enrichment using SQL/Python; supporting cross‑functional stakeholders with on‑demand reporting and data exploration; maintaining comprehensive documentation for dashboards, models, and datasets; conducting demos, training sessions, and technical watch initiatives; responding to ad‑hoc requests across Power Platform tools such as PowerApps and Power Automate; and continuously monitoring data quality and performance metrics. The tech stack revolves around Power BI, DAX, Tabular Editor, ALM Toolkit, SQL Server, Python (pandas, numpy), PowerApps, Power Automate, and Azure Data Factory for larger ETL pipelines. Career growth follows a clear trajectory: Junior Data Analyst → Senior Data Analyst → Analytics Lead → Manager – Analytics, with opportunities to transition into consulting or product analytics tracks. Joining Sia Partners offers exposure to high‑visibility projects, mentorship from industry veterans, a culture that rewards curiosity, and a competitive compensation package that aligns with market standards for data professionals in India.