Data Engineer

Root is on a mission to transform insurance with technology. Root is a cutting‑edge, API‑first technology company at the forefront of the revolutionary changes happening in insurance. Our mission is to make insurance more accessible by providing the technology and expertise that enable digital transformation. We're a team of dedicated professionals who are committed to challenging the status‑quo one API at a time. As part of the billing squad at Root, your mission is to build and maintain reliable, scalable, and high‑performance data infrastructure that supports the billing processes. You will ensure accurate, timely, and efficient data pipelines to enable billing, reporting, and analytics. This includes automating manual processes, improving data quality, and providing access to data for internal teams. Your efforts will drive critical business functions such as billing, client insights, and financial reporting. What you’ll do Design, implement, and maintain custom data pipelines for billing data ingestion, transformation, and delivery. Ensure billing data is processed accurately, timely, and reliably, supporting downstream processes such as reporting and analytics. Monitor and troubleshoot pipelines, identifying and resolving data discrepancies or issues in real‑time. Continuously automate routine billing processes, such as monthly imports and finance scripts for month‑end reporting. Ensure automation improves accuracy and reduces manual intervention in critical billing workflows. Build tools to enable self‑service data access for internal teams (e.g., finance, client operations) to reduce dependencies on engineering. Implement data validation, quality checks, and monitoring systems to ensure data accuracy and completeness. Identify bugs and discrepancies in billing data and escalates them to the Product team for resolution. Adhere to data governance standards, ensuring compliance with Root's internal policies and industry regulations. Collaborate with product and engineering teams to ensure billing systems and processes align with Root's broader technical ecosystem. Provide data support for operational and finance teams, fulfilling internal data requests efficiently. Serve as a point of contact for resolving billing‑related data anomalies and client queries. Lead efforts to ensure client reports are accurate, delivered on time, and meet client requirements. Provide clients with data‑driven insights and reports that add value to their understanding of billing and operational metrics. Act as the technical expert for Root's clients in the billing domain, resolving any data‑related issues. Manage the data migration processes, ensuring data is clean, validated, and accurately moved between systems. Support book moves and data migrations from a data engineering perspective, ensuring smooth transition and integrity of data. Qualifications SQL expertise – advanced ability to write optimised queries for large and complex datasets. Python proficiency – experience building data pipelines, automating processes, and working with APIs. ETL development – skilled in designing scalable ETL workflows, ideally across billing, reporting, or client‑facing data systems. Data warehousing & ecosystem mindset – familiar with optimizing data warehouses and building integrations into enterprise CRMs or BI systems. Cloud platforms – working knowledge of AWS (Lambda, Athena, S3, Glue). Reporting & visualisation – proficiency in building dashboards and automated reporting systems (Tableau, Looker, or similar). Automation tools Exposure to workflow orchestration frameworks like Airflow, dbt, or AWS Glue for pipeline automation. Problem‑solving Proven ability to troubleshoot pipeline issues, ensure data accuracy, and improve efficiency through automation. Collaboration & client focus Strong communicator who can bridge technical and non‑technical teams, with a client‑first mindset for delivering high‑quality insights. Experience 2–4 years in data engineering or similar, ideally with exposure to financial, billing, or client‑facing data systems. Root values Lead by example – "Lean in, take charge, and always set a positive precedent." Exceed expectations – "Know your customer to delight your customer." Rally as one team – "Put aside egos and personal agendas to triumph as one." Own the mission – "Your job is not done until the job is done." Rise to the challenge – "Meaningful change requires meaningful effort and the courage to make bold moves." How we enable success – Our team is made up of smart, passionate, and kind individuals working together to build a world‑class business. We take the time to develop personal relationships with each other. Over and above daily team lunches, we do frequent team outings and ad‑hoc adventures (when global pandemics permit). We create and enable an environment for people to do their best work. We encourage each other and foster a working culture of sharing early versions of our work and implementing feedback fast. Why join us? We have ambitious goals. Our mission is to transform insurance, globally, and we're making solid progress in South Africa and the UK. Your contribution will directly and visibly impact Root's continued success and expansion. Our team is incredibly friendly and collaborative. If you care about solving challenging problems with smart people you enjoy being around, this is the place for you. Please note… Open positions at Root are competitive and we often receive high volumes of applicants. If you have not received further updates on your application after three weeks, you're welcome to request feedback. #J-18808-Ljbffr