Junior Data Engineer at Matic

About the role We’re looking for a Data Engineer to join Matic’s Data team. Matic is growing rapidly, building products that make insurance easier for homeowners across the US. You’ll own the engineering side of our data platform: from ingestion and transformation to quality monitoring and pipeline reliability. Your primary focus will be dbt – building and maintaining SQL transformations that power our analytics and reporting. But you’ll also work with Meltano for data replication. We value curiosity and initiative: you’ll have the freedom to propose solutions and drive improvements across the stack. You’ll collaborate closely with data analysts, analytics engineers, and product teams to ensure that business metrics, segments, and KPIs are accurately modeled and trustworthy. Responsibilities • Proactively identify improvements in data pipelines, raise data quality concerns early, and share your knowledge with the team — your growth and the team's success go hand in hand. • Build, maintain, and optimize dbt models across staging, intermediate, and mart layers — transforming source data into clean 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, monitoring – working alongside Data QA to catch issues before they reach dashboards. • Support the company’s data warehouse (Snowflake) – optimize query performance, manage access controls, and evolve the data architecture as the business grows. • Help data analysts and product teams get the data they need – whether that’s a new dbt model, a custom extraction script, or a Metabase/Tableau data source. Requirements • Curiosity and a systematic approach to problem-solving – you dig into root causes, not just symptoms. • Solid knowledge of SQL – you can write complex queries with window functions, CTEs, and aggregations without hesitation. • Working knowledge of Python – you can write clean scripts for data extraction, transformation, and automation (not just Jupyter notebooks). • Understanding of data modeling concepts – star schema, slowly changing dimensions, normalization vs. denormalization trade-offs. • Familiarity with version control (Git) and code review workflows. • English Intermediate and above – ability to communicate your ideas clearly in writing and on calls. Nice-to-have skills: • Experience with dbt (dbt-core and dbt Cloud) — building models, defining sources, writing tests, maintaining documentation. • Experience with cloud data warehouse: Snowflake. • Familiarity with EL tool: Meltano. • Basic experience with Docker and containerization concepts. • Awareness of orchestration tools: Airflow. • Exposure to Kubernetes concepts (pods, deployments, jobs, secrets). • Familiarity with BI tools: Metabase, Tableau. Tools we use • Transformation: dbt-core, SQL • Warehouse: Snowflake • Ingestion / EL: Meltano, custom Python scripts • Orchestration: Airflow • Languages: SQL, Python • BI / Reporting: Metabase, Tableau • Infrastructure: Docker, Kubernetes, GitHub Actions, CircleCI, Terraform, Helm What We Offer • Competitive salary and Company Equity with refresher policy every 2 years • Unlimited Paid Time Off (personal, sick, maternity/paternity leave) • Flexible working environment (home/office/hybrid) • Accounting support (100% coverage) • Continuous feedback culture: systematic 1-1 with your manager, performance review meetings every 6 months, and yearly compensation review About Matic The Market Leader in Embedded Insurance: Since 2014, Matic has redefined the insurance landscape by integrating high-value coverage directly into the homeownership and auto-buying journey. We aren't just a digital agency; we are the strategic infrastructure that allows mortgage lenders and financial institutions to provide seamless, value-added services to their customers at the exact moment they need them. Our Market Position: Today, Matic is a Top 20 independent agency and the undisputed leader in the mortgage servicing space, holding approximately 20% of the total market share. Our marketplace features over 60 A-rated home and auto carriers, integrated with a growing roster of billion-dollar distribution partners across mortgage origination, banking, and SaaS. Our Culture: Autonomy and Impact At Matic, we avoid the "numbers for the sake of numbers" mindset. We hire professionals who are obsessed with quality and empowered to own their outcomes. We work at a fast pace, but we prioritize intellectual curiosity, strategic thinking, and the collective win.