Analytics Engineer

About the Role

Key Responsibilities

• Use SQL, Python, Snowflake, dbt, Airflow, and other systems while working within an agile development model to build and maintain data infrastructure for use in reporting, analysis, and automation
• Develop Snowflake semantic models that can be leveraged by Cortex Analyst and power AI experience for data
• Perform data QA and develop automated testing procedures for use with Snowflake data models
• Translate reporting, analysis, and automation requirements into data model requirements and specifications
• Work with IT and other technical stakeholders to source data from key business systems and Snowflake databases
• Architect flexible, performant data models that will support a wide range of use cases while driving the organization towards single sources of truth
• Provide input into data governance strategies and frameworks including permissions and security models, data lineage systems, and data definitions
• Build and maintain user friendly documentation for data models and key metrics
• Identify weaknesses in processes, data, and systems, and drive organizational improvements within the Analytics Engineering team

Requirements

• 5+ years of experience working as an analytics, data, or BI engineer
• Advanced SQL skills with experience standardizing queries and building data infrastructure involving large-scale relational datasets
• Experience using Python to parse, structure, and transform data
• Experience with MPP databases such as Snowflake, Redshift, BigQuery, or other relevant technologies
• Ability to communicate effectively with a wide range of stakeholders
• Ability to prioritize and execute tasks in a high-pressure, constantly changing environment
• Ability to think creatively to solve problems
• Passion for detail and quality, with the ability to identify weaknesses in data and process, and a willingness to drive improvement
• Willingness to work flexible international hours as needed

Nice to Have

• Experience with Snowflake, Redshift, BigQuery, or other relevant MPP databases
• Experience with data governance strategies and frameworks including permissions, security models, data lineage, and data definitions

Qualifications

• Formal experience or education in data engineering or related fields (implied by 5+ years of relevant work experience)

Benefits & Perks

• Competitive salary range of $152,000 - $204,700 plus bonus and equity plan
• Medical, dental, vision, life, and disability insurance
• 401(k) retirement plan
• Flexible spending and health savings accounts
• At least 12 paid holidays and paid time off
• Parental leave
• Employee assistance program
• Other company benefits