Data Solutions/AI Architect

PlanIT Group is seeking a Data Solutions/AI Architect to support our Federal customer in the Washington, DC area. The ideal candidate will function as the primary technical architect for data warehousing projects to solve business intelligence challenges. Possess deep technical expertise in database design, ETL (OWB/ODI), reporting, and analytics. Previous consulting experience utilizing an agile delivery methodology.

Job Title: Data Solutions/AI Architect

Location: Arlington, VA hybrid

Duration: One year plus annual extensions

NOTE: The work schedule for this position will be an average of 32 hrs./week.

This position will require individuals to live within driving distance of the DC Metro area to report to HQ in Arlington, VA one day per week and may be adjusted as needed at the supervisor's discretion.

We are seeking a Data Solutions Architect to join our team of qualified, diverse individuals supporting a Federal Government customer in Rosslyn, VA. The candidate must be able to obtain a Position of Public Trust Clearance - US Citizen or Permanent Resident (Green Card Holder) and must not have traveled outside the US for a combined total of 6 months or more in last 5 years. Must have resided in the US for the last 5 years

Position Description

• Functions as the primary technical architect for data warehousing projects to solve business intelligence challenges
• Possesses deep technical expertise in database design, ETL (OWB/ODI), reporting, and analytics
• Previous consulting experience utilizing an agile delivery methodology

Position Requirements

• Solutions architect must have expertise as both a solutions architect and AI architect.
• 3+ years' experience with Azure ETL processing
• 3+ years' experience utilizing data warehousing methodologies and processes
• Strong conceptual, analytical, and decision-making skills
• Knowledge and Experience of dimensional modeling
• Strong knowledge of Azure Databricks
• Proficiency in creating PL/SQL packages
• Full SDLC and Data Modeling experience
• Ability to create both logical and physical data models
• Ability to tune databases for maximum performance
• Experience in Data Preparation: Data Profiling, Data Cleansing, and Data Auditing
• Ability to work with Business Analysts to create functional specifications and data
• Manages QA functions
• Develops unit, system, and integration test plans and manages execution
• Ability to write technical and end-user system documentation
• Excellent written and oral communication skills
• Experience transforming logical business requirements into appropriate schemas and models
• Ability to analyze and evaluate moderate to highly complex information systems by being able to interpret such devices as Entity Relation Diagrams, data dictionaries, record layouts, and logic flow diagrams

Additional Provisions:

• Must be able to obtain a Position of Public Trust Clearance
• Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.
• All candidates must be a US Citizen or US Permanent Residents only
• Candidate must have lived in the United States for the past 5 years.
• Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)