DATA PRODUCT ANALYST

Job Title - Data Product Analyst (Azure Data Engineering & Analytics)

Location - Edmonton, Alberta (Remote with Occasional Onsite Meetings)

Employment Type - Contract

Interview Mode: Virtual Interview

About the Role

The Client's Environment and Protected Areas (EPA) division is seeking an experienced Data Product Analyst to support the modernization and expansion of the Digital Regulatory Assurance System (DRAS).

This role will focus on designing and delivering scalable, secure, analytics-ready data solutions that support regulatory oversight, compliance monitoring, geospatial modernization, and evidence-based decision-making.

The ideal candidate will bring strong expertise in Azure Data Engineering, Databricks, Synapse Analytics, Python/PySpark, ETL/ELT development, data governance, API integrations, cloud-native analytics, and enterprise data product development.

Key Responsibilities

Azure Data Engineering & Platform Development

• Design and implement scalable, secure, and high-performance data architectures on Microsoft Azure supporting cloud-native and hybrid environments

• Build and optimize data ingestion, transformation, and integration pipelines using:

– Azure Data Factory

– Azure Databricks

– Azure Synapse Analytics

– Azure Data Lake Storage Gen2

• Develop robust ETL/ELT workflows using Python, PySpark, SQL, and Databricks notebooks

Analytics & Data Product Development

• Design trusted, analytics-ready datasets supporting:

– Operational Reporting

– Power BI Dashboards

– Self-Service Analytics

– Data Science & Machine Learning Use Cases

• Develop semantic layers, data marts, and enterprise data products for modern reporting ecosystems

• Support data modeling, cleansing, transformation, enrichment, and advanced analytics initiatives

Data Governance, Security & Compliance

• Implement metadata management, lineage tracking, data classification, and governance controls within Databricks-based platforms

• Ensure compliance with privacy and regulatory standards including FOIP and GDPR through:

– Role-Based Access Controls

– Encryption

– Data Masking

– Secure Authentication Frameworks

• Support Service Principals, Managed Identities, and secure pipeline integrations across Azure services

Integration & API Development

• Integrate data from enterprise systems including:

– ServiceNow

– Geospatial Platforms

– Cloud Data Services

– Distributed Systems

• Build secure RESTful APIs supporting scalable data exchange and automation frameworks

• Support asynchronous integrations using message queuing technologies such as:

– ActiveMQ

– Azure Service Bus

AI & Automation Enablement

• Utilize AI-assisted development tools for code generation, optimization, testing, monitoring, and workflow automation

• Leverage automation to improve pipeline reliability, scalability, and development efficiency

Mandatory Skills & Qualifications

• Post-Secondary Degree, Diploma, or Certificate in Computer Science or related field

• 10+ years of experience with Python (including PySpark) and SQL for enterprise-scale ETL/ELT workflows in cloud environments

• 10+ years of experience performing business requirement analysis related to data transformation, cleansing, and wrangling

• 10+ years of experience with Microsoft SQL Server including database design, optimization, and administration

• 10+ years of experience collaborating with cross-functional teams to develop software applications and enterprise data products

Azure & Databricks Expertise

• 10+ years of experience building scalable data pipelines using:

– Azure Databricks

– Delta Lake

– Workflows

– Jobs & Notebooks

– Cluster Management

• 8+ years of experience with Azure services including:

– Azure Storage

– Azure SQL

– Azure Synapse Analytics

– Azure Networking

– Authentication & Security Services

• 8+ years of experience designing analytics-ready trusted datasets using:

– Power BI

– Synapse Analytics

– Semantic Models

– Data Products & Data Marts

Governance, Integration & Automation

• 10+ years of experience using GitHub/Git for collaborative development and version control

• 10+ years of experience building secure RESTful APIs for scalable data exchange and automation

• 10+ years of experience with message queuing technologies such as ActiveMQ and Azure Service Bus

• 10+ years of experience in data governance, security, and metadata management within Databricks platforms

• 7+ years of experience integrating Azure Synapse Analytics and Microsoft Fabric (Lakehouse, Warehouse, Semantic Models)

• 7+ years of experience building scalable ETL pipelines and integrations using Talend technologies

• 5+ year of experience using AI tools for code generation, automation, and productivity enhancement in data engineering workflows

• 5+ year of experience integrating ServiceNow with Azure-based Data Management Platforms

• 5+ year of direct experience building data products within the Government of Alberta cloud environment

Preferred Skills

• Experience with Microsoft Fabric, Lakehouse, and enterprise semantic modeling

• Experience supporting regulatory, environmental, or geospatial data modernization initiatives

• Exposure to machine learning enablement and AI-ready data platforms

• Experience supporting enterprise analytics ecosystems in public-sector environments

Work Environment & Additional Details

• Primarily remote role within Alberta with onsite meetings in Edmonton as required (approximately 3–4 times per month)

• Work must be performed from within Canada

• Standard work schedule: Monday–Friday | 8:15 AM – 4:30 PM Alberta Time

• Resource must provide compatible computer/equipment for Azure Virtual Desktop (AVD) access

• Criminal background check required prior to onboarding

Why Join Us

• Contribute to Alberta’s enterprise-scale regulatory modernization and digital transformation initiatives

• Build cloud-native analytics and data engineering solutions using modern Azure technologies

• Work with cutting-edge data platforms, AI-assisted workflows, and enterprise analytics ecosystems

• Collaborate with high-performing technical and business teams driving public-sector innovation

About NetworkPedia

NetworkPedia is a certified women-owned technology and talent solutions company, providing IT infrastructure, cybersecurity, managed services, and specialized recruitment across North Americas and beyond. Our mission is to empower organizations with secure, scalable, and innovative technology while building inclusive teams that reflect the communities we serve.

As a trusted partner, we deliver expertise across networking, cloud, IT service management, and security operations, along with staffing solutions for niche technology roles. We are committed to diversity, equity, and inclusion (DEI) in all our hiring practices and ensure that our opportunities are open to all qualified applicants, without discrimination on the basis of age, gender, race, ethnicity, religion, sexual orientation, or disability.

How to Apply

Apply directly via LinkedIn Easy Apply. All applications are routed to our central recruitment email id - [email protected]