Lead Business Analyst - Power BI and SQL

Shift Timing: 2 PM - 10'30 PM (Cabs Provided)

Experience of working with Banking / Financial Services setup is a must.

Key Responsibilities

• Must be able to do end-to-end Design, Develop and implement sophisticated Power BI solutions which include ETL, Data models, interactive dashboards/visualizations/Reports that effectively communicate key performance indicators (KPIs) and insights.
• Create Excel reports and provide automation where possible.
• Advanced in Data aggregation techniques to consolidate and summarize data from multiple sources.
• Able to work on all best practices related to Power BI service, including Data Modeling, dashboard/Report Design, writing complex DAX formulas, Power Query and access controls & have a general understanding of the AWS stack.
• Hands-on experience in SQL/PostgreSQL/AWS Datalake skills for data manipulation, ad-hoc Queries, and Star Schema design.
• Conduct in-depth data analysis to identify trends, patterns, and opportunities for process improvement or business growth.
• Optimize data models and queries for performance and efficiency, ensuring fast and accurate data retrieval.
• Able to collaborate with cross-functional teams.

Preferred candidate profile

Required Qualifications

• Bachelors degree in computer science, Data Analytics, or related field.
• Strong academic background with good analytical and problem-solving skills.
• 5-8 years of related experience in data management and reporting.
• Minimum 5 years of experience in Power BI/ Advance DAX functions and Dashboard designing.
• Minimum 5 years of strong experience of writing complex SQL queries.
• Experience developing Excel reports and automation of report distribution.
• Experience in documenting business and technical processes.
• Self-motivated, ability to work independently and in a team environment.
• High sense of urgency and ability to adapt to a changing environment.
• Strong oral and written communication skills.

Preferred Qualifications

• Experience in Python or any other programming language will be a plus.
• Knowledge of SAS and VBA will be a plus.