Salary
💰 $152,000 - $204,700 per year
Tech Stack
AirflowAmazon RedshiftBigQueryPythonSQL
About the role
- Design, develop, and maintain the data infrastructure that powers business intelligence, strategic analysis, and AI workloads across the company
- Use SQL, Python, Snowflake, dbt, Airflow, and other systems within an agile development model to build and maintain data infrastructure for 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 and drive 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 in an effective and efficient manner while working 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, an ability to identify weaknesses in data and process, and a willingness to drive improvement
- Willingness to work flexible international hours as needed
- Expected to follow company confidentiality and data security standards for handling sensitive data