Data Engineer: Snowflake, dbt & Finance Data

Agero, Inc.; Medford (MA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health insurance

401(k) plan with company match

Tuition assistance

Flexible time off

Parental planning

Job summary

Agero, Inc. is seeking a Data Engineer who loves data and wants to impact analytics.

You will design, build, and maintain the core data infrastructure powering our analytics, collaborating with product, engineering, and business teams to translate our operational model into scalable data solutions. A major focus is finance data modeling, managing data integrations for our ERP system (EBS) and driving the migration to Workday, with emphasis on code reuse, governance, RBAC, and CI/CD to deliver

Qualifications

• Bachelor’s degree in a technical field and 3-5 years of industry experience.
• Extensive experience with Snowflake and proven expertise in designing scalable data solutions in AWS.
• Deep expertise in dbt Core, Medallion architecture principles, dimensional modeling techniques, and complex data transformations.
• Proven experience with finance data modeling and a strong understanding of enterprise ERP systems (experience with Oracle EBS and/or Workday is highly preferred).
• Strong understanding of data governance, security protocols, and RBAC to securely handle and protect sensitive enterprise financial data.
• Advanced SQL skills for querying databases and proficiency in Python for data processing.
• Familiarity with version control systems (e.g., Git) and implementing CI/CD pipelines for safe, automated deployments.
• Strong communication skills with the ability to explain technical concepts to both technical and non-technical audiences.

Responsibilities

• Develop and maintain robust ETL/ELT pipelines focused on our core stack of Snowflake and AWS.
• Build modular, scalable data models using dbt Core, designing a Medallion architecture (Bronze, Silver, Gold) that transforms raw ingestion feeds into curated, business-ready data marts.
• Work cross-functionally with business stakeholders to understand source systems and downstream consumption needs, translating complex financial workflows into reliable data solutions.
• Write reusable, efficient, and scalable code in Python and SQL.
• Enforce strict data governance and security best practices, including implementing RBAC across pipelines to protect critical financials and ensure compliance.
• Implement data quality control by establishing automated testing frameworks, data observability, and comprehensive documentation to ensure safe data democratization.
• Monitor cloud costs by analyzing resource usage and performing query optimization in Snowflake.

Skills

SQL

Python

Data modeling

Communication

Data governance

RBAC

Git

Education

Bachelor’s degree in a technical field

Tools

Snowflake

AWS

dbt Core

Workday

Oracle EBS

CI/CD

Job description

Agero, Inc. is seeking a Data Engineer who loves data and wants to impact analytics.

You will design, build, and maintain the core data infrastructure powering our analytics, collaborating with product, engineering, and business teams to translate our operational model into scalable data solutions. A major focus is finance data modeling, managing data integrations for our ERP system (EBS) and driving the migration to Workday, with emphasis on code reuse, governance, RBAC, and CI/CD to deliver