Data Engineer

What is the opportunity?

Join our team as a Data Engineer to build modern data infrastructure using Dagster, dbt, and PostgreSQL. You will design and implement scalable ELT pipelines following medallion architecture patterns, while contributing to full-stack development with React and TypeScript. This role offers the opportunity to work at the intersection of data engineering and AI, integrating LLM capabilities into our data products.

What will you do?

• Design and develop data pipelines using Dagster for orchestration, including component-based architecture, YAML-driven asset definitions, sensors, and schedules
• Build and maintain dbt models with incremental materializations, snapshots, macros, and comprehensive testing frameworks
• Implement medallion architecture patterns across Bronze, Silver, and Gold layers to ensure data quality and accessibility
• Develop REST APIs using FastAPI with async endpoints to serve data products to internal and external consumers
• Build responsive frontend interfaces using React 19, TypeScript, and TanStack ecosystem components with TailwindCSS styling
• Integrate AI and LLM capabilities including RAG pipelines, Model Context Protocol, and tool use patterns into data applications
• Manage containerized deployments using Docker and maintain CI/CD workflows through GitHub Actions
• Collaborate with cross-functional teams to understand data requirements and deliver solutions that drive business value

What do you need to succeed?

Must Have

• Strong proficiency in Python and TypeScript for building production-grade applications
• Working knowledge of PostgreSQL for data warehousing and DuckDB for analytical workloads
• Frontend development skills with React for building user interfaces
• Familiarity with Docker containerization, Git version control, and CI/CD pipeline development
• Demonstrated experience designing and implementing ELT pipelines with data quality frameworks

Nice to Have

• Experience with dbt MetricFlow and semantic layer design for metrics definitions
• Experience with Dagster for data orchestration and dbt for data transformation and modelling
• Knowledge of GraphQL, LDAP directory services, and OAuth 2.0 authentication protocols
• Exposure to AI/LLM integration patterns including RAG, Model Context Protocol, and function calling
• Familiarity with the TanStack ecosystem including Query, Router, Table, and Start

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities.