Data and Analytics Engineer

Role Overview

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.

What You Will Do

Write, optimize, and maintain SQL queries against the Snowflake data warehouse, build and maintain curated datasets, views, and reporting tables, and partner with business stakeholders to gather requirements and define data solutions.

Why It Might Be a Fit

The ideal candidate has strong SQL skills, experience working with cloud data warehouses, and the ability to partner directly with business teams.

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.
• Ability to validate data accuracy, troubleshoot reporting discrepancies, and explain data logic to technical and non-technical stakeholders.

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.