Big Data Engineer
Job Description
<div class="content-intro"><h4><strong>About Agero:</strong></h4> <h4><span style="font-weight: 400;">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 <a href="https://www.agero.com/">https://www.agero.com/</a>.</span></h4> <p><span style="font-weight: 400;"><strong>Note: </strong></span><strong>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.</strong></p></div><p><span style="font-size: 12pt;"><strong><span style="font-family: helvetica, arial, sans-serif;"><span style="text-decoration: underline;">Role Description and Mission</span>:</span></strong></span></p> <p><span style="font-size: 12pt;">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.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 12pt;"><strong><span style="text-decoration: underline;">Key Outcomes</span></strong>: </span></p> <ul> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Develop and maintain robust ETL/ELT pipelines focused on our core stack of Snowflake and AWS.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">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.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Work cross-functionally with business stakeholders to understand source systems and downstream consumption needs, translating complex financial workflows into reliable data solutions.</span></li> <li style="font-size: 12pt;"><span style="font-size: 12pt;">Write reusable, efficient