Mashey Senior Analytics Engineer Remote · Full time

As a Senior Analytics Engineer, you will be working closely with clients, data engineering and analytics teams to gather requirements, develop data models and transform into clean data sets for BI and Analytics users.

Description

[{"attributes":{"color":"#2d2d2d","bold":true},"insert":"Our Analytics Tech Stack includes:"},{"insert":"\nSnowflake, Google BigQuery - Data Warehouse "},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Fivetran, Keboola - Data Pipelines"},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"dbt - Transformations, Modeling and Tests"},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"GitHub - Version Control and Automation"},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Looker - Visualization"},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"\nWhile you don’t need to have experience with all of these tools to be qualified, strong SQL proficiency is a must. Experience with dbt and/or Looker are big pluses.\n\n"},{"attributes":{"color":"#2d2d2d","bold":true},"insert":"What You’ll Do:"},{"insert":"\n"},{"attributes":{"color":"#2d2d2d"},"insert":"As a Senior Analytics Engineer, you will be working closely with clients, data engineering and analytics teams to gather requirements, develop data models and transform into clean data sets for BI and Analytics users. "},{"insert":"\n\n"},{"attributes":{"color":"#2d2d2d","bold":true},"insert":"Responsibilities:"},{"insert":"\nWork directly with clients to gather requirements on projects, understand current systems and data models and map to BI and Analytics use cases."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Design, develop and maintain data models and data transformations using dbt."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Audit and test models and queries to reduce cost and improve efficiency."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Design and implement schema and data tests for critical datasets."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Help to define and improve our internal standards for style, maintainability, and best practices for a high-scale data infrastructure."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"Mentor and coach junior engineers by guiding and providing feedback to help them grow."},{"attributes":{"list":"bullet"},"insert":"\n"},{"insert":"\n"}]

Requirements

BS in Computer Science or related field or equivalent experience

Strong SQL proficiency is a must (minimum 4+ years writing SQL as primary part of role)

5+ years experience in data warehousing methodologies and technologies such as Snowflake, Redshift, or BigQuery

2+ years experience creating data models and transformations using dbt or similar tools to curate data for use with BI tools.

Familiarity with BI tools like Looker, Tableau or PowerBI etc.

Understanding and experience in modern data warehouse, data modeling design and optimization

Experience in ELT design, implementation and maintenance

Capable of influencing decisions with data via analysis and visualizations