Senior Data Platform Engineer

The Senior Data Platform Engineer serves as Sola's primary database administrator and data platform engineer within the DevSecOps team. This role owns the production databases that support our analytics, transactional, and caching layers, including Amazon Redshift, MySQL, Microsoft SQL Server, and PostgreSQL, as well as the Cube.js semantic layer, the ingestion pipelines that feed it, and the Terraform managed infrastructure beneath it.

This is a hands-on role with a high degree of autonomy. The successful candidate will design new data architecture, resolve production performance issues, and maintain the pipelines and infrastructure as code that support them. Operating within a PCI DSS and SOC 2 regulated payments environment, this engineer partners closely with Engineering, DevOps, and Security to keep the data platform performant, reliable, secure, and scalable as the business grows.

Own the performance, availability, and cost of the Amazon Redshift data warehouse, including cluster sizing, workload management (WLM), distribution and sort key design, and routine vacuum and analyze maintenance.

Administer and tune Cube.js as the semantic and analytics layer built on Redshift.

Administer production relational databases, including MySQL/Aurora MySQL and Microsoft SQL Server, covering backup and recovery, patching, version upgrades, CDC and replication, and hi