Big Data Engineer

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

Requirements:

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