Senior Software Engineer – Python, dbt & BigQuery

Tenarai is recruiting for a project involving the development of an open-source plugin that enables data teams to define BigQuery graph databases using configuration files and deploy them through dbt. The project includes semantic and metric modeling research, CI/CD automation, and comparison of competitive products such as Looker, dbt, Snowflake, and Databricks.

• Bachelor’s degree in Computer Science, Software Engineering, or related field, or equivalent practical experience.
• At least 5 years of software development experience.
• Strong proficiency in Python packaging, testing (pytest), and validation.
• Extensive hands-on experience with dbt Core.
• Experience building custom dbt materializations, Jinja macros, and package integrations.
• Strong SQL proficiency including complex aggregations, window functions, and schema modeling.
• Deep production experience with Google Cloud BigQuery.
• Strong analytical skills with ability to research technical specifications and translate into backlog and designs.

Nice to have:

• Hands-on experience with metric/semantic layers such as LookML, dbt MetricFlow, Cube, Snowflake, or Databricks metric features.
• Experience with Property Graph queries, ISO GQL, SQL, or graph database engines.
• Experience with CI/CD tools.
• Experience with declarative schema compilers like YAML/JSON validation via Pydantic.
• Active participation or maintainer status within open-source data communities.

• Research and compare semantic and metric modeling capabilities of Looker, dbt (MetricFlow), Snowflake, and Databricks.
• Deliver a prioritized backlog of BigQuery measure features.
• Build a repository of real-world samples and direct source links.
• Build, publish, and maintain an open-source dbt package library introducing BigQuery Graph as a dbt materialization.
• Develop reference CI/CD pipelines using tools such as GitHub Actions and GitLab CI.
• Create pipelines that parse, validate, and deploy BigQuery graphs defined in declarative YAML formats.
• Create high-quality developer documentation, reference implementations, and tutorials.
• Support community adoption of BigQuery Graphs and Measures.
• Research competitive products and technologies related to semantic and metric modeling.

Must possess a legal work permit in Poland.