Big Data Engineer

Posted An Hour Ago
Easy Apply
14 Locations
Remote or Hybrid
120K-150K Annually
Mid level
Automotive • Big Data • Insurance • Software • Transportation
As the B2B industry leader, we are reimagining how to deliver support to drivers at ever step of vehicle ownership.
The Role
Designs, builds, and maintains scalable ETL/ELT pipelines and finance data models using Snowflake, AWS, dbt Core, Python, and SQL. Develops Medallion architecture data marts, integrates ERP systems, and partners with stakeholders on financial workflows. Implements data governance, RBAC, automated quality testing, observability, documentation, CI/CD, and secure deployments. Monitors Snowflake costs and optimizes queries while supporting Oracle EBS integrations and the migration to Workday.
Summary Generated by Built In
About Agero:Wherever drivers go, we’re leading the way. Agero’s mission is to rethink the vehicle ownership experience through a powerful combination of passionate people and data-driven technology, strengthening our clients’ relationships with their customers. As the #1 B2B, white-label provider of digital driver assistance services, we’re pushing the industry in a new direction, taking manual processes, and redefining them as digital, transparent, and connected. This includes: an industry-leading dispatch management platform powered by Swoop; comprehensive accident management services; knowledgeable consumer affairs and connected vehicle capabilities; and a growing marketplace of services, discounts and support enabled by a robust partner ecosystem. The company has over 150 million vehicle coverage points in partnership with leading automobile manufacturers, insurance carriers and many others. Managing one of the largest national networks of service providers, Agero responds to approximately 12 million service events annually. Agero, a member company of The Cross Country Group, is headquartered in Medford, Mass., with operations throughout North America. To learn more, visit https://www.agero.com/.

Note: For our technical positions, we love to get you started in person! You may be required to travel to Medford for your initial onboarding. Don't worry about the logistics - once you're hired, we handle all travel arrangements and expenses for you.

Role Description and Mission:

Agero is seeking a Data Engineer who is passionate about data and eager to make a meaningful impact. You will design, build, and maintain the core data infrastructure that powers our analytics. In this role, you will collaborate directly with product, engineering, and business professionals to deeply understand our operational business model and translate it into effective data solutions. A major focus of this role will be supporting our finance data modeling, specifically managing data integrations for our current ERP system (EBS) and driving the upcoming migration to Workday. We are looking for an engineer who prioritizes code reusability, scalable architecture, data governance, and CI/CD best practices to deliver reliable, high-quality, and secure data.

Key Outcomes

  • 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, Education and Experience:

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

Hiring In:

  • United States: Arizona, California, Florida, Georgia, Illinois, Massachusetts, Michigan, New Hampshire, New York State, New Mexico, North Carolina, Tennessee, Virginia

The anticipated closing date to submit applications for this role is October 1, 2026. Join our Greenhouse Candidate Portal to track your application status and receive instant alerts for future openings.

The base salary range presented represents the anticipated low and high end salary range for new hires in this position. Your final base salary will be determined based on factors such as work location, experience, job related skills, and relevant training and education. The range listed is just one component of the total compensation package provided by Agero to employees.

National Pay Range
$120,000$150,000 USD

Life at Agero:

At Agero, you'll find a workplace where your unique perspective is not just welcomed, it's celebrated. We believe that our differences make us stronger, and we're committed to creating an environment where every employee feels a sense of belonging. If you're looking for a company that values your individuality, provides opportunities for growth, and champions open communication, Agero is the place for you. Join our team and help us drive the future of driver assistance, while experiencing a workplace where you can truly thrive.

Benefits Built for Well-being: 

Agero’s innovation is driven by a workforce where all associates feel like they can truly thrive. Agero offers a wide range of benefits to promote well-being, encourage personal development, and ensure financial stability. Our benefits include:

  • Health and Wellness: Healthcare, dental, vision, disability, life insurance, and mental health benefits for associates and their families.
  • Financial Security: 401(k) plan with company match and tuition assistance to support your future goals.
  • Work-Life Balance: Flexible time off, paid sick leave, and ten paid holidays annually.
    • For Contact Center Roles: Accrual of up to 3 weeks Paid Time Off per year, paid sick leave, and ten paid holidays annually.
  • Family Support: Parental planning benefits to assist associates through life’s milestones.
  • Bonus/Incentive Programs

Join Agero and experience a workplace that invests in your success both personally and professionally.

*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.

*It is unlawful in Massachusetts to required or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Skills Required

  • Bachelor's degree in a technical field
  • 3-5 years of industry experience
  • Extensive experience with Snowflake
  • Expertise designing scalable data solutions in AWS
  • Deep expertise in dbt Core
  • Experience with Medallion architecture principles
  • Experience with dimensional modeling techniques and complex data transformations
  • Experience with finance data modeling
  • Strong understanding of enterprise ERP systems
  • Experience with Oracle EBS and/or Workday
  • Strong understanding of data governance and security protocols
  • Experience implementing role-based access control (RBAC)
  • Advanced SQL skills
  • Proficiency in Python for data processing
  • Familiarity with version control systems such as Git
  • Experience implementing CI/CD pipelines
  • Strong communication skills for technical and non-technical audiences
  • Current authorization to work full-time in the United States without employer visa sponsorship

What the Team is Saying

Pierre
Shana
Thea
Dom
Mercedes
Richard
Myea
Vishakha
Roschelle
Jeff
Agero
Agero
Agero

Agero Compensation & Benefits Highlights

  • Healthcare Strength Medical, dental, and vision coverage are company‑subsidized with added HSA/FSA options plus no‑cost second‑opinion and advocacy services, indicating robust core health support. Mental‑health resources and employer‑paid life/disability further strengthen the package.
  • Retirement Support A matching 401(k) administered through Fidelity is a clear pillar of the offering, complemented by life and disability protections. This combination supports long‑term financial security beyond base pay.
  • Leave & Time Off Breadth Flexible time off, immediately accruing PTO, company and floating holidays, and wellness days are emphasized. Remote and hybrid options help employees take time when needed.

Agero Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Medford, MA
1,600 Employees
Year Founded: 1972

What We Do

Agero is a leading provider of driver assistance, accident management, consumer affairs support and connected vehicle services for stakeholders across the automotive industry, including the world’s largest automakers, auto retailers, insurers, rideshare providers and other brands. As the driving force behind mobility support throughout all points in the vehicle ownership journey - from purchase to maintenance and breakdown to resell or trade in - we deliver a suite of powerful, innovative services and technology solutions that enable our 100+ clients to provide their drivers with enhanced communication, safety, and convenience for whatever their vehicle need.

Why Work With Us

At Agero, our solutions help drivers when they need it most. Our work directly impacts the lives of over 12 million people each year, providing safety and peace of mind. We offer a unique career environment that combines the spirited energy of a fast-paced team with the stability of an established leader. Here you transform the road ahead and shap

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Agero Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Balancing work and life is a priority and productivity looks different for everyone. Our hybrid policy allows employees to work however they work best

Typical time on-site: Flexible
Company Office Image
HQMedford, MA
Corporate HQ is located in Medford, MA, on the banks of the Malden River, with picturesque views of public parks, walking trails and the beautiful Tufts University boathouse. We're walking-distance to public transport, with close access to I-93, restaurants, Assembly Row shopping center & downtown.

Similar Jobs

Agero Logo Agero

Cybersecurity Governance Analyst

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
14 Locations
1600 Employees
75K-95K Annually

Agero Logo Agero

Senior Machine Learning Engineer

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
14 Locations
1600 Employees
134K-181K Annually

Agero Logo Agero

Corporate Strategy Associate

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
14 Locations
1600 Employees
90K-110K Annually

Agero Logo Agero

Senior Manager, Learning and Development

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
14 Locations
1600 Employees
100K-134K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account