Job Description - Skills: 10 years exp., bs/ba, data warehouse, etl, (AI) Artificial Intelligence, azure etl, dimensional modeling, azure databricks, pl/sql, data modeling, data profiling, data cleansing, data auditing, entity, relational diagrams, data dictionaries, record layouts, logic flow diagrams All candidates must meet the below requirement for the Public Trust Clearance. 1. Has candidate lived in the US for at least (5) years? (All candidates must have lived in the US for at least five years, and you will need to verify this information on the Public Trust Security Forms if selected) 1. Has candidate been out of the US in the last (5) years more than (6) months cumulative? (Candidates will need to verify this information on the Public Trust Security Forms if selected) Job Description 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