Senior Data Engineer

Why Great Gray?

At Great Gray Group, we strive to set the bar for the retirement services industry. Our goal is to deliver advanced retirement solutions that combine our core fiduciary services with robust investment options, innovative technology, and dedicated client service. We focus on making choices clearer, transitions smoother, and the client experience more delightful. Complacency isn't in our vocabulary. Every day, we look for opportunities to better serve our clients, be an excellent business partner, and earn the trust of those who rely on us.

The Role

Great Gray is looking to add a Senior Data Engineer on our Data Science and AI teamAs a Senior Data Engineer, you will play a crucial role in building and maintaining the data infrastructure that powers our Analytics Hub platform. You will design, build, and optimize data pipelines that ingest, transform, and deliver critical financial and operational data to support business reporting and analytics capabilities across the organization.

Location

This position will work from our Boston, MA office. Great Gray currently supports a hybrid work model with 4 days onsite, and 1 day remote.

Visa sponsorship or transfer of an existing visa is not available for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship or transfer.

Responsibilities

• Design, build, and maintain scalable data pipelines using Databricks, Delta Lake, and other modern data technologies

• Develop robust ETL processes to ingest data from multiple sources including custodians, financial systems, and operational applications

• Implement the medallion architecture (bronze, silver, gold) for data processing and storage

• Build and optimize data models for the data warehouse (MS SQL Server) to support analytics and reporting needs

• Develop automated data quality checks and monitoring systems to ensure data integrity

• Create and maintain API layers for integrating with internal and external systems

• Implement Master Data Management (MDM) solutions for funds, plans, and other key entities

• Build data services to support document management, client/advisor portal, and other integration needs

• Collaborate with business stakeholders to understand data requirements and translate them into technical solutions

• Work with the analytics team to optimize data structures for reporting and data visualization tools like Power BI

• Mentor junior engineers and establish engineering best practices

• Complete other related duties as assigned

Qualifications & Experience

• Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred

• 5+ years of experience in data engineering roles with proven track record of building data platforms

• Strong expertise in SQL and data modeling techniques

• Experience with Databricks, Azure Data Factory, or similar modern data engineering tools

• Proficiency in Python, PySpark, Scala, or similar programming languages for data processing

• Experience with building and maintaining data warehouses and data lakes

• Knowledge of dimensional modeling and data warehouse design principles

• Experience with implementing data quality frameworks and processes

• Familiarity with APIs and data integration patterns

• Experience with cloud platforms, particularly Microsoft Azure

• Understanding of financial or investment data structures preferred

• Experience with Master Data Management concepts and implementation

• Ability to thrive in a fast-paced, dynamic environment and manage multiple priorities effectively.

• Comfortable navigating ambiguity.

• Entrepreneurial mindset to bring best practice ideas to the team.

• Exhibits our Great Gray attributes: Results-Driven, Innovative, Resilient, and Decisive.

Benefits

We have a comprehensive and competitive benefits package at Great Gray. Some of the highlights are:

• Be an integral part of an early-stage, high-growth organization.

• Hybrid work environment

• Competitive compensation package including 401(k) with elective and non-elective match opportunities

• Lifestyle spending allowance program

• Medical, Dental, Vision Insurance

• Employer-paid life and disability insurance

• Generous paid time off program

Company Background

Great Gray is the leading independent provider of trustee and administrative services to Collective Investment Trusts ("CITs"), with over $200 billion in CIT assets under management, across more than 780 funds. We proudly work with 80 subadvisors, including leading firms such as AllianceBernstein, American Funds, BlackRock, Franklin Templeton, MetLife, Neuberger Berman, PGIM, PIMCO and Raymond James.

CITs are more than just an investment vehicle. They represent a forward-thinking approach to retirement planning. These tax-exempt, pooled investment vehicles are offered to employer-sponsored retirement plans, like 401(k)s. CITs are comparable to mutual funds, but, because they are tailored for the institutional retirement market, they can offer distinct advantages, including efficient administration and cost-effectiveness. CITs have a history dating back over 90 years; but they have gained favor over the past decade, driven by innovations, and Great Gray has been at the forefront.

Great Gray has consistently delivered year-over-year growth at an above market rate and is investing in the continued development of its core CIT business as well as complementary administrative services and technology solutions for the retirement market.

Madison Dearborn Partners ("MDP") purchased Great Gray from Wilmington Trust in April 2023. As a result, Great Gray is an independent company owned by funds affiliated with MDP.

Investor Background

MDP is a leading private equity investment firm based in Chicago. Since MDP's formation in 1992, the firm has raised aggregate capital of over $28 billion and has completed over 150 platform investments. MDP invests across five dedicated industry verticals, including basic industries; business and government software and services; financial and transaction services; health care; and telecom, media, and technology services.

Equal Employment Opportunity Policy

Great Gray, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, disability status or other non-merit factor.