CrawlJobs Logo

Big Data Dbt/redshift Engineer

Canada, Vancouver · Job Posted March 04, 2026
Apply Position
Job Link Share

Job Description

We are seeking a Lead Data Engineer to join a client-focused data pod delivering large-scale data engineering solutions within a cloud-native AWS environment. This is a delivery-first role requiring deep hands-on expertise in streaming data architectures, big data systems, and modern data warehousing practices. You will own streaming architectural direction while remaining actively involved in implementation. The environment is AWS-centric (Redshift, S3, Glue, Step Functions, Lambda, EMR), with DBT as the transformation framework. We are actively integrating streaming data from GCP sources into our AWS data platform. You will define engineering standards across data modeling, DBT implementation, testing, CI/CD, and production resiliency while collaborating directly with the client’s data team.

Job Responsibility

  • Own the architectural direction for streaming data ingestion from GCP into AWS
  • Design resilient ingestion frameworks including error handling, retry strategies, monitoring, and failure isolation
  • Implement distributed processing pipelines using Spark / PySpark or similar frameworks
  • Create and maintain scalable data warehouses and associated ETL/ELT processes using DBT models in Amazon Redshift
  • Design and implement DBT projects including macros, tests, documentation, and reusable modeling patterns
  • Conduct Redshift query and DBT performance tuning to optimize warehouse efficiency and cost
  • Define and enforce best practices for: Data modeling
  • Version control (Git-based workflows)
  • CI/CD pipelines for DBT deployments
  • Automated testing at model, transformation, and pipeline levels
  • Ensure robust testing is embedded into every DBT model (schema tests, custom tests, data validation checks)
  • Lead code reviews and architectural design reviews
  • Work with AWS services including Redshift, S3, Glue, Step Functions, Lambda (Python), Athena, and EMR

Requirements

  • 6+ years of data engineering experience in big data environments
  • Proven experience designing and implementing streaming architectures
  • Extensive hands-on DBT experience (models, macros, tests, documentation)
  • Strong Amazon Redshift architecture and performance optimization expertise
  • Experience building CI/CD pipelines for data platforms
  • Experience working in client-facing delivery contexts
  • AWS: Redshift, S3, Glue, Step Functions, Lambda (Python), Athena, EMR
  • Strong SQL and Redshift performance tuning expertise
  • Python and PySpark (or equivalent distributed processing frameworks)
  • Git-based version control workflows
  • Deep understanding of data warehousing, modeling, and big data systems

Nice to have

Streaming experience preferred

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Big Data Dbt/redshift Engineer

8 matching positions

New

Cabin Crew

Would you like to be part of the Ryanair Group’s amazing cabin crew family of 16...
Location
Location
Spain , Madrid
Salary
Salary:
Not provided
ryanair.com Logo
Ryanair - Europe's Favourite Airline
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Applicants must hold the unrestricted right to live and work in the EU and travel freely throughout the Ryanair Network
  • You must approximately be between 5"2 (157 cm) and 6"2 (188 cm) in height
  • You must be able to swim 25 meters unaided
  • It helps if you are hardworking, flexible and have an outgoing and friendly personality
  • Adaptable and happy to work a shift roster
  • Enjoy dealing with the public and have the ability to provide excellent customer service with a 'can do' attitude
  • Comfortable speaking and writing in English with ease
  • A passion for travelling and meeting new people
Job Responsibility
Job Responsibility
  • Delivering a top-class safety & customer service experience to our guests
  • You will be required to operate both early & late shifts & report for duty as early as 5 am in the morning on the early roster & not return home until midnight on the afternoon roster
What we offer
What we offer
  • Free Internationally recognised Cabin Crew Training Course
  • Daily per Diem whilst training – €28 per day
  • Uncapped Sales bonus
  • Unlimited highly discounted Staff Travel
  • Fixed roster pattern
  • The adventure and experience of a lifetime within our Cabin Crew network
  • Explore new cultures and cities with colleagues on your days off
  • Free Uniform in Year 1 and annual allowance afterwards
  • Security of working for a financially stable Airline
  • Fulltime
Read More
Arrow Right
New

Mobile Associate, Store-in-Store - Retail Sales

Mobile Associates, Store-in-Store are an integral part of the Retail Team respon...
Location
Location
United States , Concord
Salary
Salary:
19.50 - 20.00 USD / Hour
https://www.t-mobile.com Logo
T-Mobile
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High School Diploma/GED
  • 6 months of customer service and/or sales experience, Retail environment preferred
  • Customer Satisfaction Passionate customer advocate with the desire to be yourself when connecting and having fun with our customers. Effective at balancing customer experience and performance goals
  • Team Building Desire to be a part of the game-changing T-Mobile store team. Willingness to work alongside peers and store leaders, learning and sharing best practices, while serving customers and providing resolutions to issues
  • Retail Sales Competitive drive and confidence to succeed in a fast-paced sales environment
  • At least 18 years of age
  • Legally authorized to work in the United States
Job Responsibility
Job Responsibility
  • Proactively engages with a broad range of customers in a highly-traffic retail environment
  • Use digital tools, communicate effectively, educate customers, and showcase the value of T-Mobile solutions
  • Consistently leverage digital self-serve tools during customer interactions and the onboarding process
  • Identify customer needs and use solution-based selling techniques to fully demonstrate the value of T-Mobile products and services
  • Recommend wireless solutions, and an onboarding solution centric to helping customers understand how to self-serve and utilize the T-Mobile app for wireless needs
  • Complete training on the T-Mobile in-store experience, new skills, products and processes, and knowledge of systems and reference resources
  • Review personal results, current promotions, and updates on the Hub to be Customer Ready at all times
  • Partner with nearby store locations to properly/fully on-board customers
  • Perform skills practicing, knowledge sharing, store operations, opening and closing procedures
  • Carry keys to the kiosk cabinets, lock/secure kiosk and assets, and report any lost keys or assets to your manager
What we offer
What we offer
  • Medical, dental and vision insurance
  • Flexible spending account
  • 401(k)
  • Employee stock grants
  • Employee stock purchase plan
  • Paid time off and up to 12 paid holidays - which total about 4 weeks for new full-time employees and about 2.5 weeks for new part-time employees annually
  • Paid parental and family leave
  • Family building benefits
  • Back-up care
  • Enhanced family support
  • Parttime
Read More
Arrow Right
New

Cabin Crew

Would you like to be part of the Ryanair Group’s amazing cabin crew family of 16...
Location
Location
Spain , Madrid
Salary
Salary:
Not provided
ryanair.com Logo
Ryanair - Europe's Favourite Airline
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Applicants must hold the unrestricted right to live and work in the EU and travel freely throughout the Ryanair Network
  • You must approximately be between 5 "2 (157 cm) and 6" 2 (188 cm) in height
  • You must be able to swim 25 meters unaided
  • It helps if you are hardworking, flexible and have an outgoing and friendly personality
  • Adaptable and happy to work a shift roster
  • Enjoy dealing with the public and have the ability to provide excellent customer service with a 'can do' attitude
  • Comfortable speaking and writing in English with ease
  • A passion for travelling and meeting new people
Job Responsibility
Job Responsibility
  • delivering a top-class safety & customer service experience to our guests
  • operating both early & late shifts & report for duty as early as 5 am in the morning on the early roster & not return home until midnight on the afternoon roster
What we offer
What we offer
  • Free Internationally recognised Cabin Crew Training Course
  • Daily per Diem whilst training – €28 per day
  • Uncapped Sales bonus
  • Unlimited highly discounted Staff Travel
  • Fixed roster pattern
  • The adventure and experience of a lifetime within our Cabin Crew network
  • Explore new cultures and cities with colleagues on your days off
  • Free Uniform in Year 1 and annual allowance afterwards
  • Security of working for a financially stable Airline
  • Fulltime
Read More
Arrow Right
New

Account Executive

Usercentrics is a global leader in the field of consent management platforms (CM...
Location
Location
United States
Salary
Salary:
90000.00 - 100000.00 USD / Year
80twenty.com Logo
80Twenty
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2–5 years of B2B SaaS sales experience, ideally with exposure to privacy, martech, or legaltech
  • Demonstrated success in both outbound prospecting and closing new business
  • Strong verbal and written communication skills, with the ability to simplify complex concepts
  • A consultative sales approach focused on value creation and long-term client success
  • Familiarity with Salesforce, HubSpot, SalesLoft, or similar CRM/Sales engagement platforms
  • Self-starter with high accountability and a growth mindset
Job Responsibility
Job Responsibility
  • Identify and engage key decision-makers at target accounts using outbound outreach (cold calling, email, and LinkedIn)
  • Qualify inbound leads from marketing and move them into active sales conversations
  • Conduct discovery calls to assess fit and align on customer pain points and needs
  • Build and maintain a healthy pipeline through strategic prospecting and market segmentation
  • Collaborate with Marketing to optimize campaign follow-up and lead handoffs
  • Manage the entire sales process from discovery to proposal, negotiation, and close
  • Deliver engaging product demonstrations and tailor the solution to customer requirements
  • Build trusted relationships with legal, marketing, and compliance teams within target organizations
  • Strategically pursue mid-market and enterprise accounts across regulated industries
  • Provide accurate sales forecasting and CRM hygiene through HubSpot (or similar tools)
What we offer
What we offer
  • 401K plan contribution
  • Commuter Allowance (transit stipend)
  • 20 paid vacation days (PTO)
  • Health insurance
  • Development Budget for every employee
  • Hybrid workplace
  • Online yoga sessions
  • Headspace App
  • Events – Team Buildings, happy hours, parties/get togethers, occasional company covered breakfasts/lunches, in/across offices, online/in person etc
  • Gifts – We celebrate life & work milestones at UC (work anniversaries, new bom babies and similar)
  • Fulltime
Read More
Arrow Right
New

Senior TAC Escalation Team - Advisor

The TAC Escalation Team (E-Team) Consultant provides live and remote support to ...
Location
Location
United States
Salary
Salary:
69900.00 - 107300.00 USD / Year
gm.com Logo
General Motors
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school diploma with 10+ years of automotive technician experience, or an equivalent combination of education and automotive technician experience
  • Minimum of 4 current ASE Certifications
  • Customer-focused mindset with strong interpersonal skills and the ability to anticipate customer and dealer impact
  • Expert knowledge of TAC ETA processes and a strong understanding of major automotive systems, diagnostic practices, and escalation workflows
  • Ability to maintain technical certifications
  • Excellent oral and written communication skills, including the ability to adapt communication to the audience and present effectively to leadership and cross-functional partners
  • Strong analytical, critical-thinking, and problem-solving skills with the ability to assess multiple factors, diagnostic information, and in-depth research
  • Excellent organizational skills and the ability to manage priorities effectively
  • Strong leadership presence with the ability to build credibility, align stakeholders, and drive decisions across multiple functions
  • Proven ability to mentor, coach, and develop others in diagnostic approach, escalation handling, and problem resolution
Job Responsibility
Job Responsibility
  • Support TAC Advisors and escalation team members as needed to diagnose and resolve complex vehicle concerns
  • Partner with Brand Quality, Engineering, and cross-functional teams to identify new and emerging product issues, define patterns, and escalate when appropriate
  • Create and publish bulletins within Service Information and contribute clear product issue and resolution communication
  • Serve as the single TAC point of contact for assigned areas of technical support across: All GCCX Business Units, Field Personnel including CAM, RVM, DMPS, and FSE, Executive Leadership
  • Exercise sound independent judgment to assess issues, propose solutions to leadership, and determine the most appropriate course of action within established procedures and broad guidelines
  • Build and maintain strong working relationships internally by exchanging relevant information with colleagues, supervisors, project leaders, and other professionals across the team and adjacent functions
  • Develop and lead presentations to support issue identification, resolution, cross-functional alignment, and business decision-making
What we offer
What we offer
  • Medical, dental, vision
  • Health Savings Account
  • Flexible Spending Accounts
  • Retirement savings plan
  • Sickness and accident benefits
  • Life insurance
  • Paid vacation & holidays
  • Tuition assistance programs
  • Employee assistance program
  • GM vehicle discounts
  • Fulltime
Read More
Arrow Right
New

Assistant Vice President Treasury Product Control

The role: As part of the Finance team, you'll help shape Barclays' financial str...
Location
Location
India , Chennai
Salary
Salary:
Not provided
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Valuation control or product control experience in a financial services environment
  • Strong communication skills including the ability to distil complex issues into an easy to digest summary for senior management
  • Strong understanding of Financial Derivatives, Treasury products
  • Coding skills in Python/VBA or equivalent
  • Good understanding of Microsoft Office products
  • Experience with Bloomberg, Reuters terminals
  • Proactive change champion who looks to develop and embed best practice
  • Strong communicator (written and interpersonal) with an understanding of senior management perspective
  • Confident and assertive with the ability to negotiate and influence constructively across teams and geographies
  • Capable reviewer of meeting materials and commentary, with a high level of attention to detail
Job Responsibility
Job Responsibility
  • Reconciliation of daily profit and loss (P&L) figures for trading desks to ensure they align with the valued positions in the trading book, investigating and resolving discrepancies between P&L figures to ensure they reflect the true economic value of the trading portfolio
  • Support the identification, assessment, and mitigation of trading risks, and report on these financial risks to senior colleagues
  • Maintenance and analysis of the bank’s trading data, ensuring its accuracy, completeness and consistency, and provision of insights to traders and senior colleagues on trading performance
  • Preparation and submission of regulatory reports to authorities, and provision of support to external audits including addressing auditor queries and ensuring trading activities are appropriately reflected in financial statements
  • Effective communication of complex financial information to traders, risk professionals, senior colleagues, and external stakeholders
  • Cross functional collaboration to ensure a coordinated approach to trading activities.
  • Fulltime
Read More
Arrow Right
New

Staff Software Engineer - Machine Learning

Role: The Smart Agents group is responsible for building the ML models and syste...
Location
Location
United States
Salary
Salary:
134000.00 - 235900.00 USD / Year
gm.com Logo
General Motors
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 4+ years of experience in the field of robotics or latency-sensitive backend services
  • Background working with machine learning teams, algorithms, and models
  • Strong programming skills in modern C++ or Python
  • Experience building highly performant ML and system pipelines
  • Experience with profiling CPU and/or GPU software, process scheduling, and prioritization
  • Passionate about self-driving car technology and its impact on the world
  • Expertise in setting architectures that are scalable, efficient, fault-tolerant, and are easily extensible
  • Ability to design across multiple systems
  • Ability to both investigate in sophisticated areas as well as a good breadth of understanding of systems outside of your domain
  • Ability to wear several hats shifting between coding, design, technical strategy, and mentorship
Job Responsibility
Job Responsibility
  • Support the team in developing machine learning (ML) and reinforcement learning (RL) models, including training loop development and optimization
  • Streamline integration and create ML infrastructure, metrics, and data pipelines for production model deployment and rapid experimentation
  • Work as part of an ML team and contribute strong software engineering (SWE) expertise
  • Support the ML team in accelerating project timelines, particularly in areas related to Autopilot, Lane Keep, and autonomous vehicle (AV) technologies
What we offer
What we offer
  • Health and wellbeing benefit programs
  • Medical
  • Dental
  • Vision
  • Health Savings Account
  • Flexible Spending Accounts
  • Retirement savings plan
  • Sickness and accident benefits
  • Life insurance
  • Paid vacation & holidays
  • Fulltime
Read More
Arrow Right
New

Data Engineer - SQL

Embark on a transformative journey as a "Data Engineer-SQL" at Barclays, where y...
Location
Location
India , Chennai
Salary
Salary:
Not provided
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Build and maintenance of data architectures pipelines that enable the transfer and processing of durable, complete and consistent data
  • Design and implementation of data warehoused and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures
  • Development of processing and analysis algorithms fit for the intended data complexity and volumes
  • In-depth technical knowledge and experience in assigned area of expertise
  • Thorough understanding of the underlying principles and concepts within the area of expertise
  • Lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources
  • Demonstrate leadership behaviours or for an individual contributor, develop technical expertise in work area, acting as an advisor where appropriate
  • Partner with other functions and business areas
  • Take responsibility for end results of a team's operational processing and activities
  • Escalate breaches of policies / procedure appropriately
Job Responsibility
Job Responsibility
  • Build and maintenance of data architectures pipelines that enable the transfer and processing of durable, complete and consistent data
  • Design and implementation of data warehoused and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures
  • Development of processing and analysis algorithms fit for the intended data complexity and volumes
  • Collaboration with data scientist to build and deploy machine learning models
What we offer
What we offer
  • Competitive holiday allowance
  • Life assurance
  • Private medical care
  • Pension contribution
  • Fulltime
Read More
Arrow Right