Analytics Engineer Intern at Cambridge… · Massachus…

Summary: Cambridge Mobile Telematics (CMT) is the world's largest telematics service provider, dedicated to making roads safer. As an Analytics Engineer Intern, you will collaborate with the IoT and Data Engineering teams to build data pipelines, design data models, and deliver analytics that support decision-making for device health and driver behavior. Responsibilities: - Design and build data pipelines to ingest, transform, and model telematics and IoT device data at scale - Develop and maintain data models using SQL and tools such as dbt or Spark to support analytics use cases - Create dashboards and self-service reporting for IoT Operations and Product Analytics stakeholders - Collaborate with engineers and product managers to define KPIs, metrics, and data requirements - Investigate data quality issues and implement validation checks to ensure reliable outputs - Leverage AI coding assistants (e.g., Cursor, Claude Code) to accelerate pipeline development, code review, and debugging - Structure and document data models so they are interpretable by AI assistants, enabling stakeholders to query device and driver data in natural language - Document data assets, transformation logic, and analytical methodologies - Complete any additional tasks as they arise Required Qualifications: - Currently pursuing a Master's degree in Computer Science, Data Science, Statistics, or a related quantitative field - Strong proficiency in SQL; experience with Python is a plus - Familiarity with data warehousing or cloud data platforms (e.g., Databricks, Redshift, BigQuery, or Snowflake) - Exposure to data transformation tools (e.g., dbt) or big data frameworks (e.g., Spark) is a plus - Experience with data visualization tools (e.g., Tableau) is a plus - AI-curious mindset — excited about using AI tools to work faster and smarter, and comfortable experimenting with LLM-powered workflows in a professional environment - Ability to work independently and communicate findings clearly to both technical and non-technical audiences Required Skills: SQL, Python, Data warehousing, Cloud data platforms, Databricks, Redshift, BigQuery, Snowflake, Data transformation tools, dbt, Big data frameworks, Spark, Data visualization tools, Tableau Benefits: Fair and competitive hourly rate based on education level, Flexible scheduling options depending on role and responsibilities, Feel great working to improve road safety around the world!, CMT will do all that is possible to support our employees and create a positive and inclusive work environment for all!