Cambridge Investment Research

Principal Data Engineer

Cambridge Investment Research$120K — $150K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience in data engineering or data architecture.
  • Proficiency in Snowflake (SQL), Azure Data Factory (ADF), and Azure Data Lake Storage (ADLS).
  • Hands-on experience with data pipeline development and ETL/ELT processes.
  • Strong SQL development and data modeling skills.
  • Knowledge of cloud cost optimization and performance tuning.

Responsibilities

  • Design, develop, and maintain scalable data pipelines for enterprise applications.
  • Build and optimize ETL/ELT solutions using cloud technologies.
  • Implement data integration solutions with Azure services.
  • Develop datasets in Snowflake and Azure Data Lake Storage.
  • Lead architectural initiatives for data modeling and processing.
  • Drive performance tuning and cost reduction across cloud data platforms.
  • Establish engineering best practices and mentor data engineers.

Benefits

  • Premium medical, vision, dental, life, and long-term disability insurance.
  • Vacation and sick time.
  • 401K with company matching.
  • Eleven paid holidays.
Full Job Description
Job Summary

Key Deliverables and Responsibilities

As a Principal Data Engineer, you will serve as a hands-on technical leader responsible for designing, building, and optimizing Cambridge's modern data platform. You'll help define data architecture standards, lead engineering efforts, mentor team members, and drive scalable data solutions that support enterprise analytics and business initiatives.

Key Responsibilities
  • Design, develop, and maintain scalable data pipelines supporting enterprise reporting, analytics, and business applications.
  • Build and optimize ETL/ELT solutions using modern cloud-based technologies.
  • Design and implement data integration solutions utilizing Azure Data Factory (ADF), Azure Functions, and other Azure services.
  • 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.
  • Design secure, reliable data movement solutions using batch and streaming integration patterns.
  • Establish engineering best practices, code reviews, and architectural standards.
  • Mentor data engineers and provide technical leadership across projects.
  • 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

Cambridge has 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

You can find more details about our comprehensive benefits package here.

About Cambridge Investment Research

Cambridge Investment Research is a privately owned financial services firm that provides a wide range of services to independent financial advisors and their clients. The company was founded in 1981 and is headquartered in Fairfield, Iowa. Cambridge Investment Research offers a variety of products and services, including investment advisory services, brokerage services, and insurance products. The company is committed to providing independent financial advisors with the tools and resources they need to help their clients achieve their financial goals. Cambridge Investment Research has been recognized as one of the top independent broker-dealers in the United States.
Learn more about Cambridge Investment Research
Size
1,000 employees
Industry

Similar Jobs

More Jobs at Cambridge Investment Research

  • Cambridge Investment Research
    SQL Database Engineer
    $80K — $110K *
    Fairfield, IA 52556 (Jefferson County)
    Information Technology
    In-Person
  • Cambridge Investment Research
    SQL Database Engineer
    $85K — $110K *
    West Des Moines, IA 50265 (Polk County)
    Information Technology
    In-Person
  • Cambridge Investment Research
    Salesforce Developer
    $90K — $120K *
    West Des Moines, IA 50265 (Polk County)
    Enterprise Technology
    In-Person
  • Cambridge Investment Research
    Salesforce Developer
    $80K — $110K *
    Fairfield, IA 52556 (Jefferson County)
    Information Technology
    In-Person
  • Cambridge Investment Research
    Salesforce Developer
    $90K — $120K *
    Phoenix, AZ 85032 (Maricopa County)
    Information Technology
    Hybrid

More Information Technology Jobs

Find similar Principal Data Engineer jobs: