Data Engineer

Cerity Partners Management LLC; United States; On-site; USD 140,000 - 180,000; Full time

Job summary

Cerity Partners Management LLC is seeking an experienced data engineer to lead the development and maintenance of data pipelines, analytics, and reporting. The ideal candidate will bring at least 7 years of data engineering experience with proficiency in SQL, PostgreSQL, Python, and cloud infrastructure.

This role offers a competitive compensation range of $140,000 to $180,000, with a focus on collaboration and data governance. Join a diverse team dedicated to delivering high-quality data solutions!

Qualifications

• 7+ years of experience as a data engineer.
• 5-10+ years of programming experience.
• Experience with PostgreSQL, Python, dbt, and Airflow.

Responsibilities

• Design and structure data models and database schemas.
• Create and optimize data pipelines.
• Extract and transform data for BI tools.
• Maintain database infrastructure for performance.

Skills

PostgreSQL

Python

dbt

Airflow

Git

Advanced SQL

REST APIs

Cloud infrastructure

Financial services data models

CRM experience (Salesforce)

PowerBI

Job description

Position Summary

We are looking for someone whose mindset is about data models and who speaks fluent SQL to join our data team. As a data engineer at Cerity Partners you will play a leading role maintaining the current and architecting the future state of our data pipelines, analytics, and reporting.

Primary Responsibilities

• Design Data Models: Structure data and create database schemas that capture data as it exists and as it relates to other data.
• Build Data Pipelines: Create, maintain, and optimize data pipelines and data sets.
• Data Integration: Extract, transform, and push data to other systems and BI tools.
• Database Management: Help build our database infrastructure and maintain it so that the organization’s data remains available and our systems performant.
• Optimization: Identify and replace data models and queries that lead to performance issues and fix issues with systems and data that lead to downtime or unexpected behavior.
• Collaboration: Work with other stakeholders to develop and deliver the data they need to be successful.
• Data Governance: Proactively identify data that is sensitive and take steps to address its storage and usage.
• Data Quality: Build internal tooling and reporting to identify bad data, and gaps in data, so that end users can work with the data without worry.

Required Qualifications

• 7+ years of experience as a data engineer
• 5-10+ years of programming experience
• PostgreSQL, Python, dbt, Airflow, Git, advanced SQL
• REST APIs (GraphQL a plus)
• Cloud infrastructure expertise (particularly around managed databases)
• Multiple years of experience with financial services data models (wealth management preferred)
• CRM experience (Salesforce preferred)
• PowerBI experience useful
• Ability to work independently with a geographically distributed team
• Acute attention to detail, love of problem solving and being challenged
• Willingness to try new things
• Strong communication skills

Compensation Range

$140,000-180,000

Equal Opportunity Employer

We are an Equal Opportunity Employer who respects each individual and supports the diverse cultures, perspectives, and experiences of our colleagues. We are dedicated to building an inclusive and diverse workforce and will not discriminate based on race, religion, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law. Cerity Partners is committed to working with and providing accommodations to applicants with disabilities or special needs. For those needing accommodations, please reach out to [e-mail].