Write, QA, and maintain/update the SQL logic underpinning our core data models which power all business KPI reporting at the company
Collaborate with business stakeholders to understand their reporting needs; leverage a combination of data insights and business acumen to advocate and build business cases for strategic initiatives
Create and maintain reports, dashboards, and data sources that effectively communicate and surface business insights for our most critical KPI’s and can be easily understood by teams
Monitor performance trends and identify areas of improvement; conduct ad hoc analysis and provide recommendations to teams for improving business processes and strategy
Work closely with our technical engineering, product, and business teams throughout the development of new features or changes to third party business systems to anticipate and communicate data needs
Create and manage a roadmap with primary business stakeholders to define goals, prioritize work, and communicate expected timelines and deliverables
Develop BI best practices around our data warehouse and ETL pipelines, data architecture, documentation, and data visualization tools (e.g., Tableau, Looker)
Requirements & Skills:
Bachelor’s degree, quantitative field preferred
Experience in Business Intelligence or similar role that involves developing data models and databases as a nascent or rapidly scaling business; proven ability to transform messy or unstructured data into robust, well-organized data models
Experience developing data models and working with data warehouses (Snowflake and Postgres experience a plus)
Familiarity with BI tools and platforms (Tableau, Looker, Fivetran, ETL pipelines, dbt, Excel)
Has a strong interest in the business-side implications of work; is able to build positive working relationships with teams to “keep up” with what’s going on and feels comfortable collaborating with stakeholders of all seniority levels to understand data needs
Ability to present complex analysis in a clear and understandable manner to both technical and non-technical stakeholders
Strong problem-solving skills; has a logical mindset and can identify business challenges and propose data-driven solutions
Detail-oriented; loves finding “edge cases” and ensures data accuracy by troubleshooting, testing, and carefully reviewing output
Familiarity with road mapping or sprint cycles; is able to communicate priorities and meet deadlines