Senior Analytics Engineer

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

📋 Description

• Create, develop, and manage dimensional models in dbt and Snowflake for reporting and analysis across various business areas including Finance, Operations, and Product Management.

• Collaborate with senior leaders to translate business inquiries into precise data requirements.

• Take ownership of the entire model lifecycle, which encompasses source ingestion, staging, intermediate and mart layers, testing, documentation, and deployment.

• Establish and uphold modeling standards, including naming conventions, grain definitions, slowly changing dimensions, and testing methodologies.

• Optimize Snowflake performance and cost via materialization strategies, clustering techniques, and warehouse sizing.

• Work alongside data engineers and business systems teams to ensure that upstream data is appropriate for modeling purposes.

• Review pull requests and provide mentorship to analysts and engineers.

• Clarify data definitions and trade-offs to non-technical stakeholders, while questioning requests that may lead to inaccurate metrics.

• Deliver production models within the initial 90 days.

• Assume control of a significant data-model domain within six months.

• Develop modeling standards and enhance team efficiency within a year.

⛳️ Requirements

• Over 5 years of experience in analytics engineering, data engineering, or a related field.

• A Bachelor's degree in Computer Science, Information Systems, Finance, or another quantitative discipline is preferred.

• Extensive hands-on experience with dbt, including macros, packages, incremental models, snapshots, and testing procedures.

• Proficient in Snowflake, with advanced SQL skills and a solid understanding of performance and cost considerations.

• Experience in designing dimensional models, encompassing star schemas, facts, dimensions, and conformed dimensions.

• Strong knowledge of data architecture, including layered modeling, grain, lineage, data contracts, and maintainable project structure.

• Familiarity with business functions such as finance, sales, operations, and product management.

• Ability to engage in discussions about business challenges with directors, VPs, and executives, converting those discussions into data-driven solutions.

• Excellent written and verbal communication abilities.

• Experience utilizing Git-based workflows and CI/CD practices for data projects.

• Experience modeling data from CRM and business systems like Salesforce is advantageous.

• Familiarity with Airflow or dbt Cloud is a plus.

• Experience with Tableau, Looker, or Power BI is a bonus.

• Background in a SaaS or education technology company is preferred.

🏝️ Benefits

• Competitive salary.

• Full-time employee ownership program.

• Flexible work environment.

• Generous leave policy, including local holidays and an annual “Dim the Lights” period in late December.

• Comprehensive wellness initiatives and mental health support.

• Access to learning and development resources.

• Professional development tools.

• Tuition reimbursement program.

• Necessary technology and tools to excel in your role.

• Motivosity employee recognition program.

• Inclusive and supportive workplace culture.

• Background check and identity verification conducted as part of the hiring process.