Data Architect and Administrator
Internet2 is seeking a creative, collaborative, hands-on practitioner of Data Architecture and Database Management who will (with the support and collaboration of other Systems Administrators, Developers, Engineers and Architects), design and deploy Internet2's foundation data architecture, data warehouse and analytical information stores.
The qualified candidate will: Solicit, refine and respond to concrete business requirements, define solutions, advocate and implement industry best-practices. This role will be instrumental in building the information stores which power the organization's Identity and Access Management functionality, Community Engagement and Community Communications engines, and Member management services. By embracing a cloud-first, DevOps model, the successful candidate will be able to demonstrate proficiency in a hybrid variety of deployment modes including commercial cloud and on-premises delivered solutions.
Identifies user data requirements by researching and analyzing use cases, application preferences, performance requirements, business objectives, and working methods; studying how business users need to access and consume content, including data categorization and labeling; meeting with subject matter experts within the organization and the community.
Plans data, data flows in support of information architectures required, by studying (or overseeing the study of): data consumption patterns, identifying data provenance, source/target system flows, data movement strategies and information consistency needs.
With support and input from other architects, envisions architectural schemes and emerging technologies, defines data and information structure and features, data-persistence designs; prepares data models; designs information structures.
Organizes information by translating information presentation requirements into database structure and elements; producing data workflow diagrams, use-case analysis, flowcharts, or other relevant artifacts; preparing access specifications, master schema definitions; practices in organization of data, and relevant data descriptions and policies.
Communicates and coordinates these requirements with dependent line-of-business staff.
Implements and maintains data architecture by preparing prototypes and production structures, monitors performance and operational fitness, identifies security requirements and works with operations and information security staff to ensure data integrity and security, automates where necessary, and documents structure and processes.
Validates data delivery and integrity by ensuring development and completion of; usability test plans; evaluating traffic patterns; and soliciting / studying user feedback.
Maintains knowledge of state-of-the-art commercial and open-source solutions by tracking research regarding web design and usability, as well as data modeling/database practices and technology; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
Diagnose and troubleshoot database errors.
Be available for on-call support as needed.
Bachelor's degree in computer science, management of information systems, or a related field (strongly desired)
Minimum of 5 years of experience in database administration, information technology, database architecture, or a related field
Professional certifications are desirable
Experience with Linux and Windows Server environments
Extensive experience with various cloud database solution deployment and open-source options, as well as traditional database deployment technologies (MySQL, MS SQL, PostgreSQL , Oracle, MongoDB, etc.)
Experience with cloud services (AWS, Microsoft Azure, Google Cloud Platform) a plus
Internet2 has offices located in Ann Arbor, MI; Denver, CO: Washington, DC: and West Harford, CT. Remote candidates are encouraged to apply.