Capgemini-posted 4 months ago
Full-time • Mid Level
New York, NY
5,001-10,000 employees

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.

  • 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.
  • 3+ years of 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.
  • Flexible work
  • Healthcare including dental, vision, mental health, and well-being programs
  • Financial well-being programs such as 401(k) and Employee Share Ownership Plan
  • Paid time off and paid holidays
  • Paid parental leave
  • Family building benefits like adoption assistance, surrogacy, and cryopreservation
  • Social well-being benefits like subsidized back-up child/elder care and tutoring
  • Mentoring, coaching and learning programs
  • Employee Resource Groups
  • Disaster Relief
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service