Big Data Engineer

Summary

Agero provides data-driven digital driver assistance services that support the vehicle ownership experience. The Big Data Engineer will design, build, and maintain core data infrastructure for analytics, with a focus on finance data modeling, ERP integrations, and the migration from Oracle EBS to Workday. The role emphasizes scalable data architecture, governance, security, data quality, and CI/CD best practices.

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

• * 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
• * 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
• *Applicants must be currently authorized to work in the United States on a full‑time basis. This position is not eligible for employer visa sponsorship now or in the future.*
• Experience with Oracle EBS and/or Workday is highly preferred

Qualifications

Must Haves

• * 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
• * 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
• *Applicants must be currently authorized to work in the United States on a full‑time basis. This position is not eligible for employer visa sponsorship now or in the future.*

Nice to Haves

• experience with Oracle EBS and/or Workday is highly preferred

Benefits

• Healthcare, dental, vision, disability, life insurance, and mental health benefits for associates and their families.
• 401(k) plan with company match and tuition assistance to support your future goals.
• Flexible time off, paid sick leave, and ten paid holidays annually.
• Parental planning benefits to assist associates through life’s milestones.
• Bonus/Incentive Programs
• Travel arrangements and expenses for initial onboarding in Medford.