Data and Analytics Technologist

ATCO; Calgary; On-site; CAD 110,000 - 170,000; Full time

Benefits offered by this job

Competitive compensation

Flex benefits

Tuition assistance

Training and mentorship

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, actionable insights. You will work with architects, analysts, developers, and platform teams to deliver scalable, reliable, and cost-efficient data solutions that inform decisions across the organization.

You will enable governed data access for Power BI and other analytics platforms while upholding security,

Qualifications

• Bachelor's degree in a related field is required.
• 5+ years in data engineering with enterprise cloud platforms.
• 2+ years architecting production data pipelines in Azure Databricks.
• Strong Python (PySpark) and SQL skills.
• Experience with ADLS Gen2, Unity Catalog, and secret management.

Responsibilities

• Design, build, and support enterprise data pipelines and data products.
• Develop scalable, secure data solutions for real-time and batch processing.
• Collaborate with architects, analysts, and platform teams to meet business needs.
• Enable governed data access for Power BI and analytics platforms.
• Implement data quality, governance, and metadata lineage.
• Monitor pipelines and provide runbook-style operational support.

Skills

PySpark

SQL

Azure Databricks

Spark

Azure Data Factory

ADLS Gen2

Unity Catalog

Git

Scala/Java

Python

Power BI

Education

Bachelor's degree

Tools

Azure Databricks

Azure Data Factory

Databricks

Power BI

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.