Data Solutions Architect

Overview

On Site
Full Time

Skills

Business Intelligence
Database Design
Oracle Warehouse Builder
OWB
Oracle Data Integrator
Reporting
Analytics
Agile
Extract
Transform
Load
Data Warehouse
Artificial Intelligence
Analytical Skill
Decision-making
Dimensional Modeling
Microsoft Azure
Databricks
PL/SQL
Software Development Methodology
Data Modeling
Database
Data Profiling
Data Cleansing
Auditing
Quality Assurance
Integration Testing
System Documentation
Communication
Information Systems
SAP BASIS
Law
FOCUS

Job Details

Job Description

ECS is seeking a Data Solutions Architect to work in our Arlington, VA office.

  • 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


Required Skills

  • 3+ years' experience with Azure ETL processing
  • 3+ years' experience utilizing data warehousing methodologies and processes
  • Must have expertise as both a solutions architect and AI architect.
  • 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


Desired Skills

#ECS1

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis any characteristic protected by law. All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, or local jurisdiction law.

ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3800+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.