← Back to All Jobs

Data Warehouse Engineer



Job Description

Sr Cloud Data Warehouse Engineers needed Full-time Remote


Global wellness technology company inspiring millions of people to adopt healthy habits for real life. We do this through engaging digital experiences, face-to-face workshops, and sustainable programs that encourage people to move more, shift their mindset, and eat healthier while enjoying the foods they love. By drawing on over five decades of experience and expertise in behavioral science, we build communities in order to deliver wellness for all.

Role Overview:

We're looking for experienced Cloud Data Warehouse Developers who can work across the organization from the product, and engineering org to analytics to data scientists to business heads delivering accurate, timely, actionable information. The ideal candidate will have experience with cloud data warehouses, a high-level programming language such as python, a fundamental understanding of data modeling and software development process, experience monitoring and maintenance of business-critical production pipelines using tools such as Airflow, grafana as well as experience with bringing data to life using tools such as Looker.


Key Responsibilities:


·        Collaborate with cross-functional teams to make data actionable

·        Work closely with business users, product managers, analysts, and data scientists to build out both analytics schema as well as star schema layer for fast and accurate data analysis 

·        Design high-performance, resilient, efficient data pipelines using ELT

·        Become a subject matter expert in the data layer with a deep understanding of the entire pipeline 

·        Responsible for end-to-end project ownership

·        Play a key role in data architecture and design discussions 

·        Designing analytics-friendly data sets that abstract complex business and transformation logic

·        Developing reusable, testable code 

·        Responsible for accuracy and recency of data and meeting data team SLAs 

·        Communicating with stakeholders to achieve project objectives

·        Responsible for training and mentoring other developers

·        Responsible for building out dashboards as well as being willing to train end-users on self-serve methods for exploring data 

·        Keeping up to date with best practice


Requirements:


·        5+ years of experience in data of all types with at least 2 years in leveraging distributed cloud-based data warehouse technologies for large-scale complex problems 

·        Expertise in building and scaling modularized ELT pipelines 

·        Migration experience in Snowflake

·        Expert knowledge in SQL and data warehousing techniques 

·        Past experience with bringing data to life, using visualization

·        Production experience with high-level languages, ideally Python 

·        Experience with Airflow or other workflow tools 

·        Proven track record for keeping SLAs on production data pipelines

·        Experience with cloud services and serverless is a plus

·        BS or MS in Computer Science, Information Systems or equivalent 


Competitive base salaries, excellent bonus & top flight benefits. If interested in an immediate interview send your resume and salary expectations to: jim@ingenium.agency 




Apply for this job

What You Should Know