Data and Analytics Engineer

Payactiv seeks a hands-on Data and Analytics Engineer to deliver dependable business reporting, analytics, dashboards, and data request workflows.

Responsibilities

• Write, optimize, and maintain SQL queries against the Snowflake data warehouse.
• Build and maintain curated datasets, views, and reporting tables for business reporting, analytics, and list generation.
• Partner with business stakeholders to gather requirements and define data solutions.
• Create trusted, scalable data sources and products to provide 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 development of self-serve tools that help analytics scale across the company.
• Implement dashboard changes, including updates to metrics, filters, views, and other business-driven requirements.
• Validate accuracy of data pulls, reports, and dashboards by reviewing data logic, source tables, joins, calculations, and definitions.
• Share recommendations and reporting results with internal stakeholders and leadership.
• Support ad hoc data requests from internal teams.
• Perform data quality checks, reconciliation, and validation across list generation and reporting workflows.
• Monitor and maintain data quality, integrity, and consistency across different environments.
• Collaborate cross-functionally with Engineering, User Lifecycle and Growth, Data Scientists, BI, and other teams to understand data sources and business rules.
• 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 to improve recurring reports, QA checks, and data delivery workflows.

Requirements

• 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 is a plus for data extraction, automation, QA, or reporting workflows.
• Strong attention to detail, especially for legal, compliance, financial, or executive-level reporting.
• Excellent written and verbal communication skills.

Technologies

• SQL
• Snowflake
• Excel
• Sigma Computing
• Python

Benefits

• 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: $130,000 to $165,000 per year (based on experience) plus bonus.

Location: Milpitas, CA (onsite)