Data and Analytics Technologist

Atco Group; Calgary; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Competitive compensation

Flex benefits

Tuition assistance program

Training and mentorship programs

Charitable donation matching

Job summary

ATCO is seeking a Data & Analytics Technologist to design, build, and support enterprise data pipelines, data products, and analytics solutions that turn complex information into trusted insights. You will collaborate with architects, analysts, developers, and platform teams to deliver scalable, secure data solutions across the organization.

You will work with Azure Databricks, ADF, and ADLS Gen2 to enable trusted data for Power BI and other analytics platforms, ensuring data quality,

Qualifications

• Bachelor’s degree or higher in a related field.
• 5+ years of experience in data engineering with enterprise-scale cloud data platforms.
• 2+ years building production data pipelines in Azure Databricks.
• Hands-on with Spark architecture and optimization techniques.
• Proficient in Python (PySpark) and SQL.
• Experience securing ADLS Gen2 and integrating secrets via Key Vault.
• Experience with Azure Data Factory.
• Experience with Git version control.
• Experience with Unity Catalog for centralized governance.
• Scala or Java experience is a plus.

Responsibilities

• Design, build, and maintain scalable data pipelines and ELT/ETL processes.
• Develop data products, transformations, and enrichment processes.
• Build and maintain the Enterprise Data Lakehouse using Microsoft Fabric, Databricks, Azure Data Factory, and Azure storage.
• Develop data warehouse and lakehouse solutions for performance and scalability.
• Implement data quality controls and monitor data pipelines.
• Apply data governance for metadata, lineage, and retention.
• Collaborate with BI developers and analysts on datasets for dashboards and analytics.
• Enable governed access to enterprise data for analytics platforms.
• Monitor pipelines and provide operational support.
• Improve automation, reliability, and cost efficiency while maintaining documentation.

Skills

Python (PySpark)

SQL

Azure Databricks

Azure Data Factory

Azure Data Lake Storage Gen2

Azure Key Vault

Git version control

Unity Catalog

Spark architecture

Scala or Java

Education

Bachelor’s degree in Computer Science / IT / Engineering / Data Analytics

Tools

Azure Databricks

Azure Data Factory

Azure Data Lake Storage Gen2

Azure Key Vault

Git

Unity Catalog

Job description

Why Work Here?

At ATCO, growth is more than career progression, it's about continually learning, taking on new challenges, and expanding your impact. As a Data & Analytics Technologist, you'll work with modern cloud and data technologies while helping shape enterprise-wide solutions that influence decisions across the business. You'll be trusted to contribute, encouraged to innovate, and supported by a collaborative team that invests in your development and well-being. If you're looking for meaningful work and opportunities to grow your expertise, ATCO is a place where you can build a career without boundaries.

About the Role:

Shape how data drives decisions across ATCO. As a Data & Analytics Technologist, you will design, build, and support enterprise data pipelines, data products, and analytics solutions that turn complex information into trusted, actionable insights.

Working with architects, analysts, developers, and platform teams, you will deliver scalable, reliable, secure, and cost-effective data solutions that support informed decision-making across the organization.

What You Get to Do:

• Design, build, and maintain scalable data pipelines and ELT/ETL processes that integrate data from enterprise applications, APIs, files, databases, and cloud services for real-time, near-real-time, and batch processing.
• Develop data products, transformations, and enrichment processes that provide reliable, self-service access to analytics and reporting.
• Develop and maintain ATCO’s Enterprise Data Lakehouse using Microsoft Fabric, Databricks, Azure Data Factory, Azure Data Lake Storage, and related technologies.
• Build and optimize data warehouse, lakehouse, and semantic model solutions for performance, scalability, reliability, and operational efficiency.
• Implement data quality controls, validation, and monitoring, and lead root cause analysis and resolution when issues arise.
• Apply data governance standards for metadata, lineage, classification, and retention while ensuring solutions meet security, privacy, compliance, and governance policies.
• Partner with BI developers, analytics engineers, data analysts, and business stakeholders to design datasets and models for reporting, dashboards, and advanced analytics.
• Enable trusted, governed access to enterprise data through data structures optimized for Power BI and other analytics platforms.
• Monitor and troubleshoot data pipelines and platform services, resolve incidents, and provide operational support.
• Improve automation, reliability, maintainability, and cost efficiency while maintaining technical documentation, operational procedures, and data engineering standards.

What You Bring:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Analytics, or a related discipline.
• 5+ years of experience in data engineering, with a strong focus on enterprise-scale cloud data platforms
• 2+ years of experience architecting and building production data pipelines within Azure Databricks
• Hands-on experience with Spark architecture (executors, partitions, transformations) and optimization techniques (OPTIMIZE, Z-ORDER, VACUUM)
• Highly proficient with Python (PySpark) and SQL
• Strong experience securing and managing Azure Data Lake Storage Gen2 (ADLS Gen2) and integrating secrets via Azure Key Vault
• Experience building enterprise data workflows using Azure Data Factory (ADF)
• Experience with Git version control
• Proven experience implementing Unity Catalog for centralized data governance
• Experience with Scala or Java is an asset

What We Offer:

• A culture based on caring, integrity, agility, collaboration, and striving for excellence
• Competitive compensation
• Flex benefits
• Tuition assistance program
• Training and mentorship programs
• Charitable donation matching

We would like to thank everyone for their application; however, only those being considered for an interview will be contacted.

ATCO delivers inspired solutions for a better world. We are a diversified global corporation with investments in the essential services of Structures & Logistics, Utilities, Energy Infrastructure, Retail Energy, Transportation and Commercial Real Estate. Learn more about how we build communities, energize industries and deliver customer-focused solutions like no other company in the world at www.atco.com. ATCO is proud to be an equal opportunity employer. Visit our website for more information.

In the spirit of reconciliation, we acknowledge the traditional territories and homelands on which many of our ATCO operations and facilities are located. We honour and respect the diverse history, languages, ceremonies, and culture of the Indigenous Peoples who call these areas home.