Data Solutions Engineer

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

• Bachelors 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

• Masters 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 intelligenceresponsibly 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 worlds 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 journeybuilding 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 2000 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 Canadas 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 Corporations 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 @ or @ 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 to inquire about jobs at Adastra to report a suspicious request for money or personal information from external websites or suspicious employment offers.