Senior Data Engineer - Analytics & Reporting Modernization SOL-1790

The Senior Data Engineer is responsible for leading the implementation and operationalization of the Elections Redshift analytics platform, improving reporting performance, ensuring reporting accuracy, and establishing a scalable analytics foundation for the TEAM system. This role is expected to transform reporting from a known operational bottleneck into a strategic capability by delivering the Redshift implementation, validating reporting accuracy, and improving Public Information Request (PIR) workflows. The role will work closely with stakeholders, Product, Engineering, QA, and AWS to ensure reporting is performant, accurate, auditable, and scalable. Based on the Redshift PoC, the objective is to move reporting workloads away from the transactional PostgreSQL database and into a dedicated analytics environment using Redshift and CDC‑based replication.

Definition of Success

• Faster PIR turnaround times
• Elimination of report reconciliation issues
• Reduced load on transactional databases
• Improved stakeholder confidence in reporting
• Increased analytics platform adoption

The expectation is to leave reporting, analytics, and data quality capabilities materially better than they were found within the first 90 days. Success is not measured by activity alone, but by delivering a production‑ready Redshift analytics platform, improving PIR performance and accuracy, establishing trusted reporting across the TEAM ecosystem, and creating the foundation for a modern analytics experience for Elections.