Business Intelligence Analyst, Accounting
Snowflake
- Dublin, CA
- Permanent
- Full-time
- Work with a wide range of finance and technical stakeholders to identify use cases and gather requirements for analysis, reporting, and automation
- Research data from key business systems, work with IT to ingest data into Snowflake, assess data quality, map requirements to available data, architect data models and data pipelines, and design end-to-end business intelligence solutions to support our Accounting team
- Analyze data to shed light on key business questions and present on findings
- Build dashboards to enable ongoing delivery of information and insights to Accounting stakeholders
- Formulate project plans, provide status updates, and work with Accounting team members to perform user testing and QA
- Build and maintain user friendly documentation for data models, metrics, and reporting
- Think creatively to find optimal solutions to our complex, often unstructured problems
- Identify weaknesses in processes, data, and systems, and drive improvements
- 2+ years of experience working as a BI analyst or engineer
- Advanced SQL skills, with experience using SQL to perform analysis, standardize queries, and build large-scale relational datasets
- Experience developing, deploying, and maintaining enterprise level reports using BI tools such as Streamlit, Tableau, Power BI, Looker, or other relevant technologies
- Experience with MPP databases such as Snowflake, Redshift, BigQuery, or other relevant technologies
- Ability to communicate in an effective and efficient manner with a wide range of technical and non-technical stakeholders, including senior leaders
- Ability to prioritize and execute tasks in a high-pressure, constantly changing environment
- An impulse for taking ownership and introducing structure and simplicity when faced with vague, complex problems
- An obsession for detail and quality
- A bias for action
- Experience with ERP and Financial Planning tools
- Experience using Python to parse, structure, and transform data
- Experience leading or working within a scrum, sprint, or other agile framework
- Past experience working in a finance or accounting role, or directly supporting analysis and reporting for finance or accounting stakeholders