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.
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 qualifications are 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/stay current with modern technologies
Solve problems systematically and transparently
Share ideas, solicit/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 like 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.
#LIRemote
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.
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 (which includes pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), 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.