Logo for PadSplit

Senior Data Analyst (Fully Remote)

PadSplit

Role overview

Qualifications

  • 5+ years of experience in data analytics or a closely related field
  • Advanced skills in SQL, including window functions and query optimization
  • Hands-on experience with Snowflake
  • Building and maintaining dbt models in a production analytics environment

Responsibilities

  • Write, optimize, and maintain complex SQL against Snowflake warehouse
  • Build and maintain dbt models for reusable datasets
  • Build dashboards and reporting in Hex for business leaders
  • Investigate anomalies in key metrics and communicate findings

Key facts

Hard skills

Other skills

  • Mentorship
  • Communication
  • Curiosity
  • Detail Oriented
  • Problem Solving

About the company

PadSplit logo

PadSplit

E-commerce & Online Marketplaces

At PadSplit we’re disrupting the affordable housing industry by creating safe, attractive, and respectable co-living environments. Welcome to PadSplit, the nation's largest co-living marketplace and the leading provider of innovative housing solutions. We're here to tackle the affordable housing crisis, one room at a time. 💪 At PadSplit, we're dedicated to empowering individuals and investors by bridging the gap between supply and demand in the rental market. Our unique co-living model revolutionizes how people live, fostering a strong sense of community and enabling financial freedom. As a PadSplit Member, you gain access to a supportive community of like-minded individuals, along with fully furnished rooms and amenities within shared living spaces. It's a vibrant and affordable living experience like no other! For PadSplit Hosts, we provide a reliable stream of residents who have been meticulously vetted to meet our strict safety and community engagement standards. By joining PadSplit, you not only unlock a new revenue stream but also make a positive impact on your community. Join us at PadSplit and be part of the solution to the housing shortage. Together, we can create better living opportunities for all. Contact us today to learn more! #PadSplit #CoLiving #CommunityImpact

Company details

Company typeSME
IndustryE-commerce & Online Marketplaces
Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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
    •

    Apply once. Then go straight to the hiring manager.

    After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

    MR

    Marcus Rivera

    Chief Revenue Officer

    m.rivera@company.com
    linkedin.com/in/marcusrivera
    Unlocked after you apply
    ·

    Data Analyst Related jobs

    South AmericaData Analyst

    Other jobs at PadSplit

    Premium

    Reach out to the hiring manager directly.

    Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

    • Full match report with fit score and gaps
    • Career diagnostics on how recruiters read you
    • Curated company matches and warm intros
    • 48h early access to new roles

    Cancel anytime.