Job Board
LogoLogo

Get Jobs Tailored to Your Resume

Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

Effectual Logo

Senior Data Engineer - Database Focus

Effectual

$151,000 - $185,000
Aug 20, 2025
Remote, US
Apply Now

The company is seeking a Senior Data Engineer with strong database expertise to design, build, and maintain robust data infrastructure, ensuring optimal database performance and security within a cloud-first AWS environment.

Requirements

  • 7+ years of experience in data engineering with significant database focus
  • Extensive experience with AWS services including: AWS Lake Formation (required), AWS Step Functions (required), AWS Lambda (required), Amazon S3 (required), AWS API Gateway (required), Amazon RDS (required)
  • Strong experience with database technologies: MySQL, Oracle, SQL Server, PostgreSQL, MariaDB, DynamoDB, DocumentDB, Neptune, MongoDB, Redshift, Snowflake
  • Proficient in programming languages: Python, Java, Scala
  • Advanced SQL and database optimization expertise
  • Experience with AWS RDS platforms including multi-AZ deployments, read replicas, and automated backups
  • Experience with big data technologies: Hadoop, Spark, Kafka

Responsibilities

  • Design and create overall data architecture including databases, data lakes, and large-scale processing systems
  • Build and maintain data pipelines that transform and transport data from various sources using AWS services
  • Design, configure, and maintain cloud-based database environments including AWS RDS
  • Monitor database performance and proactively identify and address performance issues
  • Ensure database security including access control, data encryption, and compliance
  • Develop and implement backup and recovery procedures
  • Optimize data retrieval and perform database maintenance tasks

Other

  • Provide technical leadership and mentorship to junior team members
  • Lead strategic planning for data infrastructure initiatives
  • Manage resources and coordinate cross-functional projects
  • Drive change management initiatives for data systems
  • Bachelor's degree in a STEM program (Computer Science, Engineering, Mathematics, etc.)