Data Architect (570227)/F2F required

Location: Des Moines, IA
Date Posted: 07-27-2018
Data Architect (570227)/F2F required
Des Moines Iowa
Duration: 12 Months
F2F
 
Short Description:
This position will be working full-time on a large Enterprise Information Architecture program that requires an advanced Data Architect and data analysis skillset while also interacting with the department’s database support team.
 
Complete Description:
The program involves developing an information architecture that may consist of, but is not limited to, the following features:
 
•             Data flow diagrams detailing the end-to-end processing of transactional data
•             Conceptual, logical and physical data models for each data domain
•             A reporting platform for data analysis and predictive analytics
 
Extensive experience in mapping data flows and new database development is required.  In this position, you will be the face of all things data for this project. You will need to be able to see the big picture while also able to work though the details to implement the big picture.  This will involve working with the  ETL Team on database design and verification, data integrity validation, and interactions with external stakeholders and customers.  The candidate will have experience working in a fast-paced environment, working on multiple tasks simultaneously.  The project is currently transitioning to agile, so agile experience is a plus.
 
Responsibilities
•             Analyze data stored in a disparate set of systems to produce data requirements and provide architectural and decision support direction
•             Use industry standards and/or best practices  to complete data mapping and detailed data flows
•             Lead the project team through the process of identifying inconsistencies in the data (e.g. duplicate data fields) and resolving accordingly
•             Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical, and physical data models based on those needs
•             Be accountable for integrity and quality of data, ensuring the information meets customer needs
•             Understand how the data interacts with the application code
•             Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision
•             Ability to read, understand and create design documents
•             Experience working in a team-oriented, collaborative environment
 
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job.  They are not intended to be a complete list of all responsibilities, duties and skills required of personnel assigned to this job.
 
Skill       
Required / Desired         
Amount              
of Experience
Experience working as a Data Architect
Required
10
Years
Extensive background in relational database systems, specifically with MS SQL Server
Required
5
Years
Experience using Transact SQL (T-SQL) to query, analyze and document relational databases
Required
5
Years
Experience in analyzing client operations, evaluating current systems and reviewing objectives with clients
Required
5
Years
Exceptional analytical, conceptual and problem-solving abilities
Required
10
Years
Experience writing technical documentation (excellent written and oral communication skills required)
Required
5
Years
Experience with iterative and/or Agile Scrum development methodologies
Desired
2
Years
Experience in data warehouse design and dimensional modeling
Desired
2
Years
Experience with Microsoft PowerBI
Desired
2
Years
Experience with ETL scripting, specifically using SQL Server Integration Services (SSIS)
Desired
5
Years
 
Questions
Description
Question 1
The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?
Question 2
Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?
Question 3
This requirement falls under the e-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?
Question 4
Please list candidate's email address HERE that will be used when submitting E-RTR.
 
Kiran Kumar
Key Business Solutions, Inc.
|| Office: 916 646 2080 Ext 224 || Fax: 916 646 2081 || Email: kiran@keybusinessglobal.com || Website: www.key-soft.com || Yahoo: kirankeysoft Gtalk: kiranjabukeysoft@gmail.com
Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
or
this job portal is powered by CATS