Senior Data Warehouse Engineer

Bill.com

  • Draper, UT
  • $121,000-145,200 per year
  • Permanent
  • Full-time
  • 23 days ago
Innovate with purposeAt 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 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 USDWhat'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 , , or 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 describes how BILL treats the personal information it receives from applicants.

Bill.com