Jobs

High-growth companies you’ll love to work for

Principal Data Engineer

ROR Partners

ROR Partners

Data Science
New York, NY, USA
Posted on Friday, June 7, 2024

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. Position is remote and reports to the VP, Engineering. Salary is $185K to $220K and is determined by factors such as location, experience, and expertise.

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

Qualifications

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 (Snowflake required)
  • Expertise building end-to-end data pipelines using Airflow and dbt (data build tool) required
  • Experience with UNIX, shell-scripting required
  • 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 is 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.