Data Engineer II: Build Scalable ETL & Dashboards (Equity)

DailyPay; New York (NY); On-site; USD 120,000 - 140,000; Full time

Benefits offered by this job

Health, vision, and dental care

Equity ownership

Life and AD&D, short- and long-termDis

Employee Assistance Program

Employee Resource Groups

Fun company outings and events

Unlimited PTO

401K with company match

Job summary

DailyPay is seeking a Data Engineer II to join our Data Engineering Team in New York. You will design and build our ETL pipelines and data infrastructure that power analytics and data products used across finance, sales, marketing, and operations.

This role focuses on optimizing database performance, reducing warehouse costs, and enabling scalable data models. You will implement data quality checks with dbt, work in an event-driven, cloud-based environment (AWS/GCP/Azure), and develop dashboards

Qualifications

• 4+ years SQL experience; expert SQL capability.
• Interest in using AI to develop more efficient systems, improve proactive alerting, and optimize query performance.
• Experience with data storage architectures, including dimensional models, data lakes, data lake houses, and data warehouses.
• 1+ years of experience with dbt (Data Build Tool), including implementing data quality checks and testing frameworks.
• 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 (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.

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 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.

Skills

SQL

AI for optimization

Big data concepts

Data warehousing concepts

Data quality checks

BI tools

Communication

Event-driven architecture

Tools

dbt

AWS/Azure/GCP

Data lakes / lakehouse / data warehouses

Snowflake / BigQuery

Fivetran / Stitch

Airflow

CI/CD tooling

Job description

DailyPay is seeking a Data Engineer II to join our Data Engineering Team in New York. You will design and build our ETL pipelines and data infrastructure that power analytics and data products used across finance, sales, marketing, and operations.

This role focuses on optimizing database performance, reducing warehouse costs, and enabling scalable data models. You will implement data quality checks with dbt, work in an event-driven, cloud-based environment (AWS/GCP/Azure), and develop dashboards