Sr. Data Engineer

Job Summary

ROR Partners is a rapidly growing, client-driven digital marketing and data company. We offer proven marketing solutions to a variety of vertical industries on a nationwide basis. The successful candidate will have demonstrated deep understanding and passion for designing and implementing robust ETL and ELT data pipelines.

What you will do:

• Build, maintain, and administer our Snowflake data warehouse using Data Build Tool (dbt)
• Implement and maintain data pipelines between various operational systems and our data warehouse using Python, Airflow and integration platforms
• Create and maintain documentation of data architecture
• Collaborate with internal and external stakeholders to ensure that data requirements are addressed
• Mentor and lead other data engineering team members and participate in peer design and code reviews
• Ship production-quality features independently
• Work efficiently and productively in a remote-first work environment
• Communicate and collaborate effectively, both verbally and in writing
• Learn independently - keep up to date with developments in the field

What we are looking for:

• History of professional experience shipping production quality code independently
• Ability and desire to lead and mentor a team of data engineers
• Expertise with SQL and cloud-based analytical data warehouses 
• Extensive Snowflake and dbt experience required
• Expertise building end-to-end data pipelines using Airflow and dbt (data build tool) or comparable technologies
• Deep understanding of ETL and ELT patterns and best practices
• Strong data modeling skills and familiarity with the Kimball data warehousing methodology
• Experience writing Python code for data processing
• Desire to continually keep up with advancements in data engineering practices
• Experience conducting design and code reviews
• Strong analytical skills and independent learning style
• Experience with git and use of the command line required
• Experience with AWS and CloudFormation, or comparable cloud services and IaC tools preferred
• Experience with Docker and Docker Compose preferred
• Subject matter familiarity with digital marketing and digital activation preferred

Education/Training

• Preferred: BS Degree in Computer Science or related STEM field

Experience

• 5+ years of experience in data science, software engineering or related technical fields.

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, PTO/Holidays
• 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 meeting

Compensation and Benefits

• $140,000 - $170,000 commensurate with experience and other factors such as geographic location
• Health, Dental, Vision, Life, Disability, HSA, FSA and 401K Match with immediate vesting
• Flexible Vacation Time Off, Sick Leave and 11 Paid Holidays
• 100% Remote Work

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.