Data Engineer at ROR Partners Inc

Superior, Colorado, United States -

Full Time

Start Date

Immediate

Expiry Date

02 Jun, 26

Salary

100000.0

Posted On

04 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, dbt, Data Modeling, ELT, Snowflake, Data Warehousing, Python, Git, Command Line, Data Pipelines, Dimensional Models, Semantic Layer, Code Reviews, AWS, S3, Data Analysis

Industry

Advertising Services

Description

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 and currently live in Superior, Colorado area or already planning to relocate to that area. 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 • 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 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 • Experience with AWS and S3 is helpful • 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 is REQUIRED Education/Training Required: Bachelor’s degree in computer science, a related STEM field, or equivalent experience Please note: Upon successful completion of the initial interview stage, candidates will be required to provide official transcripts for verification purposes. Experience • 1–4 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.

Responsibilities

The Data Engineer will spend 90% of their time writing SQL code and dbt models, focusing on developing and maintaining robust ELT data pipelines and best-in-class data systems within Snowflake. Responsibilities also include designing scalable data warehouses, implementing business logic in dbt models, and collaborating with stakeholders to meet data requirements.