This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Find a job in the Great State of New York!

To post a job, login or create an account |  Post a Job

VDOT Data Architect

Key Cyber Solutions

This is a Full-time position in New York, NY posted July 30, 2021.

Key Cyber Solutions (KCS) is a leading enterprise IT consulting firm that specializes in Secure Agile Software Development, Cybersecurity, Enterprise IT and Data Management services for both government and healthcare organizations.

Our approach to business is both aggressive and agile.

We value a strong work-ethic, good judgement, organizational skills and, most importantly, an entrepreneurial spirit.

At KCS we treat our employees like family and, in turn, they pay that respect forward to every one of our clients.

Job Description

The VDOT IT Division is seeking a Data Architect.

The Data Architect will analyze business needs, and develop appropriate data deliverables, (i.e.

data models, data flow diagrams, data dictionary and glossaries) to meet them

The selected candidate will provide analytical and technical support for developing appropriate data deliverables, such as, data models, data flow diagrams, data dictionary and glossaries

The Virginia Department of Transportation’s Information Technology Division is seeking a team member to function as a Data Architect.

The Data Architect will analyze business needs, and develop appropriate data deliverables, such as, data models, data flow diagrams, data dictionary and glossaries to meet them.

The Data Architect will also assist in issue resolution, in operationalizing data governance, in assessing, measuring and tracking data quality, and in creating and socializing data management artifacts, such as, SOP’s, standards and guidelines, control processes etc.

This position will also assist in extending the scope of enterprise data warehouse and the analytics program.

Responsibilities:

• Create data models and xml schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions.

Models will include objects, entities, attributes, their inter-relationships and dependencies in 3N and/or dimensional formats.

• Integrate disparate data models into coherent enterprise data models.

• Forward engineer physical models to create DDL scripts to implement new databases or database changes.

Reverse engineer databases and synchronize data models with actual data implementations.

• Create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical data domains.

• Identify and reconcile inconsistencies in data definitions, e.g., synonyms and homonyms.

• Work to identify master data (entities and attributes) and capture how data is interpreted by users in various parts of the organization.

• Capture business rules that govern how data is transformed, integrated, and used.

• Develop canonical models and data transformation rules using XML

Requirements:

• Broad understanding of Data Architecture and Data Management approaches and implementation methodologies

• Ability to work with business as well as IT stakeholders

• Minimum of 5+ years of experience designing large scale data models for functional, operational and analytical environments

• Demonstrated experience in Conceptual, Logical, Physical and Dimensional Modeling

• Hands-on experience with data modeling tools

• Knowledge of BI tools, such as Power BI, Tableau

• Experience with Agile/Scrum is valuable

• Ability to work creatively and analytically in a team environment

• Excellent communication and documentation skills

• 5+ years of experience as Data Modeler/Data Architect creating data models and working in Data Architecture and Data Management solutions.
 

Qualifications

Min 5 years Experience:

Designing large scale data models for functional, operational and analytical environments

Experience in Conceptual, Logical, Physical and Dimensional Modeling

Knowledge of BI tools, such as Power BI, Tableau

Experience as Data Modeler/Data Architect creating data models and working in Data Architecture and Data Management solutions

Additional Information
As a HUBZone certified business, we STRONGLY encourage candidates who reside in a HUBZone to apply.

To confirm if your home address is within a HUBZone, please visit http://map.sba.gov/hubzone/maps/.

 ***Please note in your cover letter if you reside within a designated HUBzone location.

****
All your information will be kept confidential according to EEO guidelines.