ROR is seeking an energetic and experienced Data Engineer to take a key role in their Engineering team to design and implement robust ELT data pipelines and build and maintain best-in-class data systems.
Requirements
- Deep understanding and hands-on experience with SQL and relational databases are REQUIRED.
- Strong data modeling skills and familiarity with data warehousing methodologies are REQUIRED.
- Prior experience with Git and the command line is required
- Experience using Python and Python libraries is a plus
- 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 highly desired
Responsibilities
- 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.
- 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
Other
- Must be authorized to work in the United States and currently live in Superior, Colorado area or already planning to relocate to that area.
- Collaborate with stakeholders to understand business needs, translate them into data requirements, and ensure data is modeled to support those needs.
- Work collaboratively within a team of data engineers
- Required: Bachelor’s degree in computer science, a related STEM field, or equivalent experience
- 1–4 years of experience as a Data Engineer, SQL/Relational Database Developer, or in a similar data-focused role
