Senior Data Engineer

Cambridge Mobile Telematics (CMT) is the world's largest telematics service provider. Its mission is to make the world's roads and drivers safer. The company's AI-driven platform, DriveWell® Fusion, gathers sensor data from millions of IoT devices - including smartphones, proprietary Tags, connected vehicles, dashcams, and third-party devices - and fuses them with contextual data to create a unified view of vehicle and driver behavior. Auto insurers, automakers, commercial mobility companies, and the public sector use insights from CMT's platform to power risk assessment, safety, claims, and driver improvement programs. Headquartered in Cambridge, MA, with offices in Budapest, Chennai, Seattle, Tokyo, and Zagreb, CMT measures and protects tens of millions of drivers across the world every day.

We are seeking an organized, team player, and solution-oriented software engineer to support our Data Analytics and Data Science teams in optimizing our utilization of Redshift, Glue, and other AWS services for building and maintaining a data warehouse. The Senior Data Engineer will be responsible for enhancing data ETL pipelines, designing and managing databases for research and development, supporting the analytical needs for product releases, and taking ownership of data and transformations. The ideal candidate for this role will have prior experience with large-scale ETL pipelines, building scalable, maintainable, and secure backend code, and a strong understanding of fundamental concepts such as unit testing, automation, and continuous delivery.

CMT is looking for a collaborative, customer-committed, and creative Senior Data Engineer who wants to join us in making roads safer by making drivers better!

Responsibilities:

Use independent judgment and discretion to analyze and translate business specifications and change requests from Data Analytics and Data Science into technical specifications
Design and implement data infrastructure with a focus on maintainability, usability, scalability, and performance
Implement and maintain ETL pipelines in SQL and Python with automated testing based on the requirements
Participate in code and design reviews
Provide required support and troubleshoot production; this role will be subject to on-call responsibilities (mainly during business hours, as well as occasional nights and weekends)
Offer expert recommendations on current research to drive scalable and cost-effective solutions
Follow the company's development and operational standards and processes
Complete any additional tasks as they arise
Qualifications:

Bachelor's degree or equivalent years of experience and/or certification in Computer Science, Statistics, Mathematics, Engineering, or Data Science.
4+ years of relevant working experience
Experience working as a Data Engineer or Cloud Engineer with data experience
Expertise in data warehousing and ETLs (e.g. AWS Redshift, AWS Glue, Spark, AWS S3 or equivalent)
Expertise in writing, maintaining, and optimizing analytics SQL queries
Expertise in the software development process and ability to code in scripting languages for data manipulation (e.g. Python, Pandas, NumPy)
Demonstrated experience with database (RDBMS, NoSql, Columnstore) schema design
Hands-on AWS services, Terraform IaC, Containerization, CI/CD experience
System design and documentation skills, including writing and reviewing code to automate away problems within the squad's domain
Understanding of Agile development methodologies (specifically SCRUM)
Ability and willingness to participate in the team's on-call rotation
Experience working to support data analytics and data science teams
Nice to Have:

Experience using Redshift, AWS Glue, EC2, Lambda, RDS (PostgreS), S3, Dynamo
Experience with Docker, CloudFormation, PostgreSQL, Terraform
Experience building scalable data processing systems for production environment
Ability to navigate code, request data from data sources, and code for bug fixes
Actively seeks feedback and resolves discrepancies with senior team members
AWS Certification
Compensation and Benefits:

Fair and competitive salary based on skills and experience
Equity may be awarded in the form of Restricted Stock Units (RSUs)
Medical, Dental, Vision and Life Insurance, matching 401k, short-term & long-term disability and parental leave
Unlimited Paid Time Off including vacation, sick days & public holidays
Flexible scheduling and work from home policy depending on role and responsibilities
Additional Perks:

Feel great working to improve road safety around the world!
Join one of our many employee resource groups including Black, AAPI, LGBTQIA+, Women, Book Club and Health & Wellness
Extensive education and employee assistance programs
CMT will do all that is possible to support our employees and create a positive and inclusive work environment for all!

Commitment to Diversity and Inclusion:

At CMT, we are intensifying our commitment to provide opportunities and career growth to the underrepresented. We are focused on creating an inclusive work environment that encourages a diversity of background and thought to produce the best products and services within our industry.

CMT is an equal opportunity employer and strives to create an inclusive and diverse environment that enriches our employees' lives in and outside of work. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status or disability state. CMT is headquartered in Cambridge MA. To learn more, visit www.cmtelematics.com and follow us on Twitter @cmtelematics.