The Role We Need
PadSplit runs on data, from Growth and Operations to Product and Finance, and we need someone who can turn that data into clear, trustworthy decisions. We're looking for a Senior Data Analyst to own analyses end to end, build durable reporting infrastructure, and help shape how the company measures its business. This person will work daily across our modern data stack (Snowflake, dbt, and Hex) to answer high-impact questions and raise the analytical bar across the team.
The Person We Are Looking For
We're looking for someone with 5+ years of analytics experience who is equally comfortable writing expert-level SQL and translating ambiguous business questions into rigorous, well-documented analysis. This person is a strong communicator who can defend their methodology to technical and non-technical audiences alike, and who brings sound judgment about when to lean on AI tools versus when to verify. They're curious, detail-oriented, and take ownership seriously, from scoping a question through to following up on the outcome.
Here's What You'll Be Doing Day-to-Day:
- SQL & Analysis: Write, optimize, and maintain complex SQL against our Snowflake warehouse to answer business questions accurately and efficiently.
- dbt Modeling: Build and maintain dbt models that transform raw data into well-documented, tested, and reusable datasets.
- Dashboards & Reporting: Build dashboards, apps, and reporting in Hex that leaders trust and use to run the business.
- Stakeholder Partnership: Partner with teams to define metrics, scope analyses, and translate ambiguous questions into clear analytical work.
- Anomaly Investigation: Investigate anomalies in key metrics, identify root causes, and communicate findings with clear recommendations.
- Documentation: Maintain documentation across dbt and Hex so metric definitions stay consistent across teams.
- Data Quality: Validate sources, pressure-test assumptions, and flag gaps before they reach decision-makers.
- AI-Assisted Work & Mentorship: Use AI tools to accelerate analysis and reporting while verifying outputs, and mentor other analysts on best practices.
Here's What You'll Need to Be Successful:
- Analytics Experience: 5+ years of experience in data analytics or a closely related field.
- Expert SQL: Advanced skills in window functions, CTEs, query optimization, and large, complex datasets.
- Snowflake Expertise: Hands-on experience with Snowflake as a primary data warehouse.
- dbt Experience: Building and maintaining dbt models in a production analytics environment, including tests and documentation.
- Hex/Notebook Reporting: Experience building reporting in Hex or a similar notebook-based analytics platform.
- End-to-End Ownership: A track record of owning analyses from scoping through delivery and follow-through.
- Strong Communication: Ability to explain technical findings to non-technical audiences and defend your methodology.
- AI Fluency & Judgment: Working familiarity with AI tools in analytics, paired with sound judgment on when to verify outputs and how to handle sensitive data.
The Interview Process:
- Your application will be reviewed for possible next steps by a real human being from the PeopleOps team.
- If you meet eligibility requirements, the next step would be a video interview with a member of the PeopleOps team for about thirty (30) minutes.
- If warranted, the next step would be a video interview with our Head of Business Intelligence for forty-five (45) minutes.
- If warranted, the next step would be an SQL assessment through Coderbyte.
- If warranted, the next step would be a video panel interview with key stakeholders at PadSplit for one and a half (1.5) hours.
- If warranted, we move to offer!
Compensation, Benefits, and Perks:
- Fully remote position - we swear!
- Competitive compensation package including an equity incentive plan and company-wide bonus opportunity
- National medical, dental, and vision healthcare plans
- Company provided life insurance policy
- Optional accidental insurances, FSA, and DCFSA benefits
- Unlimited paid-time (PTO) policy with eleven (11) company-observed holidays
- 401(k) plan
- Twelve (12) weeks of paid time off for both birth and non-birth parents
- The opportunity to do what you love at a company that is at the forefront of solving the affordable housing crisis
