The Data Solutions Architect is responsible for all activities related to the database system administration, data warehouse architecture, connecting disparate systems, and the continued development and maintenance of the data warehouse environment. This incumbent will translate strategic business requirements into scalable technical solutions, provide expertise in database technologies, and liaise with the Marketing Department to support data analytics, ticket sales, CRM, ERP, and other key database platforms. The Data Solutions Architect will work with a project team to coordinate database system and infrastructure development that align with the Institution’s cross-cutting imperative for mobilizing technology solutions.
- Contribute to and deliver on the strategic vision for data architecture with cross-functional teams in Information Technology, Marketing & Analytics, Advancement Operations, and other key stakeholders.
- Educate on data management methods and standards for cross-functional applications. Communicate and enforce standards and overall architecture for data warehouse systems.
- Develop procedures for tracking data quality, completeness, redundancy, and improvement.
- Conduct data capacity planning, life cycle, duration, usage requirements, and feasibility studies.
- Create plans for data security, backup, disaster recovery, business continuity, and archiving.
- Create processes for governing the identification, accuracy, collection, and use of metadata.
- Ensure that data strategies and architectures are in regulatory compliance with privacy laws.
- Maintain architecture of the data warehouse, future data marts, and reporting environments.
- Establish best practices for data loading and data extraction into/from the data warehouse.
- Responsible for data accuracy, maintenance, and support within the data warehouse.
- Implement strategies for flexibility, scalability, and to define the future direction for technical architecture in the business intelligence reporting physical environment.
- Collaborate on the selection of appropriate tools, software, applications, and systems to support the mobilization of technology solutions organization-wide.
- Ensure the success of enterprise-level application rollouts (e.g. ERP, SCM, CRM, SAP, UKG, etc.)
- Liaise with vendors and service providers to select the products or services that meet business needs.
- Oversee the mapping of data sources, data movement, interfaces, and analytics for data quality.
- Direct project teams and ensure synergy with operations managers for all projects involving data.
- Address data-related problems with systems integration and compatibility across multiple platforms.
- Require testing criteria to guarantee the fidelity and performance of data architecture.
- Document the data architecture and environment to maintain an accurate view of the data picture.
- Identify and develop opportunities for data reuse, migration, or retirement.
Education and Experience
Required education: Bachelor’s degree in computer science, information systems, or engineering. Candidates with an equivalent combination of education/work experience will also be considered.
Skills and Abilities
- Technical savvy in data architecting, data modeling, management of metadata, and data migration.
- Creative, innovative thinking and fluency of ideas to lead strategic initiatives and be a key collaborator in business requirements analysis, relationship planning, database design, and reporting structures.
- Systems thinking to understand data relationships and reporting within complex software systems.
- Logic and reasoning to understand data structures, theories, principles, and practices to extract relevant information and apply that information to strategies for successful operations.
- Problem-solving capabilities to identify complex problems, use critical thinking, logic, reasoning, and relevant information to evaluate options, and develop appropriate, effective solutions.
- Project management experience to navigate multiple projects, full cycle, simultaneously with experience in implementing enterprise data management processes, procedures, and user support.
- Relationship-building expertise to provide leadership and support across interworking teams. Consultative and collaborative approach to problem-resolution in teams.
- Self-starter who will be a strategic partner focused on work that builds a foundation of process and procedure, accomplishes routine responsibilities, plans for the future, and meets goals.
- Political savvy to tactfully navigate complex technology circumstances, make recommendations and resolve problems with an independent judgment that is consistent with the culture, ethics, best practice, policy, procedure, industry regulation, and federal and state laws.
- A life-long learner who is eager to maintain technical knowledge, establish professional networks, participating in industry-specific organizations, and attending conferences.
- Personal integrity and ethics when dealing with highly confidential and sensitive information.
Work Location, Schedule, and Travel
The Database Solutions Architect will work full-time with the necessary flexibility to work evenings, weekends, and overtime, as required, and willingness to flex up in scheduled work hours based on business need.
This position will be based in Chautauqua Institution’s home office, located in South Western New York. Qualified candidates may also be considered for telework.
Occasional travel is required to various professional events, conferences, and training using personal or occasionally rental vehicles. Travel predominantly within the region in an approximate 100-mile radius. Self-coordination of business travel and occasional flights required.
Chautauqua Institution’s competitive benefits suite includes health insurance, dental insurance, flexible spend (or health savings) account options, vision insurance, complimentary life insurance, access to various fitness and wellness programs, and employee-paid supplemental life insurance and long-term disability options. We help our employees plan for the future through a discretionary employer pension contribution, which has recently been (10%) of gross compensation following a designated service period. The Employee Assistance Program provides virtual access to a network of free services including counseling sessions, legal counsel, financial advisors, and childcare and eldercare referrals.
Discovering Your Chautauqua Experience
There are countless ways that our talent will engage with our mission, vision, and diverse communities, and you are invited to immerse yourself in our programming as a gateway to this experience.
Employees will receive the traditional Chautauqua gate pass, which provides access to all Amphitheater programs except popular entertainment (up to two nights a week) and lawn seating for all performing arts events at the Pratt Avenue performance pavilion, a new, temporary venue for 2021. Designated popular entertainment events in the Amphitheater will require a separate ticket purchase, if tickets are available.
In addition to a traditional gate pass, employees and their families will receive full access to our current and historical programs online at CHQ Assembly.
Joining Our Talent Community
Qualified candidates should apply online at CHQ.org/employment. Interested applicants must submit a cover letter and resume, with optional portfolio documents, for consideration. You are encouraged to learn more about Chautauqua Institution at CHQ.org and the 150 Forward Strategic Plan at 150fwd.CHQ.org.