Analytics Engineer San Francisco

Company: Tbwa Chiat/Day Inc
Location: San Francisco
Posted on: November 1, 2024

Job Description:

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.If you find this role exciting, we encourage you to apply even if you think you don't meet all requirements.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.Compensation$140,000- $150,000 + a generous equity package, and benefits listed below for US Market.We ProvideThe 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: Our expected minimum time off of 25 PTO days per year lets you schedule your work around your life.
    • Parental Leave: We offer 16 weeks of paid parental leave for all new parents.
    • Sponsored Travel: We sponsor annual company-wide retreats, team offsites, and Travel With Purpose.
    • 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: Including medical, dental, vision, life insurance, and more.
    • Work Visas: We currently sponsor H1B Transfers, TN Visas, and Green Cards.Airbyte is an equal opportunity employer that does not discriminate on the basis of any protected group status.Apply for this job* indicates a required field
      #J-18808-Ljbffr

Keywords: Tbwa Chiat/Day Inc, Tracy , Analytics Engineer San Francisco, Engineering , San Francisco, California