高级数据分析师(全远程)
Senior Data Analyst (Fully Remote)
我们正在寻找的职位
PadSplit依靠数据运行,从增长和运营到产品和财务,我们需要有人能将这些数据转化为清晰、可信的决策。我们正在寻找一位高级数据分析师,负责从头到尾完成分析,构建持久的报告基础设施,并帮助塑造公司衡量业务的方式。这个人将每天使用我们的现代数据栈(Snowflake、dbt 和 Hex)来回答高影响力的问题,并提升团队的分析水平。
我们正在寻找的人
我们寻找有 5 年以上分析经验的人,他们既能编写专业的 SQL,又能将模糊的业务问题转化为严谨、文档完善的分析。这个人具备出色的沟通能力,能够向技术和非技术人员解释自己的方法论,并在何时依赖 AI 工具与何时验证结果之间做出明智判断。他们充满好奇心,注重细节,对从问题定义到结果跟进的整个过程都认真负责。
你日常的工作内容包括:
- SQL 与分析:在我们的 Snowflake 仓库上编写、优化和维护复杂的 SQL,以准确高效地回答业务问题。
- dbt 模型:构建和维护 dbt 模型,将原始数据转换为文档完善、经过测试且可重用的数据集。
- 仪表盘与报告:在 Hex 中构建仪表盘、应用和报告,让管理层信任并用于运营业务。
- 利益相关者合作:与各团队合作定义指标、规划分析,并将模糊的问题转化为明确的分析工作。
- 异常调查:调查关键指标中的异常情况,识别根本原因,并以清晰的建议传达发现。
- 文档管理:在 dbt 和 Hex 中维护文档,确保各团队之间的指标定义保持一致。
- 数据质量:验证数据源,压力测试假设,并在问题影响决策者之前进行标记。
- AI 辅助工作与指导:利用 AI 工具加速分析和报告,同时验证输出结果,并指导其他分析师遵循最佳实践。
要成功胜任这份工作,你需要:
- 分析经验:5 年以上数据分析师或相关领域的经验。
- 专业 SQL:精通窗口函数、CTE、查询优化以及处理大型复杂数据集。
- Snowflake 专业知识:有使用 Snowflake 作为主要数据仓库的实际经验。
- dbt 经验
查看英文原文
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