Data Analyst - Advance SQL & Power BI

• Job Title: Business Analyst Advanced SQL & Power BI
• Location: Bangalore/Mumbai
• Job Type: Full-time
• Experience: 57 years
• Industry: BFSI / FinTech / Analytics / Consulting

Job Summary:

Key Responsibilities:

• Collaborate with stakeholders to gather and document business and data requirements.
• Design and develop interactive dashboards and reports using Power BI.
• Write and optimize complex SQL queries for data extraction, transformation, and analysis.
• Perform data profiling, cleansing, and validation to ensure data quality.
• Conduct root cause analysis, identify trends, and provide strategic recommendations.
• Create data dictionaries, ER diagrams, and maintain documentation for BI solutions.
• Support data governance, compliance, and audit requirements.
• Work in Agile/Scrum environments and participate in sprint planning and reviews.

Technical Skills – Detailed

SQL (Advanced)

• Writing complex queries using: Joins (inner, outer, self, cross), Common Table Expressions (CTEs), Window functions (RANK, ROW_NUMBER, LEAD/LAG), Subqueries and correlated subqueries o Stored procedures, triggers, and views
• Query optimization and performance tuning
• Experience with RDBMS like SQL Server, PostgreSQL, MySQL, or Oracle

Power BI

• Advanced DAX for calculated columns, measures, and KPIs
• Power Query (M language) for data transformation
• Designing data models with star/snowflake schemas
• Implementing Row-Level Security (RLS)
• Creating custom visuals, bookmarks, and drill-through reports
• Publishing and managing reports on Power BI Service

Data Integration & ETL

• Experience with ETL tools like SSIS, Azure Data Factory, or Talend
• Connecting Power BI to various data sources (SQL, Excel, APIs, SharePoint, etc.)
• Understanding of data warehousing and data lake concepts

Business Analysis Tools & Techniques

• Process modelling (BPMN, flowcharts)
• Use case and user story development
• Wireframing tools (e.g., Balsamiq, Figma)
• Agile tools (JIRA, Confluence)

Preferred Qualifications:

• Experience in BFSI, FinTech, or regulated industries
• Familiarity with cloud platforms (Azure, AWS, GCP)
• Knowledge of Python or R for data analysis is a plus
• Microsoft certifications (e.g., PL-300: Power BI Data Analyst)

Soft Skills:

• Strong analytical and problem-solving mindset
• Excellent communication and stakeholder engagement
• Ability to work independently and in cross-functional teams
• Attention to detail and a passion for data storytelling