Data Engineer

Full-time

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 Superior, Colorado area or already planning to relocate as there is no relocation package.

What you will do

• You will spend 90% of your time writing SQL code and dbt models (Data Build Tool) and working with data with some data analysis in support of dbt models.
• 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

Education / Training

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

Experience

Work Environment / Benefits

Physical Requirements

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.

Salary Description

$70,000 - $110,000