Data Engineer II

DailyPay; New York (NY); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Health insurance

Equity ownership

Life/AD&D

Disability insurance

Employee Assistance Program

Employee Resource Groups

Team outings

Unlimited PTO

401K with company match

Job summary

DailyPay is seeking a Data Engineer II to join our Data Engineering Team. You will build and maintain ETL pipelines, design scalable data solutions, and partner with finance, sales, and product to empower analytics across the company.

You will work with SQL across large datasets, cloud platforms (AWS/GCP/Azure), and BI tools to deliver dashboards and reports. DailyPay offers equity, comprehensive benefits, and a collaborative culture.

Qualifications

• 4+ years SQL experience; expert SQL capability
• Experience with data storage architectures (data lakes/lakehouses/warehouses)
• Experience with cloud platforms (AWS/Azure/GCP)
• Experience with large data volumes and scalable models
• Familiarity with BI tools (Tableau/Looker)
• Excellent presentation and communication skills
• Experience with Snowflake/BigQuery
• Familiarity with ETL tools (Fivetran/Stitch)
• Ability to translate technical concepts for non-technical partners

Responsibilities

• Build and maintain company’s ETL and data pipelines
• Design and implement data testing and scaling capabilities
• Maintain and optimize monitoring and alerting for ETL, data warehouse, and analytics infra
• Optimize database performance while reducing warehouse costs
• Participate in code reviews and PRs for analytics engineering
• Produce and maintain data reports, analytics, metrics and dashboards

Skills

SQL

Cloud platforms

BI tools

Data modeling

Communication skills

Data warehouses

ETL tools

Tools

Fivetran/Stitch

dbt

Snowflake

BigQuery

Airflow

Job description

About Us

DailyPay is transforming the way people get paid. As a worktech company and the industry’s leading on demand pay solution, DailyPay uses an award-winning technology platform to help America’s top employers build stronger relationships with their employees. This voluntary employee benefit enables workers everywhere to feel more motivated to work harder and stay longer on the job while supporting their financial well-being outside of the workplace.

About Us

DailyPay is transforming the way people get paid. As a worktech company and the industry’s leading on demand pay solution, DailyPay uses an award-winning technology platform to help America’s top employers build stronger relationships with their employees. This voluntary employee benefit enables workers everywhere to feel more motivated to work harder and stay longer on the job while supporting their financial well-being outside of the workplace. DailyPay is headquartered in New York City, with operations throughout the United States as well as in Belfast. For more information, visit DailyPay's Press Center.

The Role

DailyPay is looking for a Data Engineer II to join our Data Engineering Team. The Data Engineering Team is responsible for building the data infrastructure that underpins our data analytics and data products that are used cross-functionally inside the company (finance, sales, marketing, operations, engineering, etc.) as well as by DailyPay partner companies. The team also ingests internal and external data to help provide insights about the payroll industry in general, as well as about personal finance and financial wellbeing.

How You Will Make An Impact

• Build and maintain company’s ETL and data pipelines
• Design and implement data testing and scaling capabilities
• Maintain and optimize monitoring and alerting for company’s ETL and data pipelines, data warehouse, and analytics infrastructure
• Optimize database performance while reducing warehouse costs and development times
• Participate in code approvals and PR review process for company-wide analytics engineering efforts
• Produce, support and maintain data reports, analytics, metrics and dashboards for internal and external use

What You Bring To The Team

• 4+ years SQL experience; expert SQL capability
• Interest in utilizing AI to develop more efficient systems, improve proactive alerting, and optimize query performance
• Experience in data storage architectures, including dimensional models, data lakes, data lakehouses, and data warehouses
• Experience working in an event-driven architecture and cloud platforms (e.g. AWS, Azure, GCP)
• Experience working with large volumes of data, making models performant and scalable
• Familiarity with BI tools (e.g Tableau, Looker, or similar)
• Excellent presentation and communication skills
• Experience with MPP data warehouses, such as Snowflake or BigQuery.
• Familiarity with ETL tools, such as Fivetran or Stitch
• Ability to reverse-engineer legacy reports and rebuild them into structured, automated solutions
• Excellent skills in explaining technical data concepts to non-technical finance and operations partners

Nice To Haves

• Familiarity with Python, Go, or similar languages for custom data processing and automation
• 1+ years of experience with dbt (Data Build Tool), including implementing data quality checks and testing frameworks
• Experience working with financial/accounting data or platforms such as NetSuite, Sage, or similar ERP systems
• Experience with CI/CD, automated releases, and orchestration tools like Airflow
• Familiarity with reverse ETL tools (e.g., Hightouch or Census) to push data from the warehouse into business applications

What We Offer

• Exceptional health, vision, and dental care
• Opportunity for equity ownership
• Life and AD&D, short- and long-term disability
• Employee Assistance Program
• Employee Resource Groups
• Fun company outings and events
• Unlimited PTO
• 401K with company match

High-performing cultures aren't built in silos, they thrive on partnership. At DailyPay, we Commit Together to an inclusive, professional environment where multifaceted perspectives are our greatest competitive advantage. We recognize that our team members don't live "single-issue lives," and we lean into the wide-ranging backgrounds and life stages that sharpen our collective decision-making. In our high-trust environment, we empower you to Challenge Norms. We've created a space where it is safe to ask difficult questions, disrupt the status quo, and share bold perspectives without fear of professional fallout. We believe that by checking our own assumptions and staying curious about the experiences of others, we arrive at better, more innovative results. We provide the space for you to do your best work through peer advocacy and transparent career development. If you are looking for a culture that values intellectual honesty, celebrates the unique lived experiences of its people, and thrives on collective success, you'll find it here. If you require reasonable accommodation for any aspect of the recruitment process, please send a request to [e-mail]. All requests for accommodation will be addressed as confidentially as practicable. DailyPay is an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion or creed, alienage or citizenship status, political affiliation, marital or partnership status, age, national origin, ancestry, physical or mental disability, medical condition, veteran status, gender, gender identity, pregnancy, childbirth (or related medical conditions), sex, sexual orientation, sexual and other reproductive health decisions, genetic disorder, genetic predisposition, carrier status, military status, familial status, or domestic violence victim status and any other basis protected under federal, state, or local laws.