Senior Data Warehouse Engineer

AI overview

Contribute to innovative data solutions by building robust data pipelines and collaborating on modern data platform migrations to enhance data reliability and efficiency.

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 visa sponsorship. Applicants must have authorization to work in the United States without requiring visa sponsorship now or in the future.

The estimated salary  range for this role is noted below for our San Jose based role.  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.

San Jose pay range
$142,300$170,800 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 [email protected].

Our Applicant Privacy Notice describes how BILL treats the personal information it receives from applicants.

Perks & Benefits Extracted with AI

  • Health Insurance: 100% paid employee health, dental, and vision plans (choose HMO, PPO, or HDHP)
  • Employee recognition and referral programs: Employee recognition and referral programs
  • Paid Time Off: 11+ Observed holidays and wellness days and flexible time off

BILL is a leader in financial automation software for small and midsize businesses (SMBs). As a champion of SMBs, we are dedicated to automating the future of finance so businesses can thrive. Hundreds of thousands of businesses trust BILL solutions to manage financial workflows, including payables, receivables, and spend and expense management. With BILL, businesses are connected to a network of millions of members, so they can pay or get paid faster. Through our automated solutions, we help SMBs simplify and control their finances, so they can confidently manage their businesses, and succeed on their terms.  BILL is a trusted partner of leading U.S. financial institutions, accounting firms, and accounting software providers. We have operations in San Jose, CA and  Draper, UT and are continuing to expand into other geographic locations. If you’re looking for a place that helps you do the best work of your career, look no further than BILL.    Our promise to our candidates is to be transparent, diligent, and engaging while guiding individuals through each step of our hiring process. At BILL we strive to achieve an inclusive and positive candidate experience that aligns with our core values and focuses on diversity.    If you require a reasonable accommodation for your application, interviews, or another aspect of the hiring process, please contact [email protected].   For positions that are in office we support a hybrid work environment with on-site and remote work days.  Check out our culture, benefits, and teams on our career site, LinkedIn Life, or YouTube pages.

View all jobs
Salary
$142,300 – $170,800 per year
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Engineer Q&A's
Report this job

This job is no longer available