Data Engineer

Job Description:

About the Role:

We're looking for a mid-level Data Engineer & DBA to join our data platform team. You'll build and maintain scalable data pipelines while ensuring our databases are reliable, secure, and high-performing. You'll work closely with analysts, engineers, and product teams to deliver clean and timely data.

What You'll Do:

· Design, build and maintain ETL/ELT pipelines across multiple systems

· Design and optimize data models in PostgreSQL, MongoDB, and Amazon Redshift

· Develop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)

· Administer and maintain database environments across development, staging, and production

· Monitor data pipelines and databases, troubleshoot issues, and implement alerts

· Optimize query performance, indexes, and configurations across relational and NoSQL systems

· Manage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)

· Ensure database security, including access control, encryption, and role management

· Plan capacity and scale systems to support growing data needs

· Define and enforce data retention and archival policies

· Collaborate with analytics and product teams to support reporting and data needs

· Document data pipelines, database processes, and operational procedures

· Participate in code reviews and follow engineering best practices

What We're Looking For:

· Core Skills & Experience

· 3–5 years of experience in data engineering, database administration, or similar roles

· Strong experience with PostgreSQL, MongoDB, and Amazon Redshift

· Solid SQL skills for both transactional and analytical workloads

· Experience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)

· Proficiency in Python or another scripting language

· Experience with workflow orchestration tools (Airflow, Step Functions, etc.)

· Hands-on database administration experience, including:

· MongoDB (replica sets, sharding, indexing, backups)

· Redshift (cluster management, query tuning, WLM, snapshots)

· PostgreSQL (replication, performance tuning, connection pooling)

· Familiarity with monitoring tools (CloudWatch, pgBadger, MongoDB Atlas, etc.)

· Understanding of database security (encryption, auditing, least-privilege access)

Nice to Have:

· Experience with Kafka or Kinesis (streaming data)

· Familiarity with dbt for data transformation

· Knowledge of data lake/lakehouse architectures (Delta Lake, AWS Lake Formation)

· Experience with Terraform or CloudFormation

· CI/CD experience for data pipelines

· Basic DevOps skills