Consultant – Data Engineering

Job Description: Consultant – Data Engineering

Position Details

- Job Title: Consultant – Data Engineering
- Experience: 8+ Years
- Contract Duration: 6 Months (Extendable)
- Work Location: Remote or Chennai
- Employment Type: Contract
- Work Timings: Central European Time (CET)
- Availability: Immediate joiners preferred; candidates available by 30th October.

Job Overview

We are looking for an experienced Consultant – Data Engineering to lead initiatives across data engineering, Master Data Management (MDM), ITSM analytics, automation, and Application Management Services (AMS).

The ideal candidate should have strong hands-on expertise in SQL Server, Advanced T-SQL, Microsoft Master Data Services (MDS), ServiceNow ITSM analytics, and enterprise data platforms. The role also involves operational excellence, automation strategy, performance optimization, executive reporting, and stakeholder management.

The candidate should be comfortable working with both technical teams and senior leadership, translating operational challenges into data-driven insights and scalable solutions.

Key Responsibilities

1. Master Data Management (MDS)

- Own and manage the enterprise Microsoft Master Data Services (MDS) platform.
- Design, develop, and maintain MDS entities, attributes, hierarchies, and change sets.
- Manage data quality, governance, stewardship processes, and access controls.
- Handle platform administration, database operations, and enhancements.
- Troubleshoot critical MDS incidents and platform issues.
- Collaborate with business and technical teams to improve master data processes.
- Write and optimize complex SQL queries.

2. ServiceNow ITSM Analytics and Reporting

- Develop and maintain ServiceNow Incident and Request Management reports and dashboards.
- Analyze incident trends, created-versus-closed tickets, transfer-in/transfer-out metrics, SLA performance, and business-day ageing.
- Monitor team productivity, workload distribution, and service KPIs.
- Perform root cause and trend analysis to identify recurring operational issues.
- Differentiate business-driven demand from IT-driven demand.
- Recommend data-driven improvements to service delivery and operational efficiency.

3. AMS Operations and Service Management

- Lead AMS operational activities and governance processes.
- Conduct operational reviews and service performance meetings.
- Review ticket quality, resolution effectiveness, and SLA adherence.
- Coordinate with multiple support teams to improve resolution times.
- Track and report team performance, workload distribution, and service metrics.

4. Data Engineering and Platform Optimization

- Optimize data pipelines, integrations, and enterprise data workflows.
- Identify and resolve performance bottlenecks across data platforms.
- Support data architecture and platform optimization initiatives.
- Work with SQL Server, Azure Data Factory (ADF), Databricks, and Informatica PowerCenter.
- Recommend scalable solutions to improve data processing and operational efficiency.

5. Automation Strategy and Implementation

- Identify and prioritize automation opportunities across AMS operations.
- Develop business cases using operational metrics, effort analysis, and ROI calculations.
- Lead automation initiatives from planning through implementation.
- Measure automation outcomes, including ticket reduction, hours saved, productivity improvements, and cost avoidance.
- Present automation roadmaps and progress updates to stakeholders and leadership.

6. DevOps, CI/CD, and Release Management

- Improve CI/CD, source control, and version management practices.
- Support Azure DevOps-based delivery and release processes.
- Promote deployment automation and release governance best practices.
- Collaborate with development and support teams to improve deployment reliability.

7. Executive Reporting and Stakeholder Management

- Prepare executive presentations, dashboards, KPI reports, and operational reviews.
- Present service performance, automation outcomes, and strategic initiatives to leadership.
- Translate technical findings into business-focused recommendations.
- Develop process documentation, governance materials, and stakeholder-specific reports.

Required Technical Skills

- SQL Server
- Advanced T-SQL
- Microsoft Master Data Services (MDS)
- ServiceNow ITSM and reporting
- Azure Data Factory (ADF)
- Databricks
- Informatica PowerCenter
- Azure DevOps
- Git
- Power BI
- Power Automate
- SharePoint

Preferred Skills

- Data Governance Frameworks
- CI/CD Pipelines
- Release Management
- Operational Analytics
- IT Service Management (ITIL)

Required Qualifications

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Master's degree is an added advantage.
- 8+ years of experience in IT Operations, Data Engineering, Service Management, Analytics, or Automation.
- Proven experience in ServiceNow reporting and ITSM analytics.
- Strong experience with Master Data Management platforms, preferably Microsoft MDS.
- Experience leading cross-functional initiatives and operational improvement programs.
- Demonstrated success in automation implementation and productivity improvement.

Leadership Competencies

- Strategic Thinking
- Operational Excellence
- Analytical Problem-Solving
- Stakeholder Management
- Executive Communication
- Continuous Improvement
- Team Leadership and Mentoring
- Data-Driven Decision-Making
- Change Leadership