Senior Data Engineer

Why Great Gray?

At Great Gray Group, we aim to set the standard in the retirement services industry by delivering advanced retirement solutions that combine fiduciary services, robust investment options, innovative technology, and dedicated client service. Our focus is on making decisions clearer, transitions smoother, and enhancing the client experience. We are committed to continuous improvement, striving to better serve our clients, be excellent partners, and earn trust every day.

The Role

Great Gray is seeking a Senior Data Engineer to join our Data Science and AI team. The Senior Data Engineer will be vital in building and maintaining the data infrastructure supporting our Analytics Hub platform. Responsibilities include designing, constructing, and optimizing data pipelines for ingesting, transforming, and delivering critical financial and operational data to facilitate business reporting and analytics across the organization.

Location

This position is based in our Boston, MA office. We support a hybrid work model with 4 days onsite and 1 day remote.

Note: Visa sponsorship or transfer is not available; applicants must be authorized to work in the U.S. without sponsorship.

Responsibilities

1. Design, build, and maintain scalable data pipelines using Databricks, Delta Lake, and other modern technologies.
2. Develop robust ETL processes for data ingestion from custodians, financial systems, and operational applications.
3. Implement medallion architecture (bronze, silver, gold) for data processing and storage.
4. Build and optimize data models for the data warehouse (MS SQL Server) to support analytics and reporting.
5. Create automated data quality checks and monitoring systems to ensure data integrity.
6. Develop and maintain API layers for system integrations.
7. Implement Master Data Management (MDM) solutions for key entities.
8. Build data services for document management, client/advisor portals, and other integrations.
9. Collaborate with stakeholders to translate data requirements into technical solutions.
10. Work with analytics teams to optimize data structures for visualization tools like Power BI.
11. Mentor junior engineers and promote engineering best practices.
12. Perform other duties as assigned.

Qualifications & Experience

1. Bachelor's degree in Computer Science, Information Systems, or related field; Master’s preferred.
2. 5+ years in data engineering with a proven track record.
3. Strong SQL and data modeling skills.
4. Experience with Databricks, Azure Data Factory, or similar tools.
5. Proficiency in Python, PySpark, Scala, or similar languages.
6. Experience with data warehouses and lakes.
7. Knowledge of dimensional modeling and data warehouse design.
8. Experience with data quality frameworks.
9. Familiarity with APIs and integration patterns.
10. Experience with Microsoft Azure cloud platform.
11. Understanding of financial or investment data structures (preferred).
12. Knowledge of Master Data Management concepts.
13. Ability to thrive in a fast-paced, dynamic environment and manage multiple priorities.
14. Comfortable navigating ambiguity and entrepreneurial mindset.
15. Exhibits results-driven, innovative, resilient, and decisive attributes.

Benefits

Our comprehensive benefits include:

1. Be part of an early-stage, high-growth organization.
2. Hybrid work environment.
3. Competitive compensation, 401(k) with match.
4. Lifestyle spending allowance.
5. Medical, Dental, Vision insurance.
6. Employer-paid life and disability insurance.
7. Generous paid time off.

Company Background

Great Gray is a leading independent provider of trustee and administrative services to CITs, managing over $200 billion across 780+ funds, working with top firms like BlackRock, PIMCO, and Franklin Templeton. We focus on innovative retirement planning solutions, including CITs, which offer advantages like efficient administration and cost-effectiveness. Recently acquired by Madison Dearborn Partners, we continue to grow and innovate in the retirement market.

Investor Background

MDP is a Chicago-based private equity firm with over $28 billion raised since 1992, investing across various industry verticals, including financial services and technology.

Equal Employment Opportunity Policy

Great Gray is an Equal Opportunity Employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran status, disability, or other protected factors.