WTW Hiring for DPS Data Engineer at Mumbai, India Full Time

You will implement new areas of data technologies, (ingestion, processing, distribution, visualization) and research delivery methods that can remove technical barriers to data access and distribution. You will

work with complex data models, relational and non-relational database structures and collaborate with a diverse team in the design, development, testing, tuning, and implementation of data solutions. You will also complete documentations and procedures for maintenance. Responsibilities include but are not limited to:

• Build functionality to advance the Data Platforms and Services Technology team data strategy with a focus on data integration and data consumption

• Spin-up Azure infrastructure to cater data analytics solutions – security, compliance of Azure services, data ingestion, validation, storage, and movement utilizing various Azure-based tools

• Develop SQL stored procedures, views, Azure data pipelines to enable migration to Azure

• Build Azure Synapse Analytics Python routines

• Support existing SSIS ETL solutions till Azure migration is completed

• Develop Azure Logic Apps, optionally APIs to support data solutions

• Working with appropriate stakeholders to understand system and functional requirements

• Executing software development in Agile method of delivery

• Collaborating on delivering technical excellence across the organization

The Requirements

• Bachelor’s degree

• 5 years of experience in software development in the Microsoft platform and tools:

• SQL Server 2019 or later, RDBMS, Transact-SQL

• Good to have experience on Master Data Management, especially Microsoft SQL Server MDS

• Must have experience with Azure data and analytics tools – Azure Data Factory, Azure Synapse or Azure Data Bricks, ADF Data Flows and Data Pipelines

• Experience with Python, PowerShell

• Proficiency in Azure DevOps or similar, strong understanding of CI/CD (project repositories, pipelines, work dashboards, unit testing), Git for software version control

• Competent in working with large data, securing sensitive data, co-mingling the data for business/system consumption

• Knowledgeable of cloud and hybrid-cloud implementations including IaaS, PaaS and SaaS

• Optionally C# programming language building Azure Functions, APIs or Applications

• Experience of working in an Agile-Scrum environment – close partnership with QA and/or project stakeholders (Product Owners, Project Managers, Architects, business), preferably with experience working collaboratively with colleagues from different geographic areas.

• Utilize effective work planning techniques to break down complex requirements into tasks, manage the scope of requirements, and ensure deadlines are kept for own work and fellow data engineers

• Strong problem solving and data-driven analysis skills

• Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, continuous deployment, testing, and operations

• Ability to coordinate day-to-day development and bug fixing activities, multi-task and be mindful of deadlines. Self-motivated and ability to remain focused on assigned projects.

Preferred Qualifications

• Experience with Azure Logic Apps

• Experience with Spark SQL and NoSQL

• Experience with Redgate SQL Change Automation (SCA)

• Azure Cloud Platform Certifications are a plus