SAS​/Python Developer

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, house holding, 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…