Manager | Data Engineer | Bengaluru | Emerging ERP Solutions
Deloitte Advisory1 month ago
Bengaluru, IndiaStaff+
Responsibilities
- Develop and maintain KPI dashboards, scorecards, reports, and visual analytics solutions using Power BI.
- Create semantic data models, relationships, DAX measures, Power Query transformations, and optimized reporting structures.
- Write complex SQL queries, optimize database performance, and ensure data integrity for reporting and analytics.
- Manage Power BI Service workspaces, dataset refreshes, gateways, row-level security, and deployment guidelines.
- Integrate Power BI with Azure SQL Database, Azure Synapse, Azure Databricks, and Azure Data Lake sources.
- Implement data transformation, cleansing, mapping, automation, and ETL processes using Power Query and Power BI Dataflows.
- Collaborate with business stakeholders, subject matter experts, analysts, and cross-functional teams to deliver analytics solutions.
- Document Power BI best practices, governance standards, and deployment procedures.
- Present insights and analytics solutions to business and leadership teams.
Requirements
- 6+ years of experience with Power BI stack technologies, including data engineering aspects.
- Strong experience with Microsoft Power BI Desktop and Power BI Service.
- Proficiency in SQL Database, including complex queries, performance optimization, and data integrity.
- Expertise in data modeling, DAX, Power Query using M language, semantic models, and dashboard development.
- Experience with Power BI Service administration, including workspaces, refreshes, gateways, and row-level security.
- Strong understanding of data warehouses, data lakes, structured and unstructured data, and ETL design principles.
- Experience integrating Power BI with Azure data sources.
- Strong data management and Microsoft Excel skills, including Pivot Tables and VLOOKUPs.
- Knowledge of Azure data engineering concepts and services such as Azure SQL Database, Azure Synapse, Azure Data Lake Storage, Azure Databricks, and Azure Analysis Services or Tabular Models is preferred.
- Knowledge of Power Apps, Microsoft SharePoint, Power Automate, Dynamics 365, and DevOps practices is preferred.
- Strong communication, presentation, teamwork, and collaboration skills.
- Certification in DP-200, DP-201, DP-203, DA-100, PL-300, or AZ-900 is preferred.
Tech Stack
DatabricksSQL
Categories
Data Engineering
About Deloitte Advisory
Deloitte Advisory provides consulting and managed services that help organizations manage risk, strengthen controls, investigate fraud, meet regulatory requirements, and execute transactions using analytics and industry expertise. Offerings span cybersecurity, M&A due diligence, finance and regulatory transformation, internal audit, and tech-enabled platforms. It is part of Deloitte’s global network (founded in 1845 and privately held), with U.S. member-firm teams serving corporations and government agencies across sectors.