Data Warehousing Consultant

Data Warehousing Consultant

Location: 100% Remote

DATA WAREHOUSING ADMINISTRATOR 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)

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
• IC Agile Certification

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. (this is going to be a longshot for anyone IMO so i put it in nice to haves)
• 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.