Senior Data Warehouse Engineer

Invoice2go

Invoice2go

draper, ut, usa
Posted on Nov 20, 2024

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.

At BILL, we listen, learn, and lead—fostering collaboration and a drive for continuous growth. We’re committed to building a diverse and inclusive workplace that values each person’s unique skills and experiences. Even if you don’t meet every requirement, 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.

Make your impact within a rapidly growing Fintech Company

  • 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.
  • Apache Airflow: Proficient in building, deploying, and optimizing DAGs in Airflow or similar pipeline orchestration tools.
  • 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.
  • Other 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.

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
$116,800$140,300 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 that values diversity and inclusion. 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].