Analytics Engineer

Airbyte is the open-source standard for EL(T). We enable data teams to replicate data from applications, APIs, and databases to data warehouses, lakes, and other destinations. We believe only an open-source approach can solve the problem of data integration, as it enables us to cover the long tail of integrations while enabling teams to adapt pre-built connectors to their needs.

So far, we've built over 350 connectors and have had 60,000+ companies replicating data with us. We've raised $181M from some of the world's top investors (Benchmark, Accel, Altimeter, Coatue, Y Combinator, etc.) and believe in product-led growth, where we build something awesome and let our product bring the users, rather than an outbound sales engine with cold calls.

Airbyte is a hybrid workplace with most of the team based in Silicon Valley. We’re committed to providing as much context to our current employees and candidates. The Airbyte company handbook, core values, methodology, strategy, and roadmap are open to all.

Unless stated otherwise, all roles are Hybrid in our Embarcadero office Tuesday through Thursday. If you find this role exciting, we encourage you to apply even if you think you don’t meet all requirements.

Opportunity

We are seeking a highly skilled and experienced Analytics Engineer to join the Data Team. In this role, you will work closely with product managers, engineers, and functional leads to build and maintain robust data pipelines and analytics infrastructure. You will be responsible for ensuring that data is accurate, accessible, and actionable, enabling our team to make informed product decisions. You will also play a key role in providing product feedback, helping us refine and improve our offerings based on firsthand experience.

What You'll Do

• Data Pipeline Development: Design, build, and maintain scalable and efficient data pipelines using Airbyte.
• Analytics Engineering: Develop and optimize data models, transformations, and visualizations using dbt, BigQuery, Metabase, and Metaplane.
• Data Analysis: Analyzing data to provide insights on product performance, customer behavior, financial metrics, etc.
• Reporting: Creating dashboards and reports that provide stakeholders with the necessary data to make informed decisions.
• Product Feedback: Actively use our own product, providing valuable feedback to the product team to help improve the Airbyte platform.
• Collaboration: Work closely with product managers and function leads to understand data needs, deliver insights, and support product development initiatives.

What You'll Need

• Experience: 3+ years of experience in data engineering, analytics engineering, or data analysis, with a strong focus on building and maintaining data pipelines and analytics infrastructure.
• Technical Expertise: Proficiency in dbt, BigQuery, Metabase, Metaplane, or similar tools. Experience with ELT processes and data integration tools is essential.
• Data Modeling: Strong understanding of data modeling principles and experience in designing and optimizing data models for analytics.
• Data Analysis: Expertise in analyzing large datasets and identifying trends, anomalies, and actionable insights.
• Problem Solving: Ability to troubleshoot data-related issues and optimize data processes.
• Attention to Detail: Ensuring data accuracy and integrity in all outputs.
• SQL Mastery: Advanced SQL skills with the ability to write complex queries and optimize performance in large datasets.
• Cloud Experience: Hands-on experience with cloud platforms, particularly Google Cloud Platform (GCP).
• Communication: Excellent communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.
• Belief in our values

Location

• San Francisco. Hybrid, Tuesday, Wednesday, Thursday. 

Salary for this job

We Provide 

The benefits listed below are for US-based employees.

• Relocation - should you apply to a San Francisco based role, Airbyte will assist with U.S. relocation to make this a seamless transition and compensate you well.
• Unlimited Paid Time Off - we need you at your best at all times. Our expected minimum time off of 25 PTO days per year lets you schedule your work around your life.
• Parental leave (for new parents) - we offer 16 weeks of paid parental leave for all new parents so you have time to adjust to the new life (and work) schedule introduced by your new bundle of joy.
• Sponsored Travel - Airbyte has a partially distributed team and we recognize the value of in-person time. We sponsor annual company-wide retreats, team offsites, and Travel With Purpose in between to allow you to collaborate with your team in person on a regular basis.
• Open book policy - we will pay for books you purchase for your professional and career development. 
• Continuous learning/training policy - we sponsor you for the conferences and training programs you feel would add to your development in the company. 
• Competitive benefits package for US-based employees, including:
• Blue Shield or Kaiser Medical Insurance 
• Airbyte covers 100% for both employees and dependents
• Dental (including child & adult ortho) & Vision Insurance
• Airbyte covers 100% for both employees and dependents
• Life and AD&D Insurance
• Airbyte covers 100% for employees
• Short-term Disability Insurance 
• Airbyte covers 100% for employees 
• Long-term Disability Insurance
• Airbyte covers 100% for employees
• Healthcare insurance stipend for those outside the US whose countries do not provide it for free.
• 401k for US-based employees.
• FSA (flexible spending account)
• Work Visas We currently sponsor H1B Transfers, TN Visas, and Green Cards. All other Visa requests will be discussed on a case by case basis to determine if we can sponsor.

Airbyte is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, national origin, ancestry, age, physical or mental disability, pregnancy, genetic information, sex, sexual orientation, gender identity or expression, marital status, familial status, domestic violence victim status, veteran or military status, or any other legally recognized protected basis under federal, state or local laws. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. 

Airbyte is committed to providing reasonable accommodations for qualified individuals with disabilities in our job application procedures. Please let us know if you need assistance or accommodation due to a disability.