Senior Data Engineer - SQL & Pipelines (Hybrid NYC)

Cerity Partners LLC; New York (NY); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Health, dental, and vision insurance – day 1

401(k) savings with 4% match

Flexible PTO policy

Parental Leave

Financial assistance for education

Job summary

Cerity Partners LLC in New York City is seeking an experienced Data Engineer to play a key role in maintaining and architecting data pipelines, analytics, and reporting. You will collaborate with various stakeholders to design data models, build data pipelines, and ensure data quality.

The ideal candidate has over 7 years of experience, proficiency in PostgreSQL and Python, and excellent problem-solving skills. This position offers a hybrid work model with a competitive compensation range of $140,000 to $180,000.

Qualifications

• 7+ years of experience as a data engineer.
• 5-10+ years of programming experience.
• Ability to work independently with a geographically distributed team.

Responsibilities

• Design and structure data models and database schemas.
• Create, maintain, and optimize data pipelines.
• Extract, transform, and push data to BI tools.

Skills

PostgreSQL

Python

dbt

Airflow

Git

Advanced SQL

REST APIs

Cloud infrastructure

Financial services data models

Salesforce

PowerBI

Job description

Cerity Partners LLC in New York City is seeking an experienced Data Engineer to play a key role in maintaining and architecting data pipelines, analytics, and reporting. You will collaborate with various stakeholders to design data models, build data pipelines, and ensure data quality.

The ideal candidate has over 7 years of experience, proficiency in PostgreSQL and Python, and excellent problem-solving skills. This position offers a hybrid work model with a competitive compensation range of $140,000 to $180,000.