Data Engineer

Agero, Inc.

Agero, Inc. is transforming the vehicle ownership experience using passionate individuals and data-led technology. As a leader in B2B driver assistance services, Agero aims to innovate through advanced digital solutions. The company collaborates with major automotive manufacturers and insurance firms, managing numerous service events across North America.

In this role you can expect to have the responsibilities:

• Design and maintain ETL/ELT pipelines for data ingestion.
• Optimize cloud costs and perform query optimization in Snowflake.
• Develop modern data architectures with a focus on alignment with business needs.
• Apply data modeling techniques for effective data transformation.
• Write efficient code in Python, PySpark, and SQL.
• Ensure data quality and implement observability solutions.
• Collaborate with cross-functional teams to deliver advanced data solutions.

This role comes with the following benefits:

• Comprehensive healthcare, dental, and vision plans.
• 401(k) plan with company match.
• Flexible time off and paid holidays.
• Parental planning benefits.
• Bonus and incentive programs.

This role requires you to have:

• Expertise with Snowflake or similar cloud-based data warehousing.
• Experience in building ETL/ELT pipelines with tools like Airflow, DBT.
• Proficiency in Python for data processing.
• Advanced SQL skills for database management.
• Knowledge of data modeling and query optimization techniques.

You would benefit from having:

• Experience with data streaming platforms like Kafka.
• Familiarity with Agile methodologies and IaC tools.

Agero emphasizes diversity and inclusion, supporting applicants with disabilities during recruitment. The company encourages a culture where differences are celebrated, promoting innovation and community.