Position overview / Statement of Work Pay rate -$60-$68.00 an hour The Database Programmer / Analyst will support the Philadelphia Citizens Police Oversight Commission (CPOC) Data Division with implementation and ongoing maintenance of data pipelines into and out of a PostgreSQL database. The role focuses on writing and maintaining scripts and queries that enable reliable data ingestion, extraction, and preparation for reporting and analysis. The position is hands-on and execution-oriented, emphasizing system organization, clarity, and repeatability rather than database administration, security, or advanced analytics. Work activities: ·       Develop and maintain Python scripts to retrieve data from APIs and other external sources and load it into PostgreSQL ·       Write and maintain SQL queries, tables, and views to support reporting and analysis ·       Prepare and structure data for use in dashboards and advanced analytics ·       Perform basic data validation and transformation to address formatting, consistency, and completeness issues ·       Organize scripts, queries, and documentation to ensure maintainability and ease of handoff

• Design and implement robust, scalable features across the entire stack using C# and .NET Core. • Build responsive, high-performance user interfaces with React and modern state management libraries. • Deploy and manage services within AWS ensuring high availability and performance. • Build and maintain RESTful APIs that serve as the backbone for our web applications. • Participate in code reviews, write unit tests, and maintain documentation to ensure long-term maintainability. • Work closely with Product Managers and other team members.

• Design, develop, and deploy scalable, high-performance software systems and infrastructure to solve complex business problems. • Collaborate closely with Data Scientists to support the integration of machine learning models and data pipelines into production systems, focusing primarily on software engineering aspects (e.g., code optimization, deployment, and system integration). • Work with Product & Engineering teams to integrate solutions into products and services, emphasizing system design, coding, and best practices. • Develop and manage data pipelines to handle large datasets, ensuring efficient data ingestion, transformation, and storage to support both data scientists and engineering needs. • Architect and implement scalable software systems, optimize existing systems, and build new features with a focus on system efficiency and scalability. • Manage databases and caching systems (e.g., MySQL, Redis, Elasticsearch), ensuring efficient data storage and retrieval, while supporting the needs of data scientists working with large datasets. • Deploy robust infrastructure solutions on AWS or GCP, ensuring high availability, fault tolerance, and scalability for data-heavy applications. • Conduct experiments and test hypotheses to improve system performance and reliability, leveraging collaboration with data scientists to ensure models and algorithms are properly integrated into production. • Communicate technical details and insights to both engineering and non-engineering stakeholders, fostering cross-functional understanding. • Stay updated on the latest developments in software engineering, system design, and infrastructure best practices, sharing knowledge with the broader team. • Provide technical mentorship and guidance to junior team members, encouraging continuous learning and development. • Ensure system compliance with data security and privacy regulations, incorporating best practices into development processes.

• Innovate, build, and invent on behalf of customers • Plan, execute and maintain entire products/features for millions of customers • Design and code solutions for broadly defined problems • Drive best practices and engineering excellence • Collaborate with team to develop architecture and design of systems • Work in an agile environment to deliver high-quality products