The consultant will architect and implement scalable data pipelines and ETL processes using the Microsoft ecosystem. They are also responsible for managing data governance, BI reporting, and automation workflows to support business objectives.
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.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”
— Sarah J.
·
Marketing Manager
★★★★★
Verified
