Data Analyst - Advance SQL & Power BI
- Deloitte
- 4 - 6 years
- Bengaluru
- 2 days ago
- Email to a friend
- Report this job
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
Job Classification
Industry: Management ConsultingFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Data AnalystEmployement Type: Full timeContact Details:
Company: DeloitteLocation(s): Bengaluru
Keyskills: POWER BI Advance SQL Data Analytics
Similar positions
Deloitte
We are one of the leading professional services organisations in India offering a range of consulting services across five major cities - Mumbai, Delhi, Chennai, Bangalore and Baroda.<br><br><br><br>Whether you are seeking to enhance & develop local business, expand into ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in