Analytics Engineer · Senior · Faire

the posting, the skills it asks for, and the plan to get there

Faire · boards.greenhouse.io · checked today

Senior Finance Analytics Engineer

New York City, NY; San Francisco, CASenior5+ yrsAnalytics Engineerposted 1 d ago

<div class="content-intro"><p><span style="font-weight: 400;"><strong>About Faire</strong></span></p> <p>Faire is a technology wholesale platform built on the belief that the future is local. Independent retailers around the globe collectively represent a multi-hundred-billion-dollar wholesale market that has historically been fragmented and offline.

Skills, with evidence

  • Airflow / orchestration
    Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt)must have
  • Data modelling
    Expert in SQL, with a focus on data modeling, large-scale data processing, and tool development for analytics or financial use casesmust have
  • Python
    Working proficiency in Python (or a similar language) for pipeline development, automation, and toolingmust have
  • SQL
    Expert in SQL, with a focus on data modeling, large-scale data processing, and tool development for analytics or financial use casesmust have
  • Warehousing
    Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with data warehousing (e.g., Snowflake, BigQuery, Redshift, S3)must have
  • dbt
    Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt)must have
  • Failure handling
    <li>Implement and maintain monitoring, alerting, and testing for data workflows to ensure high data quality and reliability, and champion CI/CD and other engineering best practices within the team's pipelines</li>
  • AWS
    <li>Collaborate closely with Engineering and Data Infrastructure to manage and improve data integrations (e.g., Fivetran connectors, S3 pipelines, and other ingestion patterns) and ensure alignment and efficiency across the organization</li>not practised here
  • Data quality
    <li>Implement and maintain monitoring, alerting, and testing for data workflows to ensure high data quality and reliability, and champion CI/CD and other engineering best practices within the team's pipelines</li>
  • Dashboards & BI
    <li>Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt), data warehousing (e.g., Snowflake, BigQuery, Redshift, S3), and data visualization tools (e.g., Mode, Tableau, Looker)</li>not practised here
  • GCP
    <li>Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt), data warehousing (e.g., Snowflake, BigQuery, Redshift, S3), and data visualization tools (e.g., Mode, Tableau, Looker)</li>not practised here
  • Governance & security
    <li>Experience supporting SOX compliance requirements (e.g., controls, audit trails, change management) in a data or finance systems context</li>not practised here
  • Kubernetes
    <li>Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt), data warehousing (e.g., Snowflake, BigQuery, Redshift, S3), and data visualization tools (e.g., Mode, Tableau, Looker)</li>not practised here
  • Machine learning
    At Faire, we're using the power of tech, data, and machine learning to connect this thriving community of entrepreneurs across the globe.not practised here

Your plan

  1. 2 h
  2. 3 h
  3. Data modelling: the round most people fail

    Data modelling · Warehousing · dbt

    3 h
  4. Pipeline design: safe to run twice

    Airflow / orchestration · Failure handling

    4 h
  5. 1 h
20 drills · Intermediate + Advanced12 hours

Not covered by the plan: AWS, Dashboards & BI, GCP, Governance & security, Kubernetes, Machine learning.

Readiness

Counted from drills you have completed anywhere on D8LooP.

leaves in 12 dremoved the moment Faire closes it

Senior Finance Analytics Engineer at Faire: skills and prep plan · D8LooP