DATA WAREHOUSING ADMINISTRATOR

DATA WAREHOUSING ADMINISTRATOR

Location: Remote

Coordinates the data administration technical function for both data warehouse development and maintenance. Facilitates change control, problem management, and communication among data architects, programmers, analysts, and engineers. Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure. Provides product support and maintenance of the data warehouse. Performs data warehouse design and construction. Prepares/implements data verification and testing methods for the data warehouse.

Minimum Requirements:

• Five (5) years relevant experience
• Relevant certification from a nationally recognized technical authority
• Possesses or able to obtain (Formerly IT-II) Non-Critical Sensitive security clearance and Tier 3 Investigation (T3)
• IC Agile Certification

Required Certifications:

• IAT Level II or 8140.03 equivalent certification(s)
• Microsoft Certified Solutions Associate SQL Server
• Microsoft Certified Solutions Associate for SQL Database Development (Microsoft Certified: Azure Database Administrator Associate is acceptable as a more recent substitute and covers both SQL certifications)
• Necessary Delivery Skills/Knowledge:
• Working knowledge of the Agile framework and implementation
• Experience developing, deploying, and maintaining SQL Server Integration Services (SSIS) ETL jobs
• Experience developing, deploying, and maintaining SQL Stored Procedures

Nice to haves:

• Knowledge of applying Risk Management Framework (RMF) Security Technical Implementation Guides (STIGs) to applications and servers such as Microsoft SQL Server and IIS.
• Experience with CI/CD tools and methodologies including Jenkins, GitHub and Jira
• Experience managing SQL service and user accounts for SQL authentication and Windows authentication
• Experience working with Microsoft IIS
• Experience interfacing with APIs such as Express.js
• Experience interfacing with MongoDB