Designing, developing, and maintaining data systems that support the Board's mission
Requirements
- PostgreSQL and SQL Server, stored procedures, indexing, query optimization, ETL (Python, SQL, Glue, Step Functions, Lambda)
- Database design principles, data modeling, integration patterns, data validation
- 1–3 years with SQL development and database fundamentals
Responsibilities
- Assist with database schema design and data modeling
- Develop stored procedures, functions, triggers, and database objects
- Build ETL processes and data pipelines; implement CI/CD for deployments
- Create and optimize APIs and data access layers
- Support performance monitoring, query optimization, indexing, and partitioning
- Assist with database migrations, upgrades, data quality validation, and retention procedures
- Implement database security controls, support FISMA compliance, and data masking
Other
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field (or equivalent experience)
- Personnel must be able to maintain the required level of clearance (Moderate Risk) while supporting the Board on this effort
