Data Solutions Engineer
Overview
The role of a Data Solutions Engineer sits at the intersection of business requirements and production data systems, translating complex, cross-functional problems into scalable and well-architected data solutions. The position focuses on designing and delivering data solutions across modern AWS-based data platforms, ensuring seamless integration between operational and analytical systems. The successful candidate will work closely with business stakeholders, lead solution design efforts, and enable downstream teams through strong documentation, handoff processes, and reusable design patterns. Primary Location: Across Canada or USA Work Model: Fully Remote Employment Type: Contractor Vacancy Status: New RESPONSIBILITIES Collaborate with cross-functional stakeholders (e.g., Marketing, Analytics, Privacy, Legal) to translate business problems into scalable data solutions Lead discovery sessions and define solution architecture, including data models, pipelines, and integration patterns Produce clear design artifacts such as data models, schemas, data contracts, sequence diagrams, and runbooks Embed privacy-by-design principles, including consent management, PII classification, and data governance controls into all solutions Lead proof-of-concepts (POCs) and support vendor/tool evaluations Develop and maintain data models, transformations, and packages using dbt with strong lineage and documentation Design and build scalable AWS-based data pipelines using services such as S3, Glue, Lambda, Step Functions, EventBridge, and Kinesis Design and optimize Redshift solutions, including distribution/sort keys, workload management, and cost-performance tuning Build and define integration patterns between data platforms and external systems (e.g., martech, personalization, activation platforms) Establish CI/CD and infrastructure-as-code (IaC) standards using tools such as Terraform or AWS CDK Define testing strategies, monitoring, and observability frameworks for production readiness Create runbooks, define SLAs/SLOs, and enable operational handoff to downstream engineering teams Contribute reusable components, reference architectures, and best practices to improve team-wide delivery standards QUALIFICATIONS, SKILLS & EXPERIENCE Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related technical field 5+ years of experience in data engineering and analytics on modern data platforms 3+ years of hands-on experience with dbt or similar data transformation frameworks Strong proficiency in SQL and experience working with large-scale datasets Hands-on experience working with AWS services such as S3, Glue, Lambda, Step Functions, Redshift, and Kinesis Strong experience designing and implementing dimensional data models and enterprise data warehouse solutions Strong understanding of change data capture (CDC) concepts and data pipeline design patterns Experience with CI/CD and infrastructure automation tools such as AWS CDK, CodePipeline, or similar Experience with Python and familiarity with Jinja templating or PySpark Experience working in agile environments and collaborating with distributed/offshore teams Strong communication and stakeholder management skills, with the ability to translate business requirements into technical solutions NICE TO HAVE Master’s degree in a quantitative or technical field Experience with consent management tools (e.g., OneTrust) Experience designing solutions for martech, customer engagement, or personalization platforms Familiarity with data privacy, regulatory, and governance frameworks Experience building reusable frameworks or reference architectures 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 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 [email protected] to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers. Apply To This Job