Principal Data Engineer

Job Summary

Key Deliverables and Responsibilities:

• Serve as a hands-on technical leader for designing, building, and optimizing Cambridge's modern data platform.
• Define data architecture standards and lead engineering efforts.
• Mentor team members and drive scalable data solutions supporting enterprise analytics and business initiatives.
• Design, develop, and maintain scalable data pipelines for enterprise reporting, analytics, and business applications.
• Build and optimize ETL/ELT solutions using modern cloud-based technologies.
• Develop and maintain datasets within Snowflake and Azure Data Lake Storage (ADLS) environments.
• Lead data platform architecture initiatives, including data modeling, ingestion, transformation, storage, and consumption patterns.
• Drive performance tuning and cost optimization efforts across cloud data platforms and processing workloads.
• Establish engineering best practices, code reviews, and architectural standards.
• Partner with analytics, product, and business stakeholders to deliver scalable, high-quality data solutions.

What We Are Looking For

• 8+ years of experience in data engineering, data architecture, or related technical roles.
• Strong hands-on experience with: Snowflake (SQL), Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Functions, Data Pipeline Development, ETL / ELT Design and Implementation, Performance Tuning, Cloud Cost Optimization, Python, Strong SQL development and data modeling expertise, Experience designing scalable data integration and analytics solutions in Azure, Knowledge of modern data architecture patterns and best practices.
• Preferred Qualifications: Experience with Bronze/Silver/Gold (Medallion) architecture patterns, Experience with Change Data Capture (CDC) and streaming platforms, Experience with data governance, lineage, and metadata management, Knowledge of financial services, wealth management, or highly regulated industries.

Location

Phoenix, AZ, or Fairfield, IA – Hybrid in-office 3 days/week

Why Cambridge?

• Competitive benefits and promotes a work/life balance to encourage individual success.
• Premium benefit package including medical, vision, dental, life and long-term disability insurance.
• Vacation/sick time.
• 401K retirement plan with company matching program.
• Eleven paid holidays.

Company Overview

At Cambridge, our purpose is simple: to make a difference in the lives of our financial advisors, their clients, and our associates. Founded in 1981, we have 45 years of experience supporting independent financial advisors with industry-leading tools, compliance, and transition services. Guided by our core values—integrity, commitment, flexibility, and kindness—we put financial advisors first in every decision we make. Cambridge is an internally controlled, growth-focused independent broker-dealer, ranked among the largest and fastest-growing firms in the industry. With home offices in Fairfield, Iowa, and Phoenix, Arizona, and a nationwide reach, our 900 associates maintain a 4:1 advisor-to-associate ratio to ensure personalized service. Our community of over 4,000 producing financial advisors includes diverse business models—RIA, corporate RIA, hybrid, fee-only, and brokerage—and offers a broad selection of investment solutions with no proprietary products. For further information about Cambridge, please visit https://www.joincambridge.com/.