Bachelor’s or Master’s degree in Computer Science, Data Engineering, Statistics, or a related field
3+ years of SAS development experience, including Base SAS, Macros, and PROC SQL
2+ years of Python development experience with pandas and SQL
Experience working with PySpark or distributed data processing frameworks
Strong SQL skills and experience with enterprise data warehouses such as Oracle, SQL Server, Teradata, or similar platforms
Hands-on experience developing and supporting ETL/ELT processes and data pipelines
Working knowledge of data modeling concepts, including dimensional modeling and data marts
Experience handling customer, financial, or other regulated data domains
Familiarity with Git, code review practices, and controlled release processes
Strong analytical, troubleshooting, documentation, and communication skills
Nice to have
Experience with customer data platforms (CDPs), MDM solutions, or CRM platforms such as Salesforce, Informatica MDM, Adobe Experience Platform, or Pega
Knowledge of entity resolution, matching algorithms, and customer identity management
Experience working with cloud and big data technologies, including AWS, Azure, Databricks, Snowflake, or Apache Spark
Experience with orchestration tools such as Airflow or Control-M
Familiarity with data quality, metadata, or catalog platforms such as Collibra or Great Expectations
Experience supporting marketing analytics, personalization, customer segmentation, or customer lifetime value initiatives
Understanding of data governance, data lineage, and privacy-by-design principles
Experience supporting Customer 360, customer master data, or customer analytics initiatives within financial services
Full description
Overview
Join Adastra’s Data Engineering team as a SAS/Python Developer, where you will help build and modernize the data platforms that power customer analytics, personalization, marketing, risk, and regulatory initiatives. In this role, you will develop and maintain scalable data pipelines, transform and integrate customer data from multiple sources, and support the migration of legacy SAS processes to modern Python and cloud-based technologies. You will play a key role in creating trusted customer data assets, improving data quality, and enabling business teams with a unified and reliable view of customers across the organization.
Primary Location: Across Canada
Work Model: Hybrid 2-Days Onsite
Employment Type: Permanent Full-Time
Vacancy Status: New
Compensation Range: $65,000 – $75,000 CAD
RESPONSIBILITIES
Design, build, and maintain ETL/ELT pipelines that integrate customer, account, product, and transaction data from multiple enterprise data sources
Develop and maintain SAS programs using Base SAS, Macros, and PROC SQL to support customer data marts, segmentation, and campaign selection processes
Build Python-based data processing and automation solutions using pandas, PySpark, and SQL
Migrate legacy SAS processes to Python and Spark while validating and reconciling outputs to ensure accuracy
Develop and maintain customer master data solutions, including identity resolution, deduplication, householding, and golden record management
Create Customer 360 datasets, behavioral and demographic attributes, and reusable data assets for analytics and data science teams
Implement data quality controls, profiling, reconciliation processes, and data lineage documentation
Apply data privacy and regulatory controls, including PII protection, consent management, and compliance requirements
Optimize batch and near-real-time data processing workloads for performance and scalability
Monitor production data pipelines, support service-level agreements, and resolve data-related incidents
Collaborate with business stakeholders, including marketing, risk, compliance, BI, and data science teams, to define and deliver data products
Contribute to documentation, code reviews, release management, and continuous improvement initiatives
QUALIFICATIONS, SKILLS & EXPERIENCE
Bachelor’s or Master’s degree in Computer Science, Data Engineering, Statistics, or a related field
3+ years of SAS development experience, including Base SAS, Macros, and PROC SQL
2+ years of Python development experience with pandas and SQL
Experience working with PySpark or distributed data processing frameworks
Strong SQL skills and experience with enterprise data warehouses such as Oracle, SQL Server, Teradata, or similar platforms
Hands-on experience developing and supporting ETL/ELT processes and data pipelines
Working knowledge of data modeling concepts, including dimensional modeling and data marts
Experience handling customer, financial, or other regulated data domains
Familiarity with Git, code review practices, and controlled release processes
Strong analytical, troubleshooting, documentation, and communication skills
NICE TO HAVE
Experience with customer data platforms (CDPs), MDM solutions, or CRM platforms such as Salesforce, Informatica MDM, Adobe Experience Platform, or Pega
Knowledge of entity resolution, matching algorithms, and customer identity management
Experience working with cloud and big data technologies, including AWS, Azure, Databricks, Snowflake, or Apache Spark
Experience with orchestration tools such as Airflow or Control-M
Familiarity with data quality, metadata, or catalog platforms such as Collibra or Great Expectations
Experience supporting marketing analytics, personalization, customer segmentation, or customer lifetime value initiatives
Understanding of data governance, data lineage, and privacy-by-design principles
Experience supporting Customer 360, customer master data, or customer analytics initiatives within financial services
ABOUT ADASTRA
Adastra is a global leader in AI and data-driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.
Trusted by some of the world’s most prominent brands, Adastra delivers end-to-end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future-ready capabilities and delivering measurable, lasting impact.
Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.
WHAT WE OFFER
Opportunity for advancement and career progression
Competitive compensation package
Comprehensive benefits plan
Successful referral program
The opportunity to work with one of Canada’s 50 Best Managed Companies
Satisfaction of working for a reputable company
A flexible, dynamic, and diverse workplace
EQUAL OPPORTUNITY EMPLOYER
In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.
AI Usage - Our hiring process includes the use of AI-enabled tools to screen applications (e.g., keyword matching, qualification ranking). A human recruiter reviews all AI-generated shortlists to make informed hiring decisions.
There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from ‘@adastragrp.com’ or ‘@talent.icims.com’ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.
Contact careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.