Data Product Analyst DRAS

Compunnel Inc.

Edmonton

On-site

CAD 120,000 - 180,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Compunnel, Inc. is seeking a DRAS Data Product Analyst to design, develop, and operate trusted data products supporting regulatory oversight and evidence-based decisions.

You will leverage Azure services, Databricks, Delta Lake, Python, SQL, and Synapse to deliver analytics-ready datasets for the Digital Regulatory Assurance System. Collaborating with business, technical, and product stakeholders, you will ensure data assets are governed, compliant, and aligned with regulatory priorities while

Qualifications

  • 9+ years of relevant experience in data roles.
  • 3+ years designing data solutions with Power BI and Synapse, including semantic layers and data marts.
  • 4+ years using Git or GitHub for version control and data engineering workflows.
  • 3+ years using Azure Storage, SQL, Synapse, and networking to build scalable data solutions.
  • Experience securing Azure data pipelines using service principals and RBAC.
  • 5+ years using Python (incl. PySpark) and SQL for ETL/ELT workflows.
  • 3+ years with Azure Databricks, Delta Lake, Workflows and cluster management.
  • 1+ year using AI for code generation, data analysis, and automation.

Responsibilities

  • Understand data product objectives, regulatory requirements, business needs, and success criteria.
  • Design scalable and secure Azure data solutions (Storage, SQL, Synapse, networking).
  • Develop and optimize data ingestion/transformation pipelines (ADF, Databricks, Python, SQL, Delta Lake).
  • Build Databricks Workflows, Jobs, Notebooks, and clusters to support data operations.
  • Create standardized data products, data marts, semantic layers, and analytics-ready datasets for reporting and AI use cases.
  • Monitor pipelines, enforce data quality, governance, and security; troubleshoot data products.
  • Apply AI and automation to improve code development, data analysis, and documentation.

Skills

Data analysis
Stakeholder collaboration
Regulatory/compliance focus
Data governance

Tools

Azure Data Factory
Azure Databricks
Delta Lake
Python
PySpark
SQL
Synapse Analytics
Power BI
Git/GitHub

Job description

Job Summary

The DRAS Data Product Analyst designs, develops, and operates trusted data products that support regulatory oversight, compliance monitoring, and evidence-based decision-making. This role uses Microsoft Azure services, Azure Databricks, Delta Lake, Python, PySpark, SQL, and Synapse Analytics to deliver secure, scalable, and analytics-ready datasets for the Digital Regulatory Assurance System. The position works closely with business, technical, and product stakeholders to ensure DRAS data assets are reliable, governed, and aligned with regulatory and operational priorities.

Key Responsibilities
  • Work with business stakeholders, product owners, architects, and delivery teams to understand data product objectives, regulatory requirements, business needs, and success criteria.
  • Design and implement scalable and secure Azure data solutions using Azure Storage, Azure SQL, Synapse Analytics, networking services, service principals, and managed identities.
  • Develop, orchestrate, and optimize data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks, Python, PySpark, SQL, and Delta Lake.
  • Build and maintain Databricks Workflows, Jobs, Notebooks, clusters, and processing environments that support timely and reliable data operations.
  • Design and curate standardized, high-quality data products, data marts, semantic layers, and analytics-ready datasets for regulatory reporting, compliance monitoring, self-service analytics, and future AI use cases.
  • Monitor and troubleshoot data pipelines and data products, implementing data quality controls, error handling, security, governance, lineage, performance optimization, and operational support processes.
  • Apply AI and automation tools to improve code development, data analysis, testing, documentation, monitoring, and continuous improvement across data engineering workflows.
Required Qualifications
  • Minimum 9 years of relevant experience.
  • Minimum 3 years of experience designing data solutions for trusted, analytics-ready datasets using tools such as Power BI and Synapse, including semantic layers, data marts, and data products.
  • Minimum 4 years of experience using Git or GitHub for version control, collaborative development, code management, code review, and data engineering workflows.
  • Minimum 3 years of experience using Azure services such as Storage, SQL, Synapse, and networking to build scalable and secure data solutions.
  • Demonstrated experience securing Azure data pipelines and integrations using service principals, managed identities, role-based access, and appropriate authentication controls.
  • Minimum 5 years of experience using Python, including PySpark, and SQL to develop, orchestrate, optimize, and troubleshoot enterprise-grade ETL/ELT workflows.
  • Minimum 3 years of hands-on experience with Azure Databricks, Delta Lake, Workflows, Jobs, Notebooks, and cluster management.
  • Minimum 1 year of experience using AI for code generation, data analysis, automation, productivity improvement, and data engineering workflow support.
Preferred Qualifications
  • Minimum 6 years of experience performing business requirements analysis related to data manipulation, transformation, cleansing, and data wrangling.
  • Minimum 6 years of experience with Microsoft SQL Server, including database design, optimization, and administration in enterprise environments.
  • Experience with Microsoft Fabric and Azure Synapse Analytics, RESTful API integration, message queueing technologies such as ActiveMQ or Azure Service Bus, and cross-functional delivery of software applications and data products.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Product Analyst
Data Product Analyst

Compunnel Inc. • Edmonton

On-site
CAD 110,000 - 150,000
Data Engineer - Senior JP991
Data Engineer - Senior JP991

P@thlion Staffing Careers • Edmonton

On-site
CAD 70,000 - 100,000
Data Engineer - Intermediate (REMOTE) JP975
Data Engineer - Intermediate (REMOTE) JP975

Pathlion • Edmonton

Remote
CAD 90,000 - 120,000
Senior Data Governance Engineer
Senior Data Governance Engineer

Compunnel Inc. • Canada

On-site
CAD 90,000 - 120,000
Azure Cloud Data Engineer
Azure Cloud Data Engineer

Compunnel Inc. • Mississauga

On-site
CAD 100,000 - 130,000
Data Science Developer - Senior JP210
Data Science Developer - Senior JP210

P@thlion Staffing Careers • Fredericton

On-site
CAD 70,000 - 110,000
Databricks Engineer
Databricks Engineer

Compunnel Inc. • Mississauga

On-site
CAD 120,000 - 150,000
Azure Data Bricks Consultant
Azure Data Bricks Consultant

Compunnel Inc. • Toronto

On-site
CAD 110,000 - 170,000
Azure Data Engineer
Azure Data Engineer

Rivago Infotech Inc • Toronto

On-site
CAD 90,000 - 150,000
Data Science Developer - Senior (ONSITE) JP210
Data Science Developer - Senior (ONSITE) JP210

Pathlion • Toronto

On-site
CAD 90,000 - 120,000