Key Responsibilities

· Analyze & monitor existing infrastructure, provide suggestions to improve problem areas.

· Extend existing data pipelines within AWS.

· Manage in-flight data transformations.

· Perform data engineering tasks (design, development & testing) from the direction provided by the Data lead.

· Performance tuning of database systems.

· Diagnose and troubleshoot database errors.

· Create and manage database reports, visualizations, and dashboards.

· Create automation for repeating database tasks.

Key Requirements

Data

· 3+ years working with SQL and PL/pgSQL .

· 3+ years of experience with data design, development & optimization.

· 3+ years working with PostgreSQL Databases & psql, ideally within a managed cloud setting (AWS RDS, GCP, Azure).

· 3+ years of experience maintaining & monitoring database hosting, infrastructure, costs.

Data Automation

· 3+ years working with data pipelines & continuous data syncing.

· 3+ years of experience working with automated data solutions (code first data approach).

Agile

· 3+ years of experience working in an agile software development environment, leveraging scrum or kanban.

· 3+ years of experience working with git and open-source development.

Nice to haves

· Familiarity with AWS RDS, Aurora, Atlas.

· Experience with event driven architectures.

· Familiarity with Five Tran, AWS Glue or a similar data pipeline tool.

· Familiarity with React.

· Familiarity with Node.js & GraphQL.

· Familiarity with Lambda.

· Familiarity with Docker.

· Familiarity with GCP, Azure and other major cloud providers.