Sr. Analytics Engineer

Essential Job Functions

Serve as a steward high-level health of the enterprise data warehouse, managing the lifecycle of data assets
Perform code reviews for data model updates
Design and develop data models for business and application domains
Create and QC the SQL transformation pipelines to convert raw data into modeled data
Identify refactoring opportunities for DAG scalability
Establish and implement standards for dbt, SQL, data quality, automated testing, and documentation
Troubleshoot and optimize SQL queries
Monitor and optimize overall run performance for data warehouse build process
Coach BI Engineers and non-BI team contributors on best practices
Provide feedback to the data platform team that builds tooling and infrastructure, owning the developer experience of the data modeling & publication process
Own key data models as needed

Building dashboards and creating analyses will not be a core part of this position. This is a high-leverage role that maintains the library and map of our data ecosystem: your primary customers are analysts and engineers.

Skills and Attributes

Practical knowledge of data modeling and data design strategies
Advanced SQL skills—readable, fast queries are your default
Hands-on dbt (or dataform, sqlmesh, etc) experience
Comfortable coaching and mentoring other team members
Hands-on experience using and optimizing OLAP query engines
Meticulous about correctness and quality of work
Comfortable navigating a complex data ecosystem: ability to see big picture while also digging into the details

Preferred Skills

Specific experience with Snowflake
Dbt macros or Jinja

Nice to have but not required

Practical programming experience in a team environment
Experience with Terraform or infrastructure as code

Education and Experience

Required: multiple years as a developer or engineer in the data/BI/analytics space
Preferred: prior experience as an analytics engineer, data architect or similar role

‌