Data Engineer II

DailyPay

Data Engineer II building scalable ETL and analytics infrastructure for DailyPay, an on-demand pay platform. Optimizing data systems, warehouses, monitoring, and reporting for internal teams and partner companies.

Posted 8/17/2026full-timeNew York City • New York • 🇺🇸 United StatesMid-LevelSenior💰 $120,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining ETL and data pipelines, optimizing database performance, and implementing data testing and scaling capabilities. Proficient in SQL, data warehousing, and analytics tools, with strong communication skills to convey technical concepts to non-technical stakeholders.

Highest-signal resume keywords

Expert SQL CapabilityETL Tools ExperienceData Warehouse OptimizationBI Tools FamiliarityCloud Platforms Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData WarehousingETLDimensional ModelsData LakesData LakehousesEvent-Driven ArchitectureData Quality ChecksPythonGo

Soft Skills

Excellent Presentation SkillsCommunication Skills

Tools & Technologies

AWSAzureGCPTableauLookerSnowflakeBigQueryFivetranStitchAirflow

Industry Keywords

Financial DataERP PlatformsPayroll IndustryPersonal FinanceFinancial Wellbeing

Tech Stack

Tools & technologies

AirflowAWSAzureBigQueryCloudERPETLGoGoogle Cloud PlatformPythonSQLTableau

About the role

Key responsibilities & impact

Build and maintain the company’s ETL and data pipelines
Design and implement data testing and scaling capabilities
Maintain and optimize monitoring and alerting for 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 for company-wide analytics engineering efforts
Produce, support, and maintain data reports, analytics, metrics, and dashboards for internal and external use
Build data infrastructure supporting analytics and data products used by finance, sales, marketing, operations, engineering, and DailyPay partner companies
Ingest internal and external data to provide insights about the payroll industry, personal finance, and financial wellbeing
Reverse-engineer legacy reports and rebuild them into structured, automated solutions
Explain technical data concepts to non-technical finance and operations partners

Requirements

What you’ll need

4+ years of SQL experience with expert SQL capability
Interest in using AI to develop efficient systems, improve proactive alerting, and optimize query performance
Experience with dimensional models, data lakes, data lakehouses, and data warehouses
Experience with event-driven architecture and cloud platforms such as AWS, Azure, or GCP
Experience working with large data volumes and making models performant and scalable
Familiarity with BI tools such as 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 structured, automated solutions
Ability to explain technical data concepts to non-technical finance and operations partners
Familiarity with Python, Go, or similar languages for custom data processing and automation
1+ years of experience with dbt, including implementing data quality checks and testing frameworks
Experience with financial/accounting data or ERP platforms such as NetSuite or Sage
Experience with CI/CD, automated releases, and orchestration tools such as Airflow
Familiarity with reverse ETL tools such as Hightouch or Census
Ability to work in or commute to the New York office, or willingness to relocate
Legal authorization to work in the United States

Benefits

Comp & perks

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
Inclusive, professional environment
Transparent career development
Reasonable accommodation for any aspect of the recruitment process