Consultant – Data Engineering
Posted
Summary
Senior (8+ years) data engineering consultant who designs, builds, and optimizes Microsoft-stack data solutions: T-SQL/SQL Server ETL pipelines, Azure DevOps CI/CD and release management, Power BI dashboards, Power Automate/SharePoint automation, Microsoft MDS data governance, and ServiceNow ITSM reporting under ITIL practices.
Consultant – Data Engineering
Summary
We are seeking an experienced Consultant – Data Engineering professional with over eight years of industry tenure to lead critical data initiatives within our IT Services division. In this pivotal role, the successful candidate will architect, implement, and optimize robust data solutions leveraging the Microsoft ecosystem. The position demands a strategic thinker capable of bridging complex technical requirements with business objectives, ensuring seamless data flow, high-quality reporting, and efficient release management across the organization. This role is essential for driving data maturity and supporting advanced analytics through the effective utilization of Azure DevOps, Power BI, and ServiceNow platforms.
Responsibilities
- Design and develop scalable data pipelines and ETL processes using advanced T-SQL and SQL Server technologies.
- Manage the full software development lifecycle for data solutions, utilizing Azure DevOps for version control, CI/CD pipelines, and release management.
- Create interactive dashboards and comprehensive reports using Power BI to enable data-driven decision-making for stakeholders.
- Implement and maintain automation workflows using Power Automate and SharePoint to streamline business processes.
- Oversee data governance and master data management (MDM) initiatives using Microsoft MDS to ensure data integrity and consistency.
- Administer and enhance ServiceNow ITSM reporting modules to improve service delivery and operational visibility.
- Apply ITIL best practices to manage IT service improvements, incident resolution, and change management protocols.
- Collaborate with cross-functional teams to integrate Git-based version control strategies into development workflows.
Requirements
Requirements:
- Minimum of 8 years of professional experience in data engineering, IT services, or a related technical domain.
- Proven expertise in Azure DevOps, including experience with Git repositories, build pipelines, and deployment strategies.
- Advanced proficiency in SQL Server and T-SQL for complex query writing, optimization, and data manipulation.
- Strong capability in developing business intelligence solutions using Power BI and integrating them with enterprise data sources.
- Hands-on experience with Microsoft Power Automate and SharePoint for workflow automation and content management.
- Solid understanding of Release Management principles and tools to ensure smooth software deployments.
- Familiarity with ITIL frameworks and experience in applying these standards to IT service management.
- Competence in utilizing Microsoft MDS for master data management and governance.
- Experience with ServiceNow ITSM, specifically in configuring and analyzing reporting features.