About the role
- 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)
Skills & experience
- Bachelor's degree, quantitative field preferred
- Experience in Business Intelligence or similar role that involves developing data models and database as a nascent or rapidly scaling business;
proven ability to transform messy or unstructured data into robust, well-organized data models
- Advanced SQL skills required (PostgreSQL, Snowflake)
- Experience developing data models and working with data warehouses (Snowflake, 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
