Favor TechConsulting Logo
Favor TechConsulting

Data Architect

Arlington, VA

a day ago

3 people have applied



Job Description:

Data Architect Location OtherClient Site - Arlin on VA Department Department of State, Foreign Service Institute

IT Support Services Type Full Time Minimum Experience Experienced Security Clearance Level Required Secret Clearance

The clearance level stated above must be met for consideration for this specific opportunity.

Unfortunately, FTC is unable to sponsor at this time.

Military Veterans and individuals with disabilities are encouraged to apply!

Favor TechConsulting, LLC (FTC) is seeking a talented Data Architect with extensive government experience.

Essential Duties

Responsibilities

Role Overview

A data architect is responsible for designing, creating, deploying and managing how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data in some way.

This senior level position will be instrumental in designing, updating and maintaining mission critical systems.

This position will provide guidance and support to all technical positions including system architects, developers and database administrators.

The requirements as stated above reflect industry standards.

Responsibilities Design new architectures and re-designing existing architectures including data structures and database code.

Design and build relational databases.

Perform data access analysis design, and archiverecovery design and implementation, especially in a Microsoft SQL Server environment.

Able to define, design, and build dimensional databases.

Design and implement all database objects including schemas, tables, clusters, indexes, views, sequences, packages and procedures based on system requirements Develop data warehousing blueprints, evaluating hardware and software platforms, and integrating systems.

Develop strategies for data acquisitions, archive recovery, and implementation of a database.

Translates business needs into long-term architecture solutions Managing input of various data sources, definition of database architecture, development of database code, construction and maintenance of ETL based processes, design of database reporting, construction of data flow diagrams and creation of documentation manuals.

Creating code for database modification, constructing and accessing databases using stored procedures, triggers and functions developing ETL processes.

Implement and optimize queries and stored procedures.

Expert knowledge with data profiling and migration tasks.

Data migration expertise.

Designing new architectures and re-designing existing architectures (including data structures and database code)

Review and develop object and data models and the metadata repository to structure the data for better management and quicker access.

Required Skills

Experience Expert in backup integrity and disaster recovery situations.

Expert in a data warehouse environment, which includes data design, database architecture, and metadata repository creation.

Expert with data definition language to implement database objects.

Experience with coding stored procedures, functions, and triggers to implement data access controls Expert reviewing, testing, and troubleshooting database structures and code.

Experience masking and replicating large data sets (for privacy and testing purposes) using enterprise tools Enforce change management processes in each environment Expert-level knowledge of Microsoft SQL Server.

Professional Certification(s)

Formal Education BSBA degree in Computer Science, Information Sciences, or related IT discipline.- Allowable Substitution Additional ten (10) years of related professional experience can be substituted for a BSBA degree.

Years of Professional Experience

A minimum of 10 (ten) years of professional experience in database architecture.

A minimum of 12 (twelve) years related in the software development field.

Desired Skills Experience

Desired Skills and Experience 1

Desired Skills and Experience 2

Professional Certification(s)

Formal Education

Years of Professional Experience

Required TechnicalBusiness Tools Experience Required tools experience 1 Required tools experience 2

Physical Requirements

Physical Requirement 1

Physical Requirement 2 Additional Information FTC requires all employees to be fully vaccinated as a condition of employment, unless legally entitled to an accommodation.

If you receive an offer of employment, it will be made contingent upon satisfaction of this requirement, and you will be required to show proof that you are fully vaccinated or to promptly engage in an interactive process to allow Human Resources to evaluate potential reasonable accommodations for valid medical or religious reasons.

Please do not provide information about whether you are seeking an exemption from the vaccination requirement unless and until you receive a conditional offer of employment from FTC.

U.S Citizenship is required for this specific opportunity and all selected applicants will be subject to a government security investigation.

This includes but not limited to meeting the eligibility requirements for access to classified information and the ability to obtain a government-granted security clearance.

Individuals may also be subject to a background investigation including, but not limited to criminal history, employment verification, education verification, drug testing, and creditworthiness.

Favor TechConsulting is an Equal Opportunity Employer.

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.



Data Architect Jobs in Arlington

Jobs at Favor TechConsulting in Arlington

Report this Job

Jobs For You

Want a list of Gig jobs just for you on your phone?

Enter your phone number below and we will send you a SMS with a list of roles suited just for you.

How much should you be earning?

Are you getting paid fairly? Find out how much Data Architects are earning in Virginia.