Big Data Engineer

Agero, Inc. provides digital driver assistance services powered by data-driven technology. The Big Data Engineer will design, build, and maintain data infrastructure and pipelines supporting analytics and finance data modeling, including integrations with Oracle EBS and migration to Workday. The role also focuses on scalable architecture, data governance, security, data quality, and cloud cost optimization.

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