This role requires in-person attendance in our Menlo Park, CA office at least 3 days per week.We are looking for an Analytics Engineer to join our growing Finance Analytics Engineering team. In this role, you will drive value and empower decision-making by developing and maintaining the data infrastructure which fuels reporting and analysis for the Finance organization and has a direct impact on Snowflake's success as a company. As an Analytics Engineer, you will be responsible for the following:
- 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
- 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
- Meet regularly with Finance BI and technical leads to define requirements, formulate project plans, provide status updates, and perform user testing and QA
- 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
What You Will NeedRequired skills:- 3+ 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
- An impulse for introducing structure and simplicity into vague, complex problems
- An obsession for detail and quality
- An ability to identify weaknesses in data and process, and a willingness to drive improvement
- A bias for action
Preferred skills:- Experience with ERP and Financial Planning tools
- Experience using Python to parse, structure, and transform data
- Experience working with CI/CD pipelines
- Experience leading or working within a scrum, sprint, or other agile framework
- Past experience supporting product or product finance stakeholders
- Experience working with cost attribution models for SaaS products and tying products out to CSP cost reports
- Familiarity with cloud cost management and understanding of cost structures in cloud environments (e.g. FOCUS Framework)
- Demonstrated experience in cloud computing platforms (e.g., AWS, Azure, Google Cloud)
