Data and Analytics Technologist
Role Overview
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.
Key Skills for This Role
Full Job Posting
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.
Qualifications
- 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
About ATCO
Public Canadian holding company providing housing, energy infrastructure, defence services, and retail energy to businesses and governments.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at ATCO
Labourer (Temporary)
Viking, CAN
Construction Estimator - Quantity Surveyor
Calgary, CAN
Advisor, Customer Care
Calgary, CAN
Accommodations Manager
, CAN
Project Coordinator
Calgary, CAN
Chef Manager - Future Opportunity
, CAN
Senior Financial Accountant
Calgary, CAN
Représentant, Ventes internes
Ottawa, CAN