Senior Data Warehouse Engineer

  • Draper, UT
  • Posted 60+ days ago | Updated 10 hours ago

Overview

On Site
USD 121,000.00 - 145,200.00 per year
Full Time

Skills

Startups
Finance
Usability
Facilitation
Data Flow
Optimization
Migration
Business Analytics
Business Analysis
Computer Science
Information Systems
Mathematics
Data Architecture
Database Administration
Data Warehouse
Snow Flake Schema
Amazon Redshift
Financial Services
SaaS
Industry-specific
Regulatory Compliance
Scripting
Python
Data Manipulation
Object-Oriented Programming
SQL
Performance Tuning
Workflow
Data Modeling
Normalization
Analytical Skill
Database
Extract
Transform
Load
ELT
Streaming
Data Processing
Version Control
GitHub
GitLab
Data Visualization
Tableau
Collaboration
Communication
Documentation
DevOps
Unit Testing
Continuous Integration
Continuous Delivery
Management
Docker
Cloud Computing
Amazon Web Services
Prompt Engineering
Authorization
Insurance
MAGIC
HMO
PPO
FSA
Life Insurance
LinkedIn
YouTube
Recruiting
Privacy

Job Details

Innovate with purpose

At BILL, we believe in empowering the businesses that drive our economy. By replacing outdated financial processes with innovative tools, we help businesses-from startups to established brands-make smarter decisions and gain control of their operations. And we don't stop there: we're creating the future of financial automation so businesses can spend more time on what matters.

Working here means you become part of a vision-driven team that's ready to tackle challenges and build cutting-edge solutions. We value purpose, drive, and curiosity-and we thrive in a fast-paced, ever-changing environment. Whether in one of our offices in San Jose, CA, Draper, UT, or working remotely, BILLders collaborate to deliver real impact for businesses that need more time in their busy weeks.

BILL builds high performing teams and we seek to hire the best talent for every role. We're committed to building a workplace that fosters inclusion and diverse perspectives, valuing each person's unique skills and experiences. We'd love to hear from you-you might be just what we're looking for, whether in this role or another.
Let's give businesses more time for what matters.

At BILL, the Data Operations team is central to building capabilities and best practices that enhance the usability of data across the company. We engage with stakeholders to understand their data needs, collect requirements, develop tailored solutions, deploy these solutions to our data ecosystem, and showcase the impactful results. Our engineers bring a sense of pragmatic perfectionism to their work, striving for excellence every day and delivering quality data products that our stakeholders rely on.

Responsibilities:
  • Build and manage robust data pipelines that support scalable and efficient operations across various data platforms.
  • Work closely with different teams to translate business requirements into sustainable technical solutions, facilitating effective data usage and integration
  • Participate in designing, implementing, and refining data models and database schemas to effectively support business functionalities and operations.
  • Collaborate on migration projects to modern data platforms like Trino, using Iceberg as the table format, and enhance data flow and architecture to improve data reliability, efficiency, and quality.
  • Engage in continuous optimization of data models and pipelines, contributing to infrastructure migrations and improvements in CI processes and Airflow orchestrations.
  • Develop reusable classes, components, and modular scripts to automate and enhance daily tasks and workflows, thereby improving efficiency for both stakeholders and team operations.

We'd love to chat if you have:
  • BS/BA in Computer Science, Information Systems, Mathematics, or a related technical field, or equivalent practical experience.
  • At least 3 years of experience in data warehousing roles, demonstrating expertise in large-scale data architecture design, implementation, and maintenance.
  • Proficient in advanced SQL and familiar with database management practices, including experience with cloud data warehouses like Snowflake, Redshift, or similar platforms.
  • A plus would be experience working in financial services and/or SaaS companies, with a strong understanding of industry-specific data requirements and compliance issues.

Technical experience we'd love to see:
  • Python: Must be adept at scripting in Python for data manipulation and integration tasks, with experience in Object-Oriented Programming (OOP).
  • SQL, dbt, and Data Modeling
    • Must be adept with advanced SQL techniques for querying, data transformation, and performance optimization.
    • Familiarity with dbt (data build tool) for managing data transformation workflow.
    • Must have a strong understanding of data modeling best practices, expertise in normalization and denormalization techniques to optimize analytical queries and database performance.
  • ETL/ELT Processes: Extensive experience in designing, building, and optimizing ETL/ELT data pipelines, including both batch and streaming data processing.
  • Version Control: Heavy experience with version control, branching, and collaboration on GitHub/Gitlab.
  • Data Visualization: Familiarity or interacted with Tableau or similar tools
  • Collaboration and Communication: Excellent documentation skills and the ability to work closely with diverse teams to translate business requirements into technical solutions.
  • DevOps Practices: Knowledge of unit testing, CI/CD, and repository management.
  • Technologies: Familiarity with Docker and cloud technologies such as AWS.
  • Prompt Engineering for LLMs: Experience with crafting and refining prompts for LLMs like GPT is a plus.

Visa Sponsorship: Please note that this position is not eligible for have authorization to work in the United States without requiring visa sponsorship now or in the future.

The estimated base salary range for this role is noted below for our office location in Draper, UT. Additionally, this role is eligible to participate in BILL's bonus and equity plan. Our ranges for each role and job level are based on a variety of factors including candidate experience, expertise, and geographic location and may vary from the amounts listed above. The role is also eligible for a competitive benefits package that includes: medical, dental, vision, life and disability insurance, 401(k) retirement plan, flexible spending & health savings account, paid holidays, paid time off, and other company benefits.

Draper UT pay range

$121,000-$145,200 USD

What's in it for you?

Redefining how businesses automate their work is a fast-paced, exciting, and fun environment. But we also have benefits and perks to ensure the magic isn't only experienced by our customers, but by our employees as well.

Here is a preview of some of the amazing benefits here at BILL:

  • 100% paid employee health, dental, and vision plans (choose HMO, PPO, or HDHP)
  • HSA & FSA accounts
  • Life Insurance, Long & Short-term disability coverage
  • Employee Assistance Program (EAP)
  • 11+ Observed holidays and wellness days and flexible time off
  • Employee Stock Purchase Program with employee discounts
  • Wellness & Fitness initiatives
  • Employee recognition and referral programs
  • And much more

Don't believe us? Check out our culture, benefits, and teams on our career site, LinkedIn Life, or YouTube pages.

BILL is an Equal Opportunity Employer. We believe our best ideas come from the unique stories, perspectives, and experiences of our team members. We welcome people of all backgrounds, abilities, and identities to bring their authentic selves and contribute to our culture.

We are committed to a transparent, inclusive hiring process that reflects our values. If you need accommodations at any stage, please contact

Our Applicant Privacy Notice describes how BILL treats the personal information it receives from applicants.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.