Deloitte—Consultant | Data Engineer | Pune | Emerging ERP Solutions

Job description

Description: Consultant | Data Engineer | Pune | Emerging ERP Solutions • Job requisition ID : 112154 • Location: Pune • Entity: Deloitte Touche Tohmatsu India LLP The team Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P Your work profile · Strong experience with the Microsoft Power BI stack. · Proficiency in SQL Database — ability to write complex queries, optimize performance, and ensure data integrity for reporting and analytics. · Expertise in data modeling, DAX, Power Query (M language), and report/dashboard development using Power BI. · Experience working with Power BI Service — including workspace management, dataset refreshes, gateways, and row-level security (RLS). · Strong understanding of data warehouse and data lake concepts to design optimized reporting and analytics solutions. · Experience creating semantic data models, establishing relationships, and implementing best practices for performance optimization. · Experience in integrating Power BI with Azure data sources, such as Azure SQL Database, Synapse, Databricks, and Data Lake. · Ability to collaborate with business stakeholders, SMEs, and Data/Business Analysts to understand requirements and deliver insightful dashboards. · Implement data transformation, cleansing, mapping, and automation using Power Query or Power BI Dataflows. · Develop and maintain KPI dashboards, scorecards, and visual analytics solutions aligned with business needs. · Knowledge of Agile and DevOps methodologies for managing the Power BI project lifecycle. · Strong understanding of ETL design principles, working with both structured and unstructured data, ensuring accuracy and reliability. · Ability to document best practices, governance standards, and deployment guidelines for Power BI assets across environments. · Collaborate with cross-functional teams to implement end-to-end analytics solutions that align with business goals. · Strong data management and Excel skills (Pivot Tables, VLOOKUPs, etc.). · Excellent communication and presentation skills for sharing insights with business and leadership teams. Key skills required · 6+ years of experience with Power BI stack technologies, including data engineering aspects. · Development experience using the technologies below: o Power BI Desktop & Power BI Service o Power BI Dataflows o Power Query (M language) o DAX (Data Analysis Expressions) o SQL Database · Having knowledge of (would be a plus): o Azure Data Engineering concepts, such as: o Azure SQL Database / Azure Synapse o Azure Data Lake Storage o Azure Databricks o Azure Analysis Services / Tabular Models o Power Apps o Microsoft SharePoint o Power Automate o Dynamics 365 o Understanding of DevOps practices o Demonstrated teamwork, collaboration, and passion for new technologies o Certification in DP-200, DP-201, DP-203, DA-100, PL-300, AZ-900