Data and Analytics Engineer

Payactiv; Milpitas (CA); On-site; USD 130,000 - 165,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

401(k) with company match

Tuition assistance or reimbursement

Unlimited paid time off

Monthly gym reimbursement

Paid time off to volunteer

Job summary

Payactiv, a FinTech company, seeks a Data and Analytics Engineer to own and support reporting, analytics, dashboards, and data requests. You will manage Snowflake-based workflows, ensure data accuracy, and translate business questions into outputs for stakeholder use.

You will partner with User Lifecycle & Growth, Customer Success, Marketing, Legal, Compliance, and executives to deliver reliable data solutions and scalable self-serve analytics across the organization.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or related field.
• 4+ years of experience in data analytics engineering, BI, reporting, data engineering, or database development.
• Strong hands-on SQL experience with complex joins, aggregations, CTEs, window functions, and query optimization.
• Experience with Snowflake or other cloud data warehouses; strong Excel skills; familiarity with BI dashboards.

Responsibilities

• Write, optimize, and maintain SQL queries against the Snowflake data warehouse.
• Build and maintain curated datasets, views, and reporting tables to support business reporting, analytics and list generation.
• Partner with business stakeholders to gather requirements and define data solutions.
• Build trusted, scalable data sources and products for reliable insights and accurate lists for user acquisition and lifecycle messaging.
• Manage, maintain, and enhance analytics, BI dashboards and data visualizations across the organization.
• Lead the development of self-serve tools enabling analytics to scale across the company.
• Implement dashboard changes, updates, new metrics, filters, and views based on business needs.
• Validate data pulls, reports and dashboards by reviewing logic, source tables, joins, calculations, and definitions.
• Present recommendations and reporting results to internal stakeholders and leadership.
• Support ad hoc data requests from various internal teams.
• Support data quality checks, reconciliation, and validation across lists and reports.

Skills

SQL

Snowflake

Excel

BI tools

Sigma Computing

Python

Education

Bachelor’s degree in Computer Science/Information Systems/Data Analytics/Engineering

Tools

Snowflake

Sigma Computing

Job description

We are Payactiv, a FinTech company in the heart of Silicon Valley, devoted to giving workers access to their earned wages when they need them. Payactiv is the pioneer and industry leader in Earned Wage Access. We are the only Certified B Corporation and Public Benefit Corporation in our industry. Our app provides millions with financial services that help them avoid debt, manage their finances, and regain flexibility to pay for things on their own schedule.

What you will do…

Payactiv is seeking a hands-on Data and Analytics Engineer to own and support our business reporting, analytics, dashboarding, and marketing/operational data request workflows. This is a highly technical role responsible for managing analytics dashboards and BI reporting, supporting our Snowflake data warehouse environment, fulfilling data requests for user lifecycle messaging, and ensuring the accuracy, quality, and reliability of business-critical reporting.

The ideal candidate has strong SQL skills, experience working with cloud data warehouses such as Snowflake, and the ability to partner directly with business teams including User Lifecycle & Growth, Customer Success, Customer Support, Marketing, Legal, Compliance and executive stakeholders. This person should be comfortable translating business questions into accurate data outputs, maintaining trusted dashboards, and supporting recurring and ad hoc reporting needs.

Key Responsibilities

• Write, optimize, and maintain SQL queries against the Snowflake data warehouse.
• Build and maintain curated datasets, views, and reporting tables to support business reporting, analytics and list generation.
• Partner with business stakeholders to gather requirements and define data solutions
• Build trusted, scalable data sources and products that give the business reliable, actionable insights and accurate lists for user acquisition and lifecycle messaging
• Manage, maintain, and enhance analytics, BI dashboards and data visualizations used across the organization.
• Lead the development of self-serve tools that enable analytics to scale across the company
• Implement dashboard changes, updates, new metrics, filters, and views based on business needs.
• Validate accuracy of data pulls, reports and dashboards by reviewing data logic, source tables, joins, calculations, and definitions.
• Present recommendations and reporting results to internal stakeholders and leadership
• Support ad hoc data requests from various internal teams.
• Support data quality checks, reconciliation, and validation across list generation and reporting workflows. Monitor and maintain data quality, integrity, and consistency across different environments.
• Be a cross-functional champion and collaborate closely with Engineering, User Lifecycle and Growth, Data Scientists, BI and other teams to understand data sources, business rules, and reporting requirements.
• Maintain documentation for key dashboards, metrics, assumptions, report logic, and data definitions.
• Identify opportunities to standardize, automate, and improve recurring reporting and data request processes.
• Prepare, validate, and deliver data extracts, Excel-based reports, and lists for business stakeholders.
• Use automation where appropriate to improve recurring reports, QA checks, and data delivery workflows.

What you need…

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field.
• 4+ years of experience in data analytics engineering, business intelligence, reporting, data engineering, or database development.
• Strong hands‑on SQL experience, including complex joins, aggregations, CTEs, window functions, and query optimization.
• Experience working with Snowflake or another cloud data warehouse.
• Strong Excel skills including pivot tables, lookups, formulas, data validation, and working with large CSV/data extracts.
• Experience with BI/dashboarding tools; Sigma Computing experience is a plus.
• Experience supporting business teams with ad hoc reporting, data pulls, dashboards, and operational analytics.
• Ability to validate data accuracy, troubleshoot reporting discrepancies, and explain data logic to technical and non-technical stakeholders.
• Python experience for data extraction, automation, QA, or reporting workflows is a plus.
• Strong attention to detail, especially when working with legal, compliance, financial, or executive-level reporting.
• Excellent written and verbal communication skills.

What we offer…

• Company-sponsored health, dental, and vision insurance.
• Health, dental, and vision reimbursement account.
• 401(k), traditional and Roth, with a company match.
• Tuition assistance or tuition reimbursement.
• Unlimited paid time off.
• Monthly gym reimbursement.
• Paid time off to volunteer.
• Paid family leave.
• Complimentary office lunches.
• Work in a fast-paced, innovative environment with modern data technologies.
• Opportunity to influence business reporting, analytics, and data quality across the organization.
• Salary Range: $130K to $165K (Based on experience) plus Bonus