Qualifications
ResponsibilitiesIdentify and implement improvements in data pipelines, raise quality concerns proactively, and share insights with the team.Build, maintain, and optimize dbt models across staging, intermediate, and mart layers, transforming raw data into refined analytical datasets.Develop and monitor data pipelines using Meltano and Python to ingest data from APIs, databases, and third-party services into Snowflake.Ensure data quality through dbt tests and monitoring, collaborating with Data QA to detect issues before they affect dashboards.Support the company’s data warehouse (Snowflake) by optimizing query performance, managing access controls, and evolving the data architecture as the organization scales.Assist data analysts and product teams in obtaining the necessary data, whether through new dbt models, custom extraction scripts, or data sources for Metabase/Tableau.RequirementsStrong curiosity and a systematic problem-solving approach.Proficient in SQL, capable of writing complex queries involving window functions, CTEs, and aggregations.Working knowledge of Python for data extraction, transformation, and automation.Understanding of data modeling concepts, including star schemas, slowly changing dimensions, and normalization versus denormalization.Familiarity with version control (Git) and code review processes.Intermediate English proficiency to communicate effectively in writing and during calls.Nice-to-have SkillsExperience with data visualization tools such as Metabase or Tableau.Understanding of cloud data warehousing solutions.
About the job
About the Role
Join Matic's rapidly growing Data team as a Junior Data Engineer. Matic is dedicated to simplifying insurance for homeowners across the US. In this role, you will be responsible for engineering our data platform, ensuring effective ingestion, transformation, quality monitoring, and pipeline reliability.
Your primary focus will be on utilizing dbt to build and maintain SQL transformations that drive our analytics and reporting. Additionally, you'll leverage Meltano for data replication. We encourage curiosity and initiative, giving you the freedom to propose innovative solutions and enhance our tech stack.
Collaboration is key; you'll work closely with data analysts, analytics engineers, and product teams to accurately model and ensure the trustworthiness of business metrics, segments, and KPIs.
About Matic
Matic is a forward-thinking company focused on enhancing the insurance experience for homeowners across the United States. Through innovative technology and a commitment to excellence, we strive to simplify and improve the insurance process.