Location: Virginia / Remote
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 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