Position : Data Architect
Location : 1305 E Walnut, IA (Local Preferred)
REQ ID: 465502
Duration 12 + Months
In Person only
Short Description: The Technical Specialist (TS) is a senior level resource with specialized knowledge and experience in a specific technology such as SharePoint development or an SAP specialist.
Complete Description :
This position will be working full-time on a large new development program that requires an advanced Data Architect and DBA skillset while also interacting with the department's database support team. The program involves working with several different projects for distinct business units while also assembling the data in one place for reporting, analysis, and validation. All development is being done in a SQL Server/.Net environment. Experience in database design and modeling for new application development is required.
In this position, you will be the face of all things data. 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 data migration from other systems, script development and execution, creating DB backups, 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, with aggressive timelines. The project is currently transitioning to agile, so agile experience is a plus.
Initial contract funding is for 1 year, but a longer 3-5 year engagement is anticipated.
Responsibilities
• Quickly learn and understand the project's database, tables, structures and fields from a big picture perspective (across business functions and project iterations) to provide architectural and decision support direction.
• Data Architect
o 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
o Analyze data requirements and data stored in a disparate set of systems and designing a robust relational structure for the future
o Be accountable for integrity and quality of data, ensuring the information meets customer needs
o Ability to proactively participate in customer engagements, follow direction from lead technicians, work with customers, and participate in technical planning
o Plan for collection method, data cleansing, and normalization of data across multiple applications
o Understand how the data interacts with the application code
o Understand .Net Entity Framework
• Database Administrator
o Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.
o Perform all database updates, changes and enhancements utilizing and upholding a formal, structured naming convention
o Create, maintain, and deploy scripts across all project environments (Dev/Test/UAT/Prod)
o Perform and maintain all database backups and database restores associated with the project across all project environments (Dev/Test/UAT/Prod)
• Be accountable for integrity and quality of data, ensuring the information meets customer needs
• Perform necessary testing related to the project and its iterations
• 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
• Ability to present ideas in a user-friendly language
• Some overtime may be necessary in order to meet aggressive deadlines
• Complete other duties as assigned by Project Manager or Administrative Manager
Skill requirements
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 | Required Experience in years | Candidates Experience in years | Last Used |
| Experience in database design and modeling for new application development | Required | 5 | Years | |
| Extensive background in relational database systems, preferably with MS SQL Server | Required | 5 | Years | |
| Transact SQL (T-SQL) | Required | 5 | Years | |
| Strong database design experience and understanding of relational database structures, theories, principles and practices | Required | 5 | Years | |
| Proficient translation of business requirements and functional specifications into technical data requirements | Required | 5 | Years | |
| Superior interpersonal and communication skills, including the ability to be both directive and collaborative and to present ideas in a user-friendly | Required | 5 | Years | |
| Demonstrated leadership skills | Required | 5 | Years | |
| Exceptional analytical, conceptual and problem-solving abilities required | Required | 5 | Years | |
| Strong written, technical documentation and oral communication skills | Required | 5 | Years | |
| Experience with iterative and/or Agile Scrum development methodologies | Desired | 2 | Years | |
| SQL Server Integration Services (SSIS) | Desired | 2 | Years | |
| Experience with XML and XPath | Desired | 2 | Years | |
| Extract, Transform and Load (ETL) migrations | Desired | 2 | Years | |
| Experience with BizTalk | Desired | 2 | Years | |
Feel free to contact me if you require further information or assistance.
Unfeigned regards,
Ankur Bhatia
Lead Technical Recruiter | ASK IT Consulting Inc.
![Description: cid:image003.jpg@01CF12AA.A003AF10]()
Women Owned Minority Certified Enterprise
33 Peachtree Court Holtsville, NY 11742
Phone: +1 631-649-1313 X 4381| Fax: +1 631 803 4488
E: ankur.bhatia@askitc.com|www.askitc.com
Ask IT Consulting is an equal opportunity employer. All qualified applicants, who are eligible for employment are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.
