Database Warehouse Specialist

Synergy; Elizabeth City (NC); On-site; USD 80,000 - 120,000; Full time

Job summary

A premier software implementer is seeking a Database Warehouse Specialist for the U.S. Coast Guard. This position involves designing and maintaining data warehouses and ETL processes while adhering to federal cybersecurity standards. Candidates should have experience in Agile methodologies and strong database skills, contributing to critical logistics and reporting functions within the organization.

Benefits

Group medical, dental, and vision insurance

401(k) with immediate company match

Tuition and training reimbursement

Paid federal holidays

Fitness/wellness reimbursement

Qualifications

• Minimum two years in Data Warehousing.
• Minimum two years in security remediation based on scans.
• Minimum one year in Agile DevSecOps environment.

Responsibilities

• Design, develop, and maintain enterprise data warehouses and reporting structures.
• Implement efficient ETL processes for data loading.
• Integrate data warehouses with reporting and BI tools for dashboards.

Skills

Data warehouse design

ETL processes

Agile development methodologies

DevSecOps toolchains

SQL

PL/SQL

Education

Bachelor's or Associate's in Computer Science, Math, IT, Engineering or related field

Tools

Oracle

SQL Server

Job description

Description

NOTE: This role is contingent on the contract being awarded.

Synergy Business Innovation & Solutions is a premier implementer of cutting-edge software solutions. Synergy brings the experience and expertise necessary to deliver capability that provides tangible ROI to our customers. Synergy's core areas of expertise are in the fields of Digital Transformation, Cloud Solutions, SaaS and Low-Code/No-Code solutions, Emerging Technologies, Data analytics and Visualization, Information Assurance, and Business Process Re-Engineering.

Synergy offers its employees a generous portfolio of benefits including group medical, dental, and vision insurance, HSA, FSA, 401(k) with immediate company match, PTO/Sick Leave, 11 paid federal holidays, company-paid life, short-term and long-term disability insurance, tuition and training reimbursement, fitness/wellness reimbursement, a referral bonus program, and life management programs.

At Synergy, you'll be challenged and given the opportunity to grow in your career. Growth is a priority, with dedicated career coaches, company-funded certifications, education reimbursement, and an open-door support policy. Our team is eager to learn, fast-paced, and quality-driven—if that describes you, we have a position for you!

NOTE: This role is contingent on the contract being awarded.

Position Summary:

Synergy is seeking aDatabase Warehouse Specialist to support the United States Coast Guard (USCG) at the Aviation Logistics Center (ALC)-Information Systems Division (ISD). The Database Warehouse Specialist will design, develop, and maintain secure and optimized data warehouse environments to support logistics, maintenance, supply chain, and financial reporting across the USCG enterprise.

The ideal candidate will have hands-on experience in database warehousing, data modeling, ETL processes, and DevSecOps toolchains, with a strong understanding of Agile development methodologies and federal cybersecurity standards.

Primary Responsibilities:

Design, develop, and maintain enterprise data warehouses, data marts, and reporting structures for operational and analytical needs.

Implement efficient ETL processes to load data from source systems into centralized repositories.

Create and manage database schemas, data dictionaries, metadata, and ERDs to ensure accuracy and accessibility.

Optimize data storage, indexing, and partitioning for performance and scalability.

Integrate data warehouses with reporting and BI tools like SAS Viya, Cognos, and Framework Manager for dashboards and analytics.

Apply data governance practices to ensure data quality, lineage, access control, and retention policies.

Support security remediation activities based on vulnerability scans and STIG compliance.

Participate in Agile sprints and collaborate using Jira, Confluence, Bitbucket, and Kubernetes within a DevSecOps framework.

Document configurations, change logs, SOPs, and disaster recovery protocols.

Collaborate with software developers, cybersecurity teams, and system engineers to align data infrastructure with enterprise architecture and security requirements.

Stay current with emerging data technologies, cloud trends, and industry best practices for modernization.

Perform other duties as assigned.

Skills/Qualifications:

Experience in data warehouse design, dimensional modeling, and data integration.

Proficiency in SQL, PL/SQL, and procedural programming in platforms like Oracle, Ingres, or SQL Server.

Strong understanding of ETL, data governance, and normalization.

Familiarity with Agile and DevSecOps environments, including version control and sprint planning.

Experience with vulnerability remediation tools like Tenable.

Excellent communication skills for technical and non-technical audiences.

Education/Experience:

Bachelor's or Associate's in Computer Science, Math, IT, Engineering, or related field. Two years of experience may substitute for one year of education.

Minimum two years in Data Warehousing.

Minimum two years in security remediation based on scans.

Minimum one year in an Agile DevSecOps environment.

Experience supporting federal systems, especially within DHS or DoD, is preferred.

Clearance:

U.S. citizenship required. Must have or be eligible for a Public Trust or DoD Secret clearance.

Certification:

CompTIA Security+ required; other certifications like Network+, AWS, Azure, ITIL are a plus.

Work Location:

Elizabeth City, NC - On-Site

Compensation varies based on many factors. The posted pay range is an estimate and may not reflect individual circumstances. Hiring decisions depend on various factors.

Physical Requirements: The physical efforts include repetitive motions, grasping, reading, writing, visual and auditory tasks, and occasional lifting or moving up to 30 pounds. Overtime may be required.

Synergy is an equal opportunity employer, and prohibits discrimination based on age, race, creed, gender, sexual orientation, disability, and other protected categories by law.

#LI-Onsite