OneApp is a mission-driven company that increases access to rental housing by removing financial and systemic barriers for renters while reducing risk for property managers. As a Revenue Operations Data Analyst, you will transform data into actionable insights that drive strategic business decisions and revenue growth, partnering with cross-functional teams to analyze performance trends and support data-driven initiatives.
Responsibilities
- Write and optimize SQL queries against Snowflake and MySQL databases to extract, transform, and analyze data
- Build, maintain, and enhance interactive dashboards and reports in Power BI for stakeholders across the business
- Partner with team members to translate business questions into clear, well-scoped analytical deliverables
- Validate data quality and investigate discrepancies between source systems and reporting layers
- Document data sources, definitions, metrics, and report logic to support self-service analytics
- Support ad-hoc analysis requests and contribute to recurring business reviews
- Continuously look for opportunities to streamline manual processes and improve reporting efficiency
Skills
- Bachelors degree in a quantitative or analytical field (e.g., Business Analytics, Statistics, Computer Science, Economics, Finance, Mathematics or equivalent hands on experience
- Working proficiency with SQL, including experience writing queries in Snowflake and MySQL (joins, aggregations, CTEs, window functions)
- Hands-on experience building reports and dashboards in Power BI, including data modeling and basic DAX
- Strong analytical thinking with attention to detail and a commitment to data accuracy
- Clear written and verbal communication skills, with the ability to explain findings to non-technical audiences
- Ability to manage multiple priorities and meet deadlines in a collaborative environment
- Working knowledge of HubSpot, particularly around CRM data, marketing/sales reporting, or HubSpot data exports
- Understanding of data flows and how data moves between source systems, warehouses, and reporting tools (ETL/ELT concepts)
- Experience defining or working with KPIs and business metrics frameworks
- Familiarity with automation concepts — scheduled refreshes, alerting, workflow tools (e.g., Power Automate, Zapier), or scripting (Python preferred)
- Exposure to version control (Git) and modern analytics workflows
Benefits
- Profit sharing plan
- Medical, Dental and Vision Benefits
- 401K Plan
- Unlimited PTO
Company Overview
OneApp offsets economic housing setbacks with modern, innovative solutions and a goal to house 1M people by 2032. It was founded in 2019, and is headquartered in Portland, Oregon, USA, with a workforce of 51-200 employees. Its website is https://oneappguarantee.com.