Data Engineering & Analytics Specialist (Azure)

iVedha Inc.; Guelph; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology consulting company in Ontario is seeking an experienced professional in Azure Data Engineering. The role demands hands-on experience with data architecture and analytics, focusing on delivering AI-driven insights and optimizing data solutions. Candidates should possess strong project management skills and a solid background in data governance, with extensive experience using tools like Power BI.

Qualifications

• Experience with data integration architectures and ETL/ELT pipelines.
• Extensive experience with Power BI and data visualization tools.
• Ability to lead projects under limited supervision.

Responsibilities

• Develop the Client’s information management foundation for Enterprise Data and Analytics.
• Design and build data architectures that leverage data as an organizational asset.
• Act as a subject matter expert in data management technologies.

Skills

Azure Data Engineering

Data Architecture

ETL/ELT pipelines

Data Warehousing

Power BI

Data Governance

AI-driven analytics

Project management

Education

Post-secondary education in computer science or related field

Tools

Informatica

SQL Server

Oracle

ESRI GeoDatabase

NoSQL Databases

Job description

Please Note: This role is focused on Azure Data Engineering, Data Architecture, and Advanced Analytics. Candidates must have hands‑on experience with Azure Data Factory/Data Lake, Data Warehousing, ETL/ELT pipelines, and Power BI. Experience in Data Governance/MDM and AI‑driven analytics (GenAI) is required.

Role Summary

This role is primarily responsible for developing the Client’s information management foundation to implement the Enterprise Data and Analytics program, operationalizing analytics, and delivering data‑as‑a‑service following industry standard practices and tools including AI.

Duties

• Work closely with clients and other resources to effectively communicate, plan, design, and implement solutions for delivering real‑time and AI‑driven insights
• Design and build data warehouses and analytics warehouses, for structured and unstructured data
• Design and build data architectures to leverage data as an organizational asset
• Design comprehensive data solutions that enable clients to appropriately capture, make sense of and action data
• Ensure delivered solutions fit within overall project plan and schedule
• Provide feedback to departments and create structured documentation, including specifications and weekly status reports
• Advise departments on configuration and implementation options based on best practices
• Participate in the business requirements gathering process for customizations
• Lead/support Process Automation initiatives, for interfacing data structures and for connecting applications
• Act as a subject matter expert in data management technologies
• Ensure that all implementation methodology deliverables are complete and on time
• Perform other tasks related to Data Governance, Master Data Management, Open Data and Database Administration, as required
• Troubleshoot reporting, analytics and BI tools, systems and software and performance tune these applications, as necessary
• Act as project manager for data/analytics projects including generating project status, time, and expense reports as requested by the management
• Other relevant duties as required

Qualifications

• Experience related to the duties listed above normally acquired through post‑secondary education in computer science, computer programming or closely related field, and considerable experience in the design and construction of Data Integration Architectures, ETL/ELT pipelines, preferably with Informatica and Azure Data Technologies. Candidates with an equivalent combination of education and experience may be considered.
• Using Gen AI to extract and summarize key information from reports, identify trends, patterns and deliver insights
• Experience in implementing and supporting Data Governance Frameworks and overall Information Management for structured and unstructured data
• Extensive experience with Power BI and/or other data visualization and analytics tools
• Progressive experience in the design and deployment of Metadata and Master Data systems for domains like Asset, Customer or Location Master
• Knowledge of data integration architectures
• Comprehensive Data Lake and Data Warehouse analysis and design experience, with SQL Server/Oracle databases, ESRI GeoDatabase and NoSQL Databases
• Ability to analyze business and technical requirements for data lifecycle management and build full stack web applications
• Ability to lead projects and team members under limited supervision
• Superior organizational and project management skills
• Experience working with different SDLC methods including Agile, Scrum, Kanban
• Time management skills in a dynamic delivery environment