Senior Data Warehouse Engineer

The Role

We’re looking for an accomplished and well-rounded Senior Data Warehouse Engineer to further our product, marketing, financial, and business insights through the development of our data warehouse. You will work with the existing team and members across the organization to help enable and promote  data driven decision processes. 

Your day-to-day

• Collaborate with cross-functional teams to understand data requirements and design optimal data models and schemas in Snowflake.
• Develop and implement data pipelines, integrating diverse data sources into Snowflake using appropriate ETL/ELT tools and techniques.
• Implement data quality checks and data governance processes to maintain data accuracy, consistency, and compliance.
• Stay up to date with the latest Snowflake features, best practices, and industry trends, and apply them to enhance data solutions and drive innovation.
• Participate in building a highly usable, performant and secure data warehouse. 
• Document technical specifications, data flows, and system configurations for collaborative design and future reference.

About you

• 8+ years experience in software development
• 3+ years experience in data warehouse development
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Experience with Snowflake and DBT with ELT data pipelines 
• Experience with scheduling tools such as Airflow and building extensive data integrations 
• Deep background in data modeling techniques 
• Knowledge and experience with data governance practices
• Extensive experience with SQL and python
• Experience with database management including database design, optimization and performance tuning
• Strong testing and data quality background
• Strong communication skills and are highly collaborative 
• Knowledge of data visualization and reporting tools (e.g., Tableau, Power BI) for building interactive dashboards and reports.
• Experience with streaming data ingestion and processing using tools like Kafka or AWS Kinesis.

Bonus Points

• Extensive CI/CD experience
• Strong familiarity with Kubernetes and Terraform 

Salary: $200,000 - $300,000*

• Important note: all offered salaries are based on many factors, including experience in a similar role and geographic location of the candidate. 

Additional Details: 

• Benefits: We provide a wide variety of health, wellness and other benefits.These include medical, dental, vision, life insurance and supplemental income plans for you and your dependents, a Headspace app subscription, monthly wellness allowance and a 401(k) Plan with a company match.
• Work from Home Equipment: Given our virtual environment— in order to set you up for success at home, a one-time payment of $2K will be provided to cover the purchase of in-home office equipment and furniture at your discretion. Also, our teams work with MacBook Pros, which we will deliver to you fully provisioned prior to your first day.
• Paid Time Off: All employees accrue four weeks of PTO in their first year of employment.  New parents receive twelve weeks of fully paid parental leave which may be taken within one year after the birth and/or adoption of a child. The twelve weeks is applicable to both birthing and non-birthing parent.
• Personal and Professional Development: We’re committed to investing in and helping our people grow personally and professionally.  All employees receive up to $5000 each year for professional learning, continuing education and career development.  All team members also receive Udemy subscriptions and access to multiple different coaching opportunities through BetterUp.
• Location: We are a remote-first company for most positions so you may work from anywhere you like in the U.S, excluding U.S. territories.  Occasional travel may be required for team meetings or company gatherings.  Employees based in the San Francisco Bay Area or in Providence, Rhode Island may commute to one of our local offices as desired.  
• Hours: We maintain core meeting hours from 9AM - 3PM Pacific time for collaborating with team members across all time zones. 

BlueOwl, LLC is an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.  Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

If you are a San Francisco resident, please read the City and County of San Francisco's Fair Chance Ordinance notice.  https://sfgov.org/olse/sites/default/files/FCO poster2020.pdf

This role is employed by BlueOwl, LLC.  BlueOwl, LLC is a separate company in the State Farm family of companies and is the solutions provider for the HiRoad Assurance Company.