Sparq Logo

Sparq

Sr. Data Engineer (Snowflake/dbt)

Posted 14 Days Ago
Be an Early Applicant
Remote
5 Locations
Senior level
Remote
5 Locations
Senior level
The Senior Data Engineer will design and build scalable data pipelines in Snowflake and dbt, optimize performance, and lead technical efforts while mentoring the team.
The summary above was generated by AI

At Sparq, we help companies solve the right problems—not just build more technology.


We’re a modern product engineering partner blending strategy, craftsmanship, and speed to help organizations modernize confidently in the age of AI. From data ecosystems to digital products and AI acceleration, we turn complexity into clarity and ideas into impact.


If you’re driven to build what’s next, lead with empathy, and deliver excellence without ego, you’ll feel right at home at Sparq.


Why You’ll Love This Role:

  • Work with cutting-edge cloud data technologies in a dynamic, collaborative environment
  • Tackle enterprise-scale data challenges, working with billions of rows of data
  • Opportunities for career growth and skill development through mentorship and certification programs
  • Fully remote work flexibility

About the Role:

We are seeking a Senior Data Engineer with expertise in Snowflake and dbt, with a strong focus on scalability and optimization. The ideal candidate has experience working with massive datasets at the enterprise level and can fine-tune and optimize Snowflake environments to enhance performance, cost efficiency, and best practices.

Responsibilities:

  • Design and build scalable data pipelines in Snowflake and dbt, ensuring they can handle billions of rows of data efficiently
  • Optimize Snowflake storage, compute performance, and query execution to improve processing speed and cost efficiency
  • Lead efforts in migrating and refining legacy data processes in Snowflake using dbt, ensuring optimized transformations and modeling
  • Collaborate with business and data teams to understand requirements and translate them into high-performance data solutions
  • Implement best practices for Snowflake optimization, including clustering, partitioning, indexing, materialized views, and workload management
  • Troubleshoot and resolve bottlenecks in existing Snowflake-based ETL/ELT workflows
  • Provide technical leadership and mentorship, ensuring the team follows best practices for scalable data engineering
  • Create and maintain technical documentation, including architecture diagrams and optimization guidelines

What You Bring:

  • 3+ years of experience in data engineering, with a focus on cloud-based enterprise-scale data solutions
  • Proven experience working with massive datasets (billions of rows) in Snowflake
  • Hands-on expertise in Snowflake performance tuning, storage optimization, and cost management
  • Deep experience with dbt for data transformation, testing, and workflow orchestration
  • Strong proficiency in SQL and Python for data manipulation, automation, and optimization
  • Ability to identify, diagnose, and optimize inefficient queries and processing workflows
  • Experience working both with and without an architect to optimize Snowflake performance
  • Strong understanding of data governance, security best practices, and role-based access control in Snowflake
  • Excellent problem-solving and communication skills, with the ability to collaborate across teams

Bonus Points for:

  • Experience with orchestration tools like Airflow or Prefect
  • Exposure to AWS, GCP, or Azure for cloud data integration
  • Familiarity with streaming data pipelines (Kafka, Kinesis, etc.)


Equal Employment Opportunity Policy: Sparq is proud to offer equal employment opportunity without regard to age, color, disability, gender, gender identity, genetic information, marital status, military status, national origin, race, religion, sexual orientation, veteran status, or any other legally protected characteristic.
C2C is not available


#LI-REMOTE

Top Skills

Airflow
AWS
Azure
Dbt
GCP
Prefect
Python
Snowflake
SQL

Similar Jobs

Yesterday
Easy Apply
Remote or Hybrid
12 Locations
Easy Apply
Senior level
Senior level
Marketing Tech • Real Estate • Software • PropTech • SEO
Lead the design and implementation of social media marketing tools, rapid prototyping using AI, and mentoring a small engineering team in a start-up environment.
Top Skills: AWSDynamoDBElasticsearchJavaScriptKafkaKubernetesLangchainLangfuseNode.jsOpenrouterPostgresReactSqsTypescript
2 Days Ago
Easy Apply
Remote or Hybrid
12 Locations
Easy Apply
Senior level
Senior level
Artificial Intelligence • Information Technology • Machine Learning • Natural Language Processing • Productivity • Software • Generative AI
The role involves designing and maintaining a desktop application, monitoring performance, optimizing code, enforcing best practices, and mentoring other frontend engineers.
Top Skills: ElectronGoGCPKotlinPostgresReactSwiftTypescript
5 Days Ago
Remote or Hybrid
119 Locations
Mid level
Mid level
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
The Product Counsel provides legal guidance on product development, compliance, and risk management, working with cross-functional teams while ensuring legal documentation and internal policies are up to date.
Top Skills: AICybersecurityData ProtectionOpen-Source SoftwareSoftware

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account