Job
Description
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: We are looking for a highly skilled Business Analyst with deep expertise in Advanced SQL and Power BI to join our analytics team. The ideal candidate will be responsible for translating business requirements into data models, dashboards, and actionable insights, while working closely with cross-functional teams to drive data-informed decisions. 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
