Senior Database Developer

We are a purpose-driven professional services firm dedicated to providing support for a range of diverse federal program missions. Our focus extends across the intersections of national security, public health and safety, and financial services programs. We are hiring an accomplished Senior Database Developer to work on a critical project within the national security sector.

The key goals and objectives of this project are to modernize report automation processes and establish a comprehensive, efficient, and secure data management framework for the Department of Homeland Security’s (DHS) Office of Homeland Security Statistics (OHSS). This initiative aims to enhance the quality, timeliness, and accessibility of statistical data, improve inter-agency collaboration, and support data-driven decision-making through automation, modernization, and process optimization. The desired outcomes include streamlined workflows, improved data integrity and security, expanded capabilities for data sharing, and the delivery of actionable insights to policymakers, Congress, and the public, ultimately enabling OHSS to achieve its mission of providing high-quality statistical information efficiently and effectively.

The Senior Database Developer will be responsible for designing, implementing, and maintaining comprehensive data management frameworks to support the DHS OHSS. They will also be responsible for designing, implementing, and maintaining comprehensive data management frameworks to support the Department of Homeland Security’s (DHS) Office of Homeland Security Statistics (OHSS).

This role requires extensive expertise in database systems, data governance, and automation to ensure data integrity, accessibility, and security.

Key Responsibilities:

Establish and Maintain Data Management Framework

· Conduct detailed assessments of current data systems and workflows to identify areas for improvement.

· Develop a roadmap for implementing the data management framework, ensuring necessary tools and technologies are in place.

· Design and document a data management framework that aligns with organizational goals, addressing data collection, storage, processing, and analysis needs.

· Set up and maintain a central data repository or data warehouse for easy access and management of collected data.

Creation and Maintenance of Data Dictionary

· Regularly update the data dictionary with new data elements and changes to existing ones as systems and processes evolve.

· Add new data sources, fields, and their descriptions when integrating new data systems or features.

· Track historical changes to the data dictionary to maintain version control.

Define and Enforce Naming Standards

· Define standardized naming conventions for datasets, fields, and variables to ensure consistency.

· Ensure that data definitions align with industry best practices and organizational standards.

Promote Automation in Data Processes

· Implement automated data collection pipelines to streamline the gathering of data from various internal and external sources (e.g., APIs, databases, IoT devices).

· Develop automated workflows for data processing, including data transformation, cleansing, and validation, to reduce manual intervention and errors.

· Integrate automated reporting tools to generate real-time or scheduled reports with minimal manual effort.

· Set up automated data analysis tools (e.g., machine learning models, AI algorithms) to extract actionable insights from data with minimal manual processing.

Ensure Data Accessibility

· Ensure report data is easily accessible to all stakeholders, including data analysts, IT personnel, and business users, through a user-friendly interface or central repository.

· Provide search functionality and filters to help users locate relevant data elements and metadata quickly.

· Document clear instructions on how to use and contribute to the data report.

Ensure Data Integrity

· Implement data validation rules and automated data cleansing processes to ensure data accuracy and integrity.

· Develop access control policies to restrict and monitor data access based on user roles and permissions, ensuring the principle of least privilege.

· Align with DHS data council to oversee the implementation and maintenance of the data governance framework.

Establish data backup and disaster recovery protocols to safeguard data against potential loss or corruption.

Requirements

Education:

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline is required. Master's degree preferred.

Work Experience:

15 years or more of federal onsite experience supporting and understanding federal agency policies and workflows.

Technical Skills:

Demonstrated expertise with database management systems, including SQL Server, Oracle, or PostgreSQL.

Extensive experience designing, implementing, and maintaining relational databases, data warehouses, and ETL processes.

Proficiency in Data Analysis, Data Modeling, and Data Integration, including familiarity with tools like ERwin or similar data modeling software.

Experience with Data Governance frameworks and practices to ensure data quality and compliance.

Preferred Qualifications:

Experience developing stored procedures, functions, and triggers to support application development.

Familiarity with cloud-based database platforms (AWS, Azure, Google Cloud).

Strong knowledge of federal security standards (e.g., FISMA, FedRAMP) as applicable to database design and implementation.

Benefits:

Potomac Haven covers 70% of our full-time employee;s health insurance premiums (medical, dental, vision) through CareFirst, a Blue Cross Blue Shield health plan

Simple IRA and corporate match

Educational, training, and certification assistance

Complementary short- and long-term disability insurance

Paid time off

Work Schedule:

8-hour shift during normal business hours of 8 am – 5 pm EST

Monday to Friday

More about Potomac Haven: We are an award-winning information technology and professional services firm. We help our federal customers achieve their goals by providing diverse, multi-talented and dedicated professionals to fulfill their mission. Our customers include Bureau of Industry and Security, DoD Washington Headquarter Services, U.S. Air Force, U.S. Coast Guard, U.S AID, Consumer Financial Protection Bureau (CFPB), Bureau of Ocean Energy Management (BOEM), General Services Administration (GSA), Centers for Disease Control and Prevention (CDC) and Administration for Children and Families (ACF) among others.