fb_pixel
back
Back
Location:
Rosemont, United States
Department: Information Technology
Job Description

Snowflake Lead Data Engineer (Contract)

Rosemont, IL, United States (On-site)
Contract (5 months 25 days)
Published 4 days ago
CI/CD
data engineering
SQL

Data Engineer with deep expertise in DBT (Data Build Tool), Snowflake, and PL/SQL to join our growing data team. Person will be responsible for designing, developing, and maintaining robust data transformation pipelines that support business intelligence, analytics, and data science initiatives.


Key Responsibilities:

  • Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
  • Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
  • Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
  • Optimize Snowflake performance through query tuning, clustering, and resource management.
  • Ensure data quality, integrity, and governance through testing, documentation, and monitoring.
  • Participate in code reviews, architecture discussions, and continuous improvement initiatives.
  • Maintain and enhance CI/CD pipelines for DBT projects.


Required Qualifications:

  • (3+ years for India and 8+ years for US) experience in data engineering or a related field.
  • Strong hands-on experience with DBT (modular SQL development, testing, documentation).
  • Proficiency in Snowflake (data warehousing, performance tuning, security).
  • Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages.
  • Solid understanding of data modeling concepts (star/snowflake schemas, normalization).
  • Experience with version control systems (e.g., Git) and CI/CD practices.
  • Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plus.


The pay range that the employer in good faith reasonably expects to pay for this position is $42.76/hour - $66.82/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.



Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.


Job Id: 20kbvTRYi86NMqZGwQ6ZUa1R72H78wLzRhVoBq1xwviebzm6yfYxYFTaq0fBS/weRmaOCksnR1tGwH+/r2nsA9F1Yhiq7zGbyZoJZZdN2V9eQ9sensRC5O/5abZlEKgaQ25+zBY6spJC9ZE=
companyLogo
Capgemini
Snowflake Lead Data Engineer