[Remote] CNIC EDW Administrator | Active TS clearance
Note: The job is a remote job and is open to candidates in USA. General Dynamics Information Technology is a global technology and professional services company that delivers consulting, technology, and mission services. They are seeking an EDW Administrator to provide operational support for the Enterprise Data Warehouse, ensuring platform stability and timely data refreshes while troubleshooting issues.
Responsibilities
- Provide daily operational support for CNIC’s Enterprise Data Warehouse (EDW), ETL processes, and reporting platforms
- Ensure platform stability, timely data refreshes, successful deployments, and effective troubleshooting of Tier II/III issues impacting data or system availability
- Support platform upgrades, rollover activities, and CNIC modernization efforts
- Perform daily server checks and ETL job checks to confirm successful execution
- Execute routine and ad‑hoc patching of EDW servers and components
- Perform ONV password resets and user support tasks
- Execute monthly data refreshes for Tableau reports
- Support Facts & Figures and CNO 5x8 reporting enhancements
- Support QA/PROD deployments across EDW environments
- Troubleshoot Tier II/III issues affecting platform or job availability
- Provide support for ad‑hoc requests from EIM teams
- Coordinate with SDP through IssueTrak tickets for operations and incident resolution
- Support G2 Platform efforts including server upgrades, rollover projects, SPO migration, and JBAB/Saratoga realignment
- Maintain operational documentation, runbooks, and SOPs
Skills
- Active Top Secret clearance
- 6–8+ years of experience supporting enterprise systems, data platforms, or EDW operations
- ETL job monitoring and troubleshooting
- Server patching and maintenance
- Deployment support (QA/PROD)
- Tier II/III troubleshooting
- Ticketing tools (IssueTrak, ServiceNow, etc.)
- Data refresh processes (e.g., Tableau)
- DoD 8570 IAT II compliant - Security+ CE
- BS Degree in Computer Science or IT discipline
- US Citizenship required
- IBM DataStage 11.7
- Microsoft SQL Server Analysis Services (SSAS)
- Microsoft SQL Server Reporting Services (SSRS)
- Microsoft Power BI
- Microsoft Azure Synapse / cloud data platforms
- Tableau
- Experience with ETL/BI concepts and data warehouse operations
Benefits
- A variety of medical plan options, some with Health Savings Accounts
- Dental plan options
- A vision plan
- A 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
- Full flex work weeks where possible
- A variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave
- 15 days of paid leave per calendar year to be used for vacations, personal business, and illness
- An additional 10 paid holidays per year
- Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
- Short and long-term disability benefits
- Life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance
Company Overview