Snowflake Data Engineer

Insight Global; Titusville (NJ); Remote; USD 125,000 - 175,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

HSA/FSA

401k with company match

Paid time off

Job summary

Insight Global is seeking a Remote Data Engineer to support a large pharmaceutical client. The role focuses on building and optimizing data pipelines using dbt, Airflow, Python/SQL, and Snowflake in an AWS environment.

The candidate should have 5+ years of enterprise data engineering experience and contribute to identifying, structuring, and leveraging large data sets for business decisions. Benefits include medical/dental/vision, HSA/FSA, 401k with company matching, and paid time off.

Qualifications

• 5+ years of experience as a Data Engineer in an enterprise environment.
• Dbt transformations using SQL for layering and structuring.
• Apache Airflow for scheduling and orchestrations.
• AWS environment experience standing up and utilizing services.
• Snowflake data warehousing.
• Python/SQL pipeline development.

Responsibilities

• Build and manage dbt transformations and data pipelines.
• Schedule and orchestrate pipelines using Apache Airflow.
• Develop and optimize Python/SQL data processing tasks.
• Leverage Snowflake for data warehousing and performance optimization.

Skills

Data engineering

Python/SQL

Airflow

Snowflake

AWS

Tools

dbt

Apache Airflow

Snowflake

AWS

Job description

Job Description

Insight Global is currently seeking a Remote Data Engineer for a large pharmaceutical client. This person will be joining a team supporting and building out a data environment supporting large business initiatives around improving the identification, structuring, and usage of large data sets to drive business decisions. This person will be responsible for building and managing dbt transformations, orchestrations and scheduling using Apache Airflow, and standard data engineering using Python/SQL/AWS for build and optimization of data pipelines. This person will also be responsible for leveraging Snowflake for data warehousing and optimizations. This person should be a senior level data engineering resource. Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

Skills and Requirements

• 5+ years of experience as a Data Engineer in an enterprise environment

• Dbt transformations using SQL for layering and structuring

• Apache Airflow for scheduling and orchestrations

• AWS environment experience standing up and utilizing services

• Snowflake data warehousing

• Python/SQL pipeline development

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].