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.