Consultant - Data Engineering

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Consultant – Data Engineering based in India.

We are seeking an experienced Data Engineering Consultant to design, implement, and optimize scalable data solutions within a technology-driven environment. In this role, you will leverage the Microsoft ecosystem to build reliable data pipelines, enhance reporting capabilities, and streamline enterprise workflows. You will play a key role in transforming complex technical requirements into practical solutions that support business intelligence and data-driven decision-making. Working across data engineering, DevOps, business intelligence, and IT service management, you will help strengthen data quality, governance, and operational efficiency. This opportunity is ideal for a seasoned technical professional who enjoys solving complex challenges, improving development processes, and collaborating with cross-functional teams. The position offers remote flexibility, with Chennai also listed as a location, and the chance to contribute to impactful enterprise data initiatives.

Accountabilities

• Data Engineering and ETL Development: Design, develop, and optimize scalable data pipelines, ETL processes, and complex queries using SQL Server and advanced T-SQL.

• DevOps and Release Management: Manage the software development lifecycle for data solutions using Azure DevOps, including Git-based version control, build pipelines, continuous integration, continuous deployment (CI/CD), and release management.

• Business Intelligence and Reporting: Build interactive Power BI dashboards and comprehensive reports that provide actionable insights and support informed business decisions.

• Workflow Automation: Develop and maintain automated workflows using Microsoft Power Automate and SharePoint to improve business processes and operational productivity.

• Data Governance and Master Data Management: Implement and maintain Microsoft Master Data Services (MDS) solutions to support data integrity, consistency, and effective governance.

• ServiceNow Reporting and ITSM: Configure, maintain, and enhance ServiceNow IT Service Management (ITSM) reporting capabilities to improve service visibility and performance monitoring.

• IT Service Management: Apply ITIL best practices to support service improvement, incident resolution, change management, and reliable IT operations.

• Cross-functional Collaboration: Work closely with technical and business stakeholders to integrate development best practices, improve data workflows, and align technical solutions with organizational objectives.

Requirements

• Professional Experience: At least 8 years of experience in data engineering, IT services, or a related technical field.

• Azure DevOps: Proven expertise with Azure DevOps, including Git repositories, build pipelines, version control, CI/CD, and deployment strategies.

• SQL Server and T-SQL: Advanced proficiency in SQL Server and T-SQL, including complex query development, performance optimization, and data manipulation.

• Power BI and Business Intelligence: Demonstrated ability to develop effective dashboards, reports, and analytics solutions using Power BI and enterprise data sources.

• Power Automate and SharePoint: Hands-on experience creating automated workflows and managing business processes and content using Microsoft Power Automate and SharePoint.

• Release Management: Strong understanding of release management principles and experience coordinating reliable, controlled software deployments.

• ITIL and ITSM: Familiarity with ITIL frameworks and practical experience applying IT service management principles to improve service delivery and operational processes.

• Master Data Management: Working knowledge of Microsoft MDS and data governance practices, with a focus on maintaining data quality and consistency.

• ServiceNow: Experience with ServiceNow ITSM, particularly configuring, managing, and analyzing reporting functionality.

• Analytical and Problem-solving Skills: Ability to investigate complex technical issues, evaluate solutions, and deliver efficient, maintainable data systems.

• Communication and Collaboration: Strong communication skills and the ability to work effectively with cross-functional teams, technical specialists, and business stakeholders.

Benefits

• Competitive Compensation: Annual salary range of ₹15–20 LPA.

• Remote Flexibility: Remote work arrangement, with Chennai, India, also listed as a location.

• Full-time Opportunity: A full-time role offering the opportunity to contribute to important enterprise data initiatives.

• Technical Impact: Work across data engineering, business intelligence, DevOps, workflow automation, and IT service management.

• Professional Development: Opportunity to apply and expand expertise across Microsoft data technologies, Azure DevOps, Power BI, and ServiceNow.

• Cross-functional Exposure: Collaborate with technical and business teams to deliver solutions that improve data maturity and operational efficiency.