Job details
About this role
The Role We Need
We Need
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.
\n
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
\n
$45,000 - $55,000 a year
\n