Senior AWS Data Engineer

Adastra is in search of a Senior AWS Data Engineer to design, build, and deliver high‑quality, analytics‑ready data solutions. This role focuses on developing strong data foundations and enterprise‑grade BI capabilities that enable reliable insights and informed decision‑making. You will work closely with business and technical stakeholders to translate complex requirements into scalable, maintainable data and reporting solutions.

Primary Location: Toronto, ON or New York City, NY

Work Model: Hybrid 3-Days Onsite

Employment Type: Contractor

Vacancy Status: New

RESPONSIBILITIES

• Design, build, and maintain analytics-ready datasets
• Develop and maintain enterprise-grade BI dashboards with advanced visualizations and calculated fields
• Write, optimize, and maintain complex SQL queries to support analytical and reporting needs
• Ensure strong data foundations by validating data accuracy, completeness, and consistency prior to visualization
• Analyze complex datasets to identify trends, anomalies, and data quality issues
• Resolve underlying data issues in collaboration with upstream data contributors
• Translate ambiguous business requirements into effective BI and data solutions
• Partner with technical and non-technical stakeholders to align on requirements and outcomes
• Apply creative problem-solving techniques to address tooling or platform limitations
• Balance solution complexity with long-term maintainability and sustainability
• Perform rigorous and proactive quality assurance to ensure high standards of delivery
• Manage multiple priorities effectively in a fast-paced environment
• Use version control tools to support collaboration, code reviews, and reuse of data and BI assets
  

QUALIFICATIONS, SKILLS & EXPERIENCE

• Senior-level experience in data engineering, analytics engineering, or BI engineering
• Proven experience building enterprise-grade dashboards using BI tools such as QuickSight or equivalent
• Strong proficiency writing and optimizing complex SQL queries
• Solid understanding of data modeling and analytics-ready dataset design
• Demonstrated experience working with complex, messy, or incomplete datasets
• Strong analytical skills with the ability to validate data accuracy and reliability
• Deep understanding of data quality and data integrity concepts
• Experience translating business requirements into technical data solutions
• Excellent communication skills across both business and technical audiences
• Experience collaborating with cross-functional teams in delivery-focused environments
• Strong ownership mindset with a high attention to detail and quality
• Ability to work independently while managing multiple workstreams and deadlines
  

NICE TO HAVE

• Experience migrating or rebuilding dashboards across BI platforms
• Experience working with multiple relational database technologies
• Familiarity with data architecture concepts such as data flows and lineage
• Exposure to data governance, privacy, or regulatory considerations
• Experience supporting enterprise-scale or complex reporting environments
• Background working on multiple concurrent analytics or data initiatives
  

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