Data Engineer

Description

Job Summary

ROR is a rapidly growing, client-driven digital marketing and data company. We are seeking an energetic and experienced Data Engineer to take a key role in our Engineering team. In this position, you will collaborate with other team members, product owners, and operations. You should have a deep understanding and a passion for designing and implementing robust ELT data pipelines. This position will be responsible for building and maintaining best-in-class data systems. Must be authorized to work in the United States with no sponsorship and currently live in Boulder Area, Colorado or already planning to relocate as there is no relocation package. 

What you will do

• Develop and maintain data models in dbt (Data Build Tool) within Snowflake, implementing business logic and ensuring alignment with existing architecture and data standards. 

• Design, build, and administer scalable data pipelines and a robust data warehouse to support reporting, analytics, and operational use cases. 

• Collaborate with stakeholders to understand business needs, translate them into data requirements, and ensure data is modeled to support those needs. 

• Perform data analysis to validate assumptions, support decision-making, troubleshoot issues, and identify improvements in data quality and structure. 

• Design and implement dimensional models and develop the semantic layer to support BI tools and self-serve analytics. 

• Manage and contribute to dbt projects, ensuring code quality, proper documentation, and alignment with modular, scalable design patterns. 

• Understand and interpret client data structures, source systems, and business processes to effectively integrate data into the existing architecture. 

• Write clean, production-ready code

• Create and maintain comprehensive documentation of data architecture, models, and pipelines.

• Work collaboratively within a team of data engineers

What we are looking for

• Passion for working with data, solving complex data challenges and optimizing data processes

• Professional experience deploying production-quality code 

• Deep understanding and hands-on experience with SQL and relational databases 

• Strong data modeling skills and familiarity with data warehousing methodologies 

• Experience with Git and the command line is required

• Experience using Python and Python libraries

• Knowledge of the ELT pattern and best practices for scalable data pipelines 

• Experience conducting code reviews and ensuring best practices in coding standards 

• Experience with dbt and Snowflake is a plus 

• Experience with AWS and S3 is a plus 

• Strong desire to stay up to date with advancements in data engineering practices 

• Ability to develop and ship features independently

• Strong desire to work with Data all the time

Education/Training 

Required: Bachelor’s degree in computer science, a related STEM field, or equivalent experience

Experience

• 1–3 years of experience as a Data Engineer, SQL/Relational Database Developer, or in a similar data-focused role

Work Environment/Benefits

• Standard work week - 40 hours; however, employees may be required to work additional time necessary to meet deadlines and complete projects.

• Competitive salary, health and dental insurance, life and disability, 401K, supplemental insurance, FSAs, flexible PTO/Holidays and much more!

Physical Requirements 

• Sitting for extended periods of time

• Dexterity of hands and fingers to operate a computer keyboard, mouse, and other devices and objects

• Ability to sit/stand at a desk and view a computer screen for extended periods of time

• Physically able to participate in training sessions, presentations, and meetings

ROR Partners is an Equal Opportunity Employer. ROR Partners’ policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. ROR Partners also prohibits harassment of applicants and employees based on any of these protected categories.

ROR Partners will provide accommodations to applicants as needed.