Lead Data Engineer

As a BI Data Engineer at Dentsu, your role within the Enterprise Data team will be pivotal in driving the organization towards becoming a fully digital entity. You will be responsible for building and implementing cutting-edge business analytics solutions using Azure data engineering tools and cloud-based databases. Your expertise in data engineering, ADF Integration, and database development will be crucial in delivering high-quality technical solutions that align with the company's business objectives. **Key Responsibilities:** - Build Enterprise data engineering and Integration solutions utilizing Azure Data Factory, Azure SQL Database, Azure Synapse, and Azure Fabric. - Develop enterprise ETL and integration routines using Azure Data Factory. - Evaluate emerging Data engineering technologies, standards, and capabilities. - Collaborate with business stakeholders, product managers, and data scientists to translate business objectives into technical solutions. - Work with DevOps, engineering, and operations teams to implement CI/CD pipelines for smooth deployment of data engineering solutions. **Required Skills and Experience:** **Technical Expertise:** - Proficiency in the Azure platform, including Azure Data Factory, Azure SQL Database, Azure Synapse, and Azure Fabric. - Exposure to Data bricks and lakehouse architecture & technologies. - Extensive knowledge of data modeling, ETL processes, and data warehouse design principles. - Experience in machine learning and AI services in Azure. **Professional Experience:** - 5+ years of experience in database development using SQL. - 5+ years integration and data engineering experience. - 5+ years experience using Azure SQL DB, ADF, and Azure Synapse. - 2+ years experience using Power BI. - Comprehensive understanding of data modeling. - Relevant certifications in data engineering, machine learning, AI. **Key Competencies:** - Expertise in data engineering and database development. - Familiarity with Microsoft Fabric technologies including One Lake, Lakehouse, and Data Factory. - Strong understanding of data governance, compliance, and security frameworks. - Proven ability to drive innovation in data strategy and cloud solutions. - Deep understanding of business intelligence workflows and the ability to align technical solutions. - Strong database design skills, including an understanding of both normalized form and dimensional form databases. - In-depth knowledge and experience of data warehousing strategies and techniques (e.g., Kimball Data warehousing). - Experience in Cloud-based data integration tools like Azure Data Factory. - Experience in Azure DevOps or JIRA is a plus. - Experience working with finance data is highly desirable. - Familiarity with agile development techniques and objectives. As a BI Data Engineer at Dentsu, you will be based at DGS India - Mumbai - Thane Ashar IT Park on a full-time permanent contract.,