Job Details

ID #44522250
State District of Columbia
City Washington
Job type Permanent
Salary USD $DOE DOE
Source Advanced American Technologies, Inc
Showed 2022-08-02
Date 2022-08-01
Deadline 2022-09-30
Category Et cetera
Create resume

Data Architect (Min 8 years of exp) (Webcam interviews) (REMOTE)

District of Columbia, Washington, 20024 Washington USA

Vacancy expired!

We are looking for Data Architect (Min 8 years of exp) (Webcam interviews) POSITION DESCRIPTION DIRECT CLIENT Position Number of positions: 1 Length: 14 Months + Location: REMOTE / Washington, DC 20024 Immediate interviews Webcam interviews ONLY Please note that this position is REMOTE. 11-15 years of experience. Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation. Looking for a Data Architect, who has extensive experience designing and implementing data management strategies at the enterprise level in support of delivering best-in-class, data-driven solutions for the organization. The successful candidate will possess a strong technical background and can showcase proven excellence in the design and successful production implementation of various databases, data warehouses, and data lakes. The Data Architect will be experienced with several technologies, to include those that are cloud-based to support all facets of data architecture design and business intelligence, to include those focused on ETL/ELT, data modeling, and data storage that focuses on performance. Roles and Responsibilities

  • Will identify and analyze source systems and necessary data storage and database operations.
  • Develop or assist in the development in data dictionaries for data that must be extracted, transformed, and loaded.
  • Define source to target data mappings.
  • Designs, develops, implements, and maintains conceptual, logical, and physical data models.
  • Will develop or assist in the development of a documented enterprise data architecture that ensures a standardized process for data collection, storage, and consumption.
  • Will oversee the development of a data warehouse and a data lake for structured and unstructured data respectively.
  • When necessary, functions as a technical team lead supervising the work of data warehouse DBAs/data modelers, ETL developers, PL/SQL developers.
  • Creates and updates existing entity relationship diagrams.
  • Provide optimization for new and existing database systems.
  • Works with data scientists to identify future needs and requirements.
  • Responsible for data modeling, system/data analysis, design and development for applications, data marts & semantic layer to support analytics and reporting needs.
  • Exercises strong communication skills verbally and in writing, interfaces easily with both business and technical audiences, and acts as the Subject Matter Expert in key data areas such as data quality, data integration, master data governance, and security.
Minimum Education/Certification Requirements: Bachelor's degree in IT or related field or equivalent experience Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required. Skill Matrix Experience with Business workflow processes Required / Desired Amount of Experience Designing, creating, deploying, and managing data architecture in an enterprise environment Required 8 Years Hands-on mgmt. of SQL Server 2008 or higher, Oracle, or IBM DB2, involving implementation of schemas, indexes, and query optimization Required 8 Years Working with large data sets Required 8 Years Defining and implementing data security, quality enforcement, and retention policies Required 8 Years Bachelor's degree in IT or related field or equivalent experience Required BS in IT or 12 Yrs overall IT Exp Years Experience with data modeling tools (i.e., ER/Studio, PowerDesigner, Erwin, Oracle SQL Developer, and Sparx Systems Enterprise Architect) Required 8 Years Applied experience and expertise in data architecture concepts (e.g., model management, meta-data management, data governance). Required 8 Years Hands on experience with data integration tools (i.e., Informatica PowerCenter and SQL Server Integration Services (SSIS)). Required 6 Years Demonstrated ability to create high quality technical artifacts such as Source to Target Mappings (STMs) and Record Level Specifications (RLS Required 6 Years Experience developing database solutions to store and retrieve company information. Required 6 Years Familiarity with data visualization, business intelligence, and predictive analytics tools (i.e., Qlik, Tableau, QuickSight, Business Objects, SAS) Required 4 Years AWS Certifications Highly desired 0 Experience working in an Agile environment. Highly desired 3 Years

Vacancy expired!

Subscribe Report job