Principal Data Engineer (Remote Work Eligible)

Dimensional Fund Advisors; North Carolina; On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Comprehensive benefits

Educational initiatives

Celebrations of history and culture

Job summary

Dimensional Fund Advisors is inviting applications for the position of Principal Data Engineer. This role involves architecting and managing data workflows in a cutting-edge technology environment aimed at enhancing client financial experiences.

The ideal candidate has over 10 years of experience in software development with an emphasis on data engineering. Key qualifications include proficiency with tools like Snowflake and Airflow, strong problem-solving abilities, and a commitment to cybersecurity best practices.

Qualifications

• 10+ years of professional software development experience.
• Expert-level proficiency with Snowflake, dbt, and Airflow.
• Deep hands-on experience with relational and non-relational databases.

Responsibilities

• Architect and oversee the engineering of large-scale data warehouses.
• Design and manage sophisticated data workflows and transformation layers.
• Write and review high-quality, production-ready code.

Skills

Problem-solving

Team collaboration

Software engineering principles

Automation mindset

Education

Bachelor’s degree in a technical field

Tools

Snowflake

dbt

Airflow

Python

JavaScript

Job description

About Dimensional

Dimensional was built around a set of ideas bigger than the firm itself. With a confidence in markets, deep connections to the academic community, and a focus on implementation, we go where the science leads, and continue to pursue new insights, both large and small, that can benefit our clients.

Job Description

The Technology Department at Dimensional leverages the rapidly evolving state of the art to engineer scalable, innovative, and research-driven solutions to improve our client’s financial lives.

Data Engineers at Dimensional participate in the design and development of data solutions across an array of domains from Research and Investments to Sales and Marketing; collaboratively developing MVPs to test their ideas and rapidly iterate with constant feedback from users. Dimensional invests heavily in developer tools, platforms, paradigms and experience enabling teams to provide modern solutions that contribute profoundly to our client’s success.

We are looking for a Principal Data Engineer to join our team and drive company success by helping Dimensional leverage its critical data. The most important qualification is a passion for driving business value through quality data solutions and high enthusiasm for learning new technologies and approaches to solving complex business problems.

You may be a fit for this role if you:

• Are open-minded, curious, and resourceful
• Are passionate about and stay current with modern technologies
• Solve problems systematically and transparently
• Share ideas, solicit and integrate feedback, design and solve collaboratively
• Take a software engineering approach and demonstrate automation and security mindsets

What You Might Work On

As a Principal Data Engineer at Dimensional, you will have the opportunity to understand the users’ needs and solve problems such as database and schema design and engineering, ETL pipelines, APIs, and microservice design and engineering.

Key Responsibilities

• Strategic Architecture: Architect and oversee the engineering of large-scale data warehouses and lakes, specifically utilizing Snowflake for high-concurrency and complex modeling needs.
• Pipeline Orchestration: Design and manage sophisticated data workflows and transformation layers using Airflow and dbt.
• Full-Stack Data Engineering: Write and review high-quality, production-ready code, primarily utilizing Python and JavaScript.
• Data Modeling & Design: Drive the strategy for relational and non-relational database schemas, focusing on performance, scalability, and long-term maintainability.
• Automation & Delivery: Lead the implementation of robust DevOps practices and continuous delivery pipelines to streamline data deployment and operations.
• Security-First Development: Embed cybersecurity best practices into the DNA of the engineering process, ensuring data protection and compliance by design.

Required Qualifications

• 10+ Years of Mastery: Extensive professional software development experience, with a decade-long track record in data modeling, architecture, and warehouse/lake engineering.
• Core Tech Stack: Expert-level proficiency with Snowflake, dbt, and Airflow.
• Language Proficiency: Advanced experience with Python and JavaScript (or equivalent languages).
• Database Expertise: Deep hands-on experience with relational and non-relational databases, including expert-level schema design and optimization.
• Operational Excellence: Strong working knowledge of DevOps tools and CI/CD pipelines to support automated, reliable data workflows.
• Security Expertise: A deep understanding of cybersecurity best practices and a demonstrated ability to integrate them into development activities.
• Foundational Knowledge: Bachelor’s degree in a technical field or equivalent practical experience.

Dimensional offers a variety of programs to help take care of you, your family, and your career, including comprehensive benefits, educational initiatives, and special celebrations of our history, culture, and growth.

Equal Opportunity Employer
It is the policy of the Company to provide equal opportunity for all employees and applicants. The Company recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to actual or perceived race, color, religion, religious practice, creed, sex, sex stereotyping, pregnancy, caregiver status, gender, gender identity, gender expression, transgender identity, national origin, age, mental or physical disability, ancestry, medical condition, marital status, familial status, domestic partnership status, military or veteran status or service, unemployment status, citizenship status or alienage, sexual orientation, status as a victim of domestic violence, status as a victim of stalking, status as a victim of sex offenses, genetic information, political activities or recreational activities, arrest or conviction record, salary history, natural hairstyle or any other status protected by applicable law except as otherwise required or permitted by law or regulation applicable to the Company or its affiliates.