Senior Database Developer – DHS OHSS (Remote)

Job title: Senior Database Developer – DHS OHSS (Remote) in Washington DC at BluePath Labs Company: BluePath Labs Job description: Senior Database Developer - DHS OHSS (Remote)Location: Washington, D.C.BluePath Labs is a fast growing research and management consulting company focused on the challenging research problems for both government and private sector clients. This position requires supporting a key government client with expert analytical chemistry assistance to aid in its mission to stem the flow of opioids into the United States.The Department of Homeland Security (DHS) hosts the independent Office of Homeland Security Statistics (OHSS). OHSS leads the collection and dissemination of immigration-related and other statistical data related to DHS operation domains to Congress and the public. OHSS was formerly the Office of Immigration Statistics and is being renamed and transformed into an organization with broader scope and increased responsibility.Responsibilities:The Senior Database Developer will:

• Establish and maintain a comprehensive, effective, and secure data management framework that enables OHSS to collect, store, process, and analyze data seamlessly. The objective is to ensure data integrity, accessibility, and security while promoting automation, modernization, and effective decision-making through the optimization of data workflows, integration, and governance practices. This will support business operations, enhance data-driven insights, and ensure compliance with relevant regulations and standards.
• Establish a Comprehensive Data Management Framework
• Implement Data Validation Rules and Automated Data Cleansing Processes
• Promote Automation in Data Collection, Storage, Processing, and Analysis
• Maintain a data dictionary
• Enforce standard naming conventions
• Assure accessibility of report data to all available stakeholders

Minimum Requirements:

• U.S. Citizenship
• Bachelor's degree in IT, Computer Science, Engineering, or related field
• 15 years or more of federal onsite experience supporting and understanding agency policies and workflows.
• 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:

• Master's degree in IT, Computer Science, Engineering, or related field
• 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:BluePath Labs offers a comprehensive benefits package. Benefits include, but are not limited to: healthcare reimbursement, lifestyle & wellness reimbursement, Flexible Spending Account (FSA), tuition assistance, 401(k) with company match, and paid time off for vacation / sick leave, in addition to 12 holidays per calendar year.About BluePathBluePath Labs combines mission and business insights with advanced technologies to deliver measurable performance improvements for our clients. BluePath is dedicated to surpassing client expectations by always living by our core values of integrity, professionalism, and resilience. BluePath's extensive experience in Government, Military, Commercial, and Academic environments is unique among small businesses and a core differentiator of our solutions. Our multidisciplinary background allows us to solve diverse and complex problems. Most importantly, we work closely with our clients to frame problems correctly, optimize processes, leverage technologies, and implement enduring solutions. Labs are where ideas are born, experiments occur, and breakthroughs happen. It is the hallmark of BluePath's culture.BluePath Labs is an equal opportunity employer. Expected salary: $140000 - 160000 per year Location: Washington DC Apply for the job now! Apply for this job