Analytics Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Collaborate with Finance, Sales, Operations, and venue teams to identify needs and develop reliable models and metrics.

• Establish and manage Fivetran connectors, ensure data is stored in bronze, and address schema drift and load failures.

• Create dbt models across bronze, silver, and gold layers.

• Define and oversee the semantic layer, which includes metrics, dimensions, relationships, synonyms, and descriptions.

• Develop ThoughtSpot models and Liveboards to enable self-service analytics.

• Validate conversational analytics through golden question sets and regression suites.

• Facilitate data governance by tagging sensitive data, implementing tag-based masking, and managing row access policies.

• Track data freshness, quality, and overall health of pipelines.

• Enhance query and model performance, manage warehouse sizing, and optimize Snowflake costs.

• Utilize AI agents for comprehensive data tasks while adhering to review and quality standards.

• Work in partnership with analytics engineers, business partners, and the Data Platform team.

⛳️ Requirements

• Minimum of 3 years in analytics engineering, data engineering, or BI development.

• Proficient in SQL.

• Proven experience in building and maintaining dbt models in a production environment.

• Familiarity with cloud data warehouses, preferably Snowflake.

• Experience with ELT ingestion tools like Fivetran.

• Skilled at troubleshooting schema changes, late-arriving data, and API limitations.

• Knowledge of dimensional models, medallion layering, grain, slowly changing dimensions, and event lifecycles.

• Experience in creating dashboards or self-service data products.

• Strong habit of testing and documenting work processes.

• Experience utilizing AI agents for multi-step tasks including writing SQL and dbt models, generating tests, and drafting documentation.

• Ability to communicate work clearly to both technical and non-technical partners.

🏝️ Benefits

• Day-one health coverage for you and your family.

• 24/7 virtual care.

• Emotional well-being support.

• Fertility and family planning benefits.

• Generous PTO.

• Birthday off.

• Paid parental leave.

• Year-end holiday closure.

• 401K with company match.

• Support for education, courses, and certifications.

• Ongoing career growth opportunities.

• Recognition programs.

• Volunteer and community engagement opportunities.