Data Engineer II

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 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 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 Lakehouses 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 BigQuery Fivetran Stitch Airflow #J-18808-Ljbffr Jobtailor