Director of Data Engineering

Smile Doctors • Full-time • Remote (United States) • 3m ago

The vision of Smile Doctors is our people-first culture which creates an environment of passionate, caring Team Members dedicated to providing fun and encouraging relationships with each other and our patients. Smile Doctors offers every Team Member the opportunity to be a part of something bigger. We focus on the importance of the individual and recognize that each person on our Team has something great to offer. We recognize talents and strengths and take care to nurture those abilities to help our Team Members grow into successful people in their careers, in our organization, and beyond.

Looking for a position that makes you smile?
We’re seeking a Director of Data Engineering to join our growing team.
The Director, Data Engineering is responsible for designing, building, and maintaining large-scale data infrastructure for our Marketing team across a variety of systems to ensure data solutions support growth, strategy analytics, campaign optimization, and patient journey analysis. This position may also be responsible for leading an engineering/analyst team.

How you’ll make us better:

Partner with Marketing stakeholders to understand business questions and define data requirements
Review raw data sources across various systems to map, clean, and prepare datasets for analytics
Reverse engineer stored procedures and ETL processes to document and replicate key business logic
Build and optimize SQL queries, transformations, and stored procedures for performance and accuracy
Develop repeatable, documented processes for creating marketing and business datasets
Build and maintain ETL/ELT pipelines
Profile and validate data to ensure it reflects business realities and can be trusted for strategic decision-making
Deliver ad-hoc investigative data analysis to answer urgent marketing and business questions
Support the ongoing migration to AI platforms while delivering near-term solutions from existing systems
Establish best practices for data engineering, ensuring scalable and maintainable solutions

Your special skills:

Strong analytical and problem-solving skills
Solid written and oral communication skills
Ability to connect technical data work directly to marketing and business KPIs

Prerequisites for success:

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field required
Ten (10) years of SQL development and data engineering experience required; marketing analytics or customer data environments preferred
Two (2) years of experience supervising a data engineering team
Experience working with stored procedures, reverse engineering business logic, and curating disorganized datasets into analytics-ready formats
Experience building and maintaining ETL/ELT data pipelines from multiple, disparate sources
Experience working with stakeholders to understand business needs and translating them into robust, analytics-ready datasets
Expert knowledge of Microsoft SQL Server
Advanced knowledge of raw data analysis, mapping, and transformation
Strong knowledge of one of the following cloud environments with a focus on data engineering activities; Azure, GCP, or AWS
Strong knowledge of data modeling and data architecture concepts
Strong knowledge of reverse engineering existing code and processes

We saved the best for last.
In exchange for the dynamic contribution you’ll bring to our team, we offer:

Competitive salary
Medical, dental, vision and life insurance
Short and long-term disability coverage
401(k) plan
3 weeks paid time off in your first year + paid holidays
Discounts on braces and clear aligners for you and your family members

Why Smile Doctors?
As the nation’s leading Orthodontic Support Organization, Smile Doctors is shaping the future of orthodontics through strategic partnerships with top local doctors. We provide best-in-class support services so our partner orthodontists can focus on what they do best — driving extraordinary treatment outcomes and providing patients with an unmatched experience.

With hundreds of partnered practices across the nation, our synergistic approach has made us the fastest-growing organization in our industry and produced an ever-expanding need for top talent as we continue our unprecedented trajectory. To us, there’s no such thing as “top of our game.” We’re always climbing higher — together. And as our business grows, there’s plenty of room for our team to grow their careers, too.

Our dynamic support services team is comprised of world-class professionals whose diverse experiences drive innovation and development. Together, we are committed to passionately helping others achieve their best, most confident smiles.

This is the perfect opportunity to grow with an expanding organization! Apply today!

Smile Doctors and all our affiliating practices are proud to be an equal opportunity workplace and welcome diversity in our organization. We do not discriminate against any team member or applicant for employment regardless of age, race, color, national origin, religion, disability, veteran status, sex, sexual orientation, or gender identity.