[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.ResponsibilitiesProvide daily operational support for CNIC’s Enterprise Data Warehouse (EDW), ETL processes, and reporting platformsEnsure platform stability, timely data refreshes, successful deployments, and effective troubleshooting of Tier II/III issues impacting data or system availabilitySupport platform upgrades, rollover activities, and CNIC modernization effortsPerform daily server checks and ETL job checks to confirm successful executionExecute routine and ad‑hoc patching of EDW servers and componentsPerform ONV password resets and user support tasksExecute monthly data refreshes for Tableau reportsSupport Facts & Figures and CNO 5x8 reporting enhancementsSupport QA/PROD deployments across EDW environmentsTroubleshoot Tier II/III issues affecting platform or job availabilityProvide support for ad‑hoc requests from EIM teamsCoordinate with SDP through IssueTrak tickets for operations and incident resolutionSupport G2 Platform efforts including server upgrades, rollover projects, SPO migration, and JBAB/Saratoga realignmentMaintain operational documentation, runbooks, and SOPsSkillsActive Top Secret clearance6–8+ years of experience supporting enterprise systems, data platforms, or EDW operationsETL job monitoring and troubleshootingServer patching and maintenanceDeployment support (QA/PROD)Tier II/III troubleshootingTicketing tools (IssueTrak, ServiceNow, etc.)Data refresh processes (e.g., Tableau)DoD 8570 IAT II compliant - Security+ CEBS Degree in Computer Science or IT disciplineUS Citizenship requiredIBM DataStage 11.7Microsoft SQL Server Analysis Services (SSAS)Microsoft SQL Server Reporting Services (SSRS)Microsoft Power BIMicrosoft Azure Synapse / cloud data platformsTableauExperience with ETL/BI concepts and data warehouse operationsBenefitsA variety of medical plan options, some with Health Savings AccountsDental plan optionsA vision planA 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company matchFull flex work weeks where possibleA variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave15 days of paid leave per calendar year to be used for vacations, personal business, and illnessAn additional 10 paid holidays per yearPaid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employeesShort and long-term disability benefitsLife, accidental death and dismemberment, personal accident, critical illness and business travel and accident insuranceCompany OverviewGeneral Dynamics Information Technology is an IT consulting company that specializes in cyber security, AI, and quantum computing. It is a sub-organization of General Dynamics. It was founded in 1999, and is headquartered in Falls Church, Virginia, USA, with a workforce of 10001+ employees. Its website is https://www.gdit.com/.