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.

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.