Data Engineer II - Build Scalable ETL & Analytics Pipelines

• 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 Daily Pay 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

• 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 lake houses, 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 Big Query
• 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 Net Suite 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

Core Competencies

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 Capability
• ETL Tools Experience
• Data Warehouse Optimization
• BI Tools Familiarity
• Cloud Platforms Experience

ATS Optimization Keywords

Hard Skills

• SQL
• Data Warehousing
• ETL
• Dimensional Models
• Data Lakes
• Data Lake houses
• Event-Driven Architecture
• Data Quality Checks
• Python
• Go

Soft Skills

• Excellent Presentation Skills
• Communication Skills

Industry Keywords

• Financial Data
• ERP Platforms
• Payroll Industry
• Personal Finance
• Financial Wellbeing

Tools & Technologies

• AWS
• Azure
• GCP
• Tableau
• Looker
• Snowflake
• Big Query
• Fivetran
• Stitch
• Airflow