We are seeking a talented and detail-oriented Business Intelligence (BI) Engineer with experience in financial and revenue reporting to join our dynamic team. In this role, you will design, develop, and maintain scalable data solutions, enabling the finance team to make data-driven decisions. You will leverage your experience with PostgreSQL, Fivetran, dbt (data build tool), Looker, and other modern data tools to build and optimize our data infrastructure and reporting processes.
Getting started
- We want you to feel like part of the team early on! Our onboarding process will integrate you into the company with informative sessions on our product, policies, processes, and team structure and goals.
- We’re excited for you to learn, grow, and contribute right away! We trust that you’ll bring experience and knowledge that will uplift and uplevel the team, but we don’t expect you to know everything on Day 1.
In your role, you'll...
- Design and implement robust data models to support financial and revenue reporting.
- Build and maintain ETL pipelines to ensure timely and accurate data delivery.
- Ensure data integrity and security in alignment with organizational and compliance standards.
- Develop and maintain dashboards and reports in Looker to track key financial and revenue metrics.
- Collaborate with finance teams to understand reporting requirements and provide actionable insights.
- Work closely with finance stakeholders, and other cross-functional teams to ensure data consistency and accuracy.
- Implement data validation and testing processes to ensure accuracy and consistency.
- Monitor data workflows and troubleshoot issues proactively.
About you
- 6+ years of experience as a BI Engineer, Data Engineer, Data Analyst, or in a similar role.
- Proven expertise in PostgreSQL, including writing and optimizing complex SQL queries.
- Hands-on experience with ETL tools like Fivetran.
- Proficiency with dbt for data transformation and modeling.
- Proficiency with Looker for building and maintaining dashboards and reports.
- Experience in financial and revenue reporting is a must.
- Strong analytical and problem-solving abilities.
- Excellent communication and stakeholder management skills.
- Ability to work in a fast-paced environment and manage multiple priorities.
Bonus:
- Experience with cloud platforms (e.g., AWS, GCP, Azure).
- Knowledge of Python or other programming languages.
Benefits
- The expected salary range for this role is between $180,000 - $210,000. The final offered salary will be dependent upon many factors including the candidate’s experience and skills. The base pay range is subject to change in the future.
- Equity program
- 401(k) retirement plan with company matching
- Health, dental, and vision
- Flexible Spending Accounts for health and dependent care expenses
- Paid parental leave and approximately 10 days (80 hours) per year of sick leave
- Seventeen paid vacation days plus 11 federal holidays
- Membership to Modern Health to help employees prioritize mental health and wellness
- Annual allocation for Learning & Development opportunities and applicable professional membership dues
- Company-sponsored life and disability insurance
- Find out more about our Benefits and Perks
Perks
- Work in Uptown Oakland, just steps from the BART line and dozens of restaurants and walking distance to Lake Merritt
- Flexible work-from-home days on Tuesdays and Fridays
- Monthly home internet reimbursement
- Select your preference of hardware (Mac or PC) and customize your desk setup
- Enjoy a wide variety of snacks and beverages in the office
- Bond over company-wide out-of-the-box events and fun activities with your team
- Time off for company-sponsored volunteer events and 4 paid hours per quarter to volunteer at a charitable organization of your choice
- Take advantage of learning and career development opportunities
- Ranked #9 on Glassdoor's Best Places to Work 2023 for US small and medium companies
- One of Wealthfront’s 2021 Career Launching Companies, and ranked #2 on the “2022 Bay Area Best Places to Work” list by the San Francisco Business Times and the Silicon Valley Business Journal
- One of Fast Company’s World's Most Innovative Companies for 2022 and proud contributor of free ediscovery resources to benefit the greater good through “Everlaw for Good”
- #LI-JA1
- #LI-Hybrid