Data and Analytics Engineer

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

Benefits offered by this job

Health, dental, and vision insurance

401(k) traditional & Roth with company

Unlimited paid time off

Gym reimbursement

Tuition assistance

Job summary

Payactiv, Inc. is seeking a hands-on Data and Analytics Engineer in Milpitas, CA to deliver reliable business reporting, dashboards, and data workflows. You will write SQL for Snowflake, build curated datasets, and partner with stakeholders to define data solutions for actionable insights.

You will maintain BI dashboards, data visualizations, and self-serve tools to scale analytics across the company, while validating data accuracy and delivering timely data extracts for business use.

Qualifications

• Bachelor’s degree in a related field is required.
• 4+ years of data analytics engineering, BI, or data engineering.
• Strong SQL with complex joins, CTES, and window functions.
• Experience with Snowflake or another cloud data warehouse.
• Proficient Excel skills for large CSV/data extracts.
• Experience with BI/dashboarding tools; Sigma Computing is a plus.
• Ability to validate data accuracy and explain data logic to stakeholders.

Responsibilities

• Write, optimize, and maintain SQL queries against Snowflake data warehouse.
• Build curated datasets, views, and reporting tables for business reporting and analytics.
• Partner with stakeholders to gather requirements and define data solutions.
• Create scalable data sources and products for reliable insights and lists.
• Lead development of self-serve tools to scale analytics across the company.
• Validate data pulls, reports, and dashboards by reviewing logic and definitions.
• Share reporting results with internal stakeholders and leadership.
• Prepare data extracts, Excel-based reports, and lists for business use.
• Monitor data quality and consistency across environments.
• Collaborate cross-functionally with Engineering, Data Scientists, BI, and Growth teams.

Skills

SQL

Snowflake

Excel

Python

BI dashboards

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field

Tools

Sigma Computing

Job description

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)