FreshRemote.Work

Principal, Data Engineer

Remote

Job Type Full-time Description

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.


ROR is seeking a Principal Data Engineer to serve as a key data architect and team leader on our data engineering team. The successful candidate will have demonstrated deep understanding and passion for designing and implementing robust ETL and ELT data pipelines.


Why you should join us:

  • $180,000 - $210,000 commensurate with experience
  • Incentive compensation program and equity
  • 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

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 experience with Snowflake, dbt, Unix are 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

  • Required: BS Degree in computer science or related STEM field

Experience

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

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 $190,000 - $210,000 commensurate with experience Apply

Job Profile

Benefits/Perks

100% remote work Flexible Vacation Time Off, Sick Leave, and 11 Paid Holidays Health, Dental, Vision, Life, Disability, HSA, FSA, and 401K Match Incentive compensation program and equity

Skills

Airflow AWS CloudFormation Data Modeling Dbt Docker ELT ETL Git Kimball methodology Python Snowflake SQL UNIX

Tasks
  • Build and administer Snowflake data warehouse
  • Communicate and collaborate effectively
  • Create and maintain data architecture documentation
  • Implement and maintain data pipelines using Python, Airflow, and integration platforms
  • Keep up to date with data engineering practices
  • Mentor and lead data engineering team members
  • Ship production-quality features independently
Experience

8+ years

Education

BS Degree in Computer Science or related STEM field