Overview
Senior Analyst in the Specialized Ops Analytics & Automation team, delivering BI dashboards, reporting solutions and data automation that turn enterprise data into actionable insights.
What you'll do
- Design, develop, and maintain interactive dashboards and reports using Amazon QuickSight and Microsoft Power BI.
- Develop efficient and scalable SQL queries to extract, transform, and analyze data from Amazon Redshift and other enterprise data sources.
- Build automated reporting and analytics solutions using Python, SQL, and cloud-based technologies.
- Perform exploratory data analysis to identify trends, business drivers, risks, and opportunities.
- Partner with business stakeholders to gather reporting requirements and translate them into impactful BI solutions.
- Optimize existing dashboards and reporting processes for improved performance, scalability, and user experience.
- Develop reusable datasets, semantic models, and reporting standards to promote self-service analytics.
- Support data validation, reconciliation, and quality assurance activities to ensure reporting accuracy.
- Automate manual reporting processes to improve operational efficiency and reduce turnaround time.
- Mentor business users on BI best practices and promote data literacy across the organization.
- Collaborate with data engineering teams on data modeling, ETL enhancements, and reporting architecture.
What you'll need
- Bachelor's or Master's degree in Computer Science, Information Systems, Statistics, Mathematics, Engineering, Business Analytics, Finance, or a related quantitative discipline.
- 2–6 years of experience in Business Intelligence, Data Analytics, Reporting, or Data Engineering.
- Hands-on experience developing dashboards using Amazon QuickSight and/or Microsoft Power BI.
- Strong experience writing complex SQL queries and working with large datasets in Amazon Redshift or similar cloud data warehouse platforms.
- Experience using Python for data analysis, automation, reporting, or ETL processes.
- Experience working with relational and dimensional data models.
- Strong proficiency in SQL, including query optimization and performance tuning.
- Hands-on experience with Amazon Redshift.
- Strong expertise in Amazon QuickSight and Microsoft Power BI, including dashboard development, data modeling, calculated fields, DAX (Power BI), and visual best practices.
- Experience with Python libraries such as Pandas, NumPy, or similar for analytics and automation.
- Excellent analytical, problem-solving, and critical thinking skills.
- Strong understanding of data visualization principles and storytelling with data.
- Knowledge of ETL concepts and cloud-based analytics architecture.
- Ability to work independently while collaborating effectively across cross-functional teams.
- Strong verbal and written communication skills with the ability to present technical findings to business stakeholders.
Nice to have
- Experience integrating data from multiple enterprise systems and APIs.
- Experience working in Agile environments.
- Experience with Alteryx for workflow automation and data preparation.
- Knowledge of AWS analytics services (S3, Glue, Athena, Lambda, or EMR).
- Exposure to Git, CI/CD, or DevOps practices for BI development.
- Experience working in Financial Services, Wealth Management, or Banking domains.
Details
- Location: Bangalore, Karnataka, India.
Read the full description and apply on the company’s own careers page.