Data Systems Engineer - FT

Public Strategies is a dynamic professional services firm with more than 35 years of experience delivering innovative communications, consulting, technology, events, and project management solutions. Our collaborative team of problem solvers, creatives, technologists, trainers, communicators, and change agents is committed to doing good well.

Serving private sector, government, and nonprofit clients nationwide, Public Strategies delivers award winning products and experiences. Public Strategies has also pioneered nationally respected human services programs supporting low income and other vulnerable populations. Through our integrated initiatives (including One Set Studio, our cutting edge virtual production space, and NextThought, our eLearning initiative) we elevate storytelling, training, videos, and immersive experiences for leading national brands.

Position Summary

The Data Systems Engineer (DSE) reports to the Senior Manager of Software Engineering and designs, builds, and maintains the data layer of Public Strategies' custom Ruby on Rails applications. The DSE owns relational schema design and data modeling in PostgreSQL, builds and evolves ActiveRecord models and migrations, and safeguards data integrity across all business units. Working closely with stakeholders and technical leads, the DSE translates business processes into sound, performant data structures, drawing on deep knowledge of PS direct services and the systems that support them. This role balances hands on Rails development with the reporting and analysis that inform business decisions.