Sparq Logo

Sparq

Sr. Data Engineer (Snowflake/dbt)

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

18 Days Ago
In-Office or Remote
9 Locations
Entry level
Entry level
Machine Learning • Natural Language Processing
Join Welo Data to assist in AI projects, contributing to language data quality through annotation and evaluation while working remotely.
Top Skills: Ai ToolsDigital Tools
An Hour Ago
In-Office or Remote
2 Locations
87K-130K Annually
Mid level
87K-130K Annually
Mid level
Healthtech • Biotech
Deliver onsite and virtual education on Siemens MRI systems, develop training plans, assess customer needs, and improve training effectiveness.
Top Skills: Instructional SoftwareMicrosoft Office SuiteSiemens Mri Systems
An Hour Ago
In-Office or Remote
2 Locations
87K-130K Annually
Mid level
87K-130K Annually
Mid level
Healthtech • Biotech
Deliver onsite and virtual education on Siemens MRI systems, evaluate customer training needs, develop materials, and ensure customer satisfaction through effective training delivery.
Top Skills: Instructional SoftwareMicrosoft Office SuiteMri Imaging Systems

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account