Senior Data Analyst (Fully Remote)

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

Originally posted on Himalayas