About the role

Data Engineer

Job Summary:

OpenGov is seeking a high-ownership, solution-oriented Data Engineer to join our Data Platform team. This role involves hands-on work with dbt for data modeling and transformation, supporting decision-making across the organization while taking end-to-end ownership of data pipeline development through CI/CD practices.

Key Responsibilities:

Engage with stakeholders across Analytics, Operations, GTM, and G&A to understand problem statements and translate them into clear data requirements.
Design and build dimensional and analytical data models in Snowflake utilizing dbt to create a single source of truth for business domains.
Develop, test, and maintain dbt models following best practices, including modular layering, documentation, and data tests.
Optimize SQL queries and dbt models for performance, leveraging Snowflake features such as clustering and materialization strategies.
Orchestrate and schedule dbt jobs, ensuring reliability, observability, and adherence to SLAs.
Manage CI/CD workflows for dbt and pipeline deployments using GitHub Actions, encompassing automated testing, linting, and environment promotion.
Implement data quality checks and perform exploratory data analysis to validate source data and identify anomalies proactively.

Requirements:

Bachelor's degree in Computer Science, Mathematics, Engineering, Statistics, or a related field.
4–6 years of experience in data engineering, backend engineering, or a similar role.
Proficiency in building and maintaining dbt projects in a data warehouse, preferably Snowflake.
Experience with CI/CD pipeline development (GitHub Actions preferred) for automated testing and deployment.
Strong understanding of dimensional modeling techniques and ability to design robust data models.
Hands-on experience with core AWS services, such as S3, Lambda, and IAM.
Advanced SQL skills for executing complex transformations and data manipulations.

Preferred Qualifications:

Familiarity with Terraform or other Infrastructure as Code (IaaC) tools for cloud resource provisioning.
Experience in conducting discovery sessions with business stakeholders to translate analytical problems into structured data models.
Exposure to workflow orchestrators like Airflow, Dagster, or Prefect.
Knowledge of dbt Mesh concepts or multi-project dbt architectures.
Experience with data ingestion tools such as Fivetran, Airbyte, or AWS Glue, and familiarity with BI tools like Tableau or Looker.

Benefits:

Competitive salary and performance-based bonuses.
Comprehensive health, dental, and vision insurance plans.
Flexible work hours and remote work options to support work-life balance.
Professional development opportunities, including training and certifications.
Generous paid time off policies, including holidays and sick leave.
Collaborative and inclusive company culture with a focus on innovation.
Employee stock options to contribute to long-term growth and success.