Data Engineer (GovTech sphere)

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 View email address on click.appcast.io. In such case my personal data will be deleted from a candidates database. #J-18808-Ljbffr Coherent Solutions, Inc.