Data Engineer (GovTech sphere)

Coherent Solutions, Inc.; Aurora (CO); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Technical and non-technical training

Health insurance

Flexible work options

Referral program

Work anniversary program

Job summary

A fast-growing SaaS company is seeking a Backend Engineer to manage Amazon Aurora MySQL clusters and optimize database performance. The ideal candidate has over 5 years of experience in MySQL and AWS infrastructure. This role offers flexible working options and a comprehensive benefits package, including health insurance and professional development opportunities.

Qualifications

• 5+ years of experience with MySQL, ideally Amazon Aurora MySQL.
• Strong SQL skills and deep understanding of query tuning, indexing, and performance optimization.
• Knowledge of data security, auditing, and compliance in cloud environments.

Responsibilities

• Architect and manage Amazon Aurora MySQL clusters for high availability and performance.
• Implement scaling strategies such as read replicas and connection pooling.
• Ensure data security and compliance across the infrastructure.

Skills

AWS (ECS, Lambda, Fargate)

MySQL

SQL skills

Data architecture

ETL pipeline design

Data modeling for analytics

Disaster recovery

Docker

Tools

AWS RDS

DataDog

Grafana

GitHub Actions

Job description

Founded in 2015, this fast-growing SaaS company is on a mission to improve financial transparency and operational efficiency in local government. The platform helps municipalities communicate effectively with their communities and operate more efficiently through modern, cloud-based software. Their core product suite is used by hundreds of local governments across the U.S.Their core product suite is built on a scalable, secure, and high-performance platform that supports budgeting and financial management for municipalities of all sizes.

Project Description

The platform is a shared services architecture supporting authentication, caching, messaging, data access, and observability across multiple public sector products. It is designed with performance and scalability in mind, using services like Aurora/MySQL, Redis, ElasticSearch, and AWS tools such as ECS, Lambda, and Fargate.As part of the Platform Development Team, you will help ensure backend infrastructure is secure, performant, and scalable as data volume and user demand grow. Your work will directly impact system reliability, developer productivity, and product performance across the suite.

Technologies

• AWS (ECS, Lambda, Fargate, EC2, RDS, S3), Docker, Nx.dev, GitHub Actions

What You'll Do

• Architect and manage Amazon Aurora MySQL clusters for high availability and performance
• Implement scaling strategies such as read replicas, connection pooling, and serverless/on-demand scaling
• Optimize database schema, indexing, and partitioning for large datasets
• Maintain and tune reporting databases, separating analytics from transactional systems
• Manage data lifecycle, including archiving and efficient storage strategies
• Develop disaster recovery and backup strategies using AWS tools
• Monitor performance and optimize queries using execution plans and metrics
• Ensure data security and compliance across the infrastructure

Job Requirements

• 5+ years of experience with MySQL, ideally Amazon Aurora MySQL
• Strong SQL skills and deep understanding of query tuning, indexing, and performance optimization
• Expertise in designing scalable data architecture and partitioned data models
• Proficiency in AWS RDS and other AWS infrastructure tools
• Hands-on experience with ETL pipeline design and data modeling for analytics
• Knowledge of disaster recovery, backup policies, and cross-region replication
• Familiarity with data security, auditing, and compliance in cloud environments
• Experience with CI/CD, Docker, and observability tools such as DataDog or Grafana
• English level: B1+ (spoken and written)

What Do We Offer

The global benefits package includes:

• Technical and non-technical training for professional and personal growth;
• Internal conferences and meetups to learn from industry experts;
• Support and mentorship from an experienced employee to help you professional grow and development;
• Internal startup incubator;
• Health insurance;
• Sports activities to promote a healthy lifestyle;
• Flexible work options, including remote and hybrid opportunities;
• Referral program for bringing in new talent;
• Work anniversary program and additional vacation days.

Share vacancy

We will be glad to see you!

First Name

Last Name

Email

Referral Add the name of our employee (e.g. John Smith)

Comments

Attach file

Attach file Formats (3 MB): doc, docx, pdf, txt, rtf

I have acknowledged and agree that Coherent Solutions will process my submitted personal data pursuant toPrivacy Policy for Job Applicants and understand that due to international presence of Coherent Solutions my personal data may be transferred to third countries. I also give consent to Coherent Solutions to process my personal data for 3 (three) years for the purpose to notify me about future job openings. I am informed that I can withdraw my consent anytime by submitting a request [e-mail]. In such case my personal data will be deleted from a candidates database.