Data Analyst

You will be working as a Data Analyst at Hansa Cequity, a leading data-driven, connected CX services provider in India. Your primary focus will be on Mutual Funds portfolio analytics, utilizing your expertise in SQL, Power BI, and Databricks. Key Responsibilities - Operational: - Collaborate with investment, product, and business teams to gather analytics and reporting requirements for mutual fund portfolios. - Extract, transform, and analyze large datasets using SQL, Power BI, and Databricks. - Develop and maintain dashboards and reports covering portfolio performance, AUM trends, returns, risk metrics, and investor behavior. - Conduct ad-hoc analysis to support fund performance reviews, benchmarking, and portfolio composition analysis. - Ensure data accuracy, consistency, and compliance with internal data governance standards. - Build and optimize SQL-based data models to facilitate portfolio and financial analytics. - Exposure to large-scale financial or market data platforms is beneficial. Key Responsibilities - Strategic: - Support portfolio analytics initiatives such as performance attribution, risk-return analysis, and trend identification. - Translate business and investment requirements into scalable analytical and reporting solutions. - Collaborate with stakeholders to establish data definitions, KPIs, and insights delivery. - Contribute to the automation and standardization of recurring portfolio and MIS reports. Qualifications: - B.E/B.Tech/M.Tech/BSc/MSc in Computer Science, IT, Data Analytics, Finance, BDA, AIML, or related fields. - Minimum of 2 years of hands-on experience in data analytics roles, preferably in financial services, asset management, or investment analytics. You will be working as a Data Analyst at Hansa Cequity, a leading data-driven, connected CX services provider in India. Your primary focus will be on Mutual Funds portfolio analytics, utilizing your expertise in SQL, Power BI, and Databricks. Key Responsibilities - Operational: - Collaborate with investment, product, and business teams to gather analytics and reporting requirements for mutual fund portfolios. - Extract, transform, and analyze large datasets using SQL, Power BI, and Databricks. - Develop and maintain dashboards and reports covering portfolio performance, AUM trends, returns, risk metrics, and investor behavior. - Conduct ad-hoc analysis to support fund performance reviews, benchmarking, and portfolio composition analysis. - Ensure data accuracy, consistency, and compliance with internal data governance standards. - Build and optimize SQL-based data models to facilitate portfolio and financial analytics. - Exposure to large-scale financial or market data platforms is beneficial. Key Responsibilities - Strategic: - Support portfolio analytics initiatives such as performance attribution, risk-return analysis, and trend identification. - Translate business and investment requirements into scalable analytical and reporting solutions. - Collaborate with stakeholders to establish data definitions, KPIs, and insights delivery. - Contribute to the automation and standardization of recurring portfolio and MIS reports. Qualifications: - B.E/B.Tech/M.Tech/BSc/MSc in Computer Science, IT, Data Analytics, Finance, BDA, AIML, or related fields. - Minimum of 2 years of hands-on experience in data analytics roles, preferably in financial services, asset management, or investment analytics.