Description

You design, build, and maintain ETL/ELT pipelines across multiple systems while administering database environments for development, staging, and production.

This role is on-site.

Responsibilities

• Design and optimize data models in PostgreSQL, MongoDB, and Amazon Redshift.
• Develop and manage data workflows using AWS services including S3, Glue, Lambda, Step Functions, and Kinesis.
• Monitor data pipelines and databases, troubleshoot issues, and implement alerts for performance and availability.
• Manage database provisioning, upgrades, backups, and disaster recovery across relational and NoSQL systems.
• Ensure database security through access control, encryption, and role management, and enforce data retention policies.

Required Skills

• 3–5 years of experience in data engineering or database administration.
• Strong proficiency with PostgreSQL, MongoDB, and Amazon Redshift.
• Solid SQL skills for both transactional and analytical workloads.
• Experience with AWS data services (S3, Glue, Lambda, RDS, Redshift).
• Proficiency in Python or another scripting language.
• Hands-on database administration experience including MongoDB replica sets/sharding, Redshift cluster management, and PostgreSQL replication.
• Experience with workflow orchestration tools such as Airflow or Step Functions.

Preferred Skills

• Experience with Kafka or Kinesis for streaming data.
• Familiarity with dbt for data transformation and Terraform or CloudFormation.
• Knowledge of data lake architectures and CI/CD for data pipelines.

Key Skills

Education

Bachelor's degree