Finance Data Engineer - Snowflake, dbt & AWS

OpenKrill; United States; Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health & Wellness benefits

401(k) with company match

Flexible time off

Parental planning

Bonus programs

Job summary

Agero is seeking a Data Engineer to design, build, and maintain core data infrastructure powering analytics. You will collaborate with product, engineering and business teams to translate operational models into reliable data solutions focused on ERP integrations and Workday migration.

Responsibilities include building scalable pipelines, applying data governance, and delivering secure, well-documented data assets with cost-conscious cloud usage.

Qualifications

• Bachelor's degree in a technical field and 3–5 years of industry experience.
• Deep expertise in Snowflake and designing scalable data solutions in AWS.
• Proficient in dbt Core, Medallion architecture, dimensional modeling, and complex data transformations.
• Experience with finance data modeling and enterprise ERP systems (Oracle EBS/Workday preferred).
• Strong understanding of data governance, security and RBAC.

Responsibilities

• Develop and maintain ETL/ELT pipelines on Snowflake and AWS.
• Build modular data models using dbt Core with Medallion architecture (Bronze/Silver/Gold).
• Collaborate with stakeholders to translate financial workflows into data solutions.
• Write reusable, efficient Python and SQL code.
• Enforce data governance, RBAC and security best practices across pipelines.
• Establish automated data quality tests, observability and documentation.
• Monitor Snowflake costs and optimize query performance.

Skills

Python

SQL

Data governance

CI/CD

Git

Communication

RBAC

Education

Bachelor's degree in a technical field

Tools

Snowflake

AWS

dbt Core

Medallion architecture

Oracle EBS

Workday

Job description

Agero is seeking a Data Engineer to design, build, and maintain core data infrastructure powering analytics. You will collaborate with product, engineering and business teams to translate operational models into reliable data solutions focused on ERP integrations and Workday migration.

Responsibilities include building scalable pipelines, applying data governance, and delivering secure, well-documented data assets with cost-conscious cloud usage.