The Solutions Analyst uses their understanding of the college's enterprise class and department-wide systems, reporting infrastructure, application dependencies, database structures and rules, and stakeholder needs to continually assess and improve the way departments conduct business, as well as troubleshoot technical issues as they arise. They work closely with members of the campus community to identify, plan, build, and manage technology-related projects that deliver value to the stakeholder. Driven by multiple stakeholders' needs, they work independently to prioritize and set timelines for their workload and collaborate with other ITS staff as needed to implement projects. The Solutions Analyst uses their technical and business knowledge to advise functional departments and other ITS staff on using technology to meet the college's strategic initiatives and business goals.
Essential Functions:
Researches, determines, and communicates options to meet stakeholder requirements. Depending on project specifications, decides to build solutions independently or as a key member of a technical team. Prioritizes independent projects and manage timelines based on availability and stakeholder dependencies.
Creates standard and complex queries for data extracts and develops/maintains business intelligence reports for executive leadership, campus departments, third-party vendors, and/or regulatory agencies that are necessary for completion of their duties and objectives. This includes report design for the presentation-layer, user interfaces, performance specifications, and data security standards, as well as, applying scripting skills (via Structured Query Language), knowledge of proprietary database structures, an understanding of the departments' data rules and intricacies, and ability to elicit unambiguous requirements from the requester.
Analyzes and resolves unique software, data, reporting, and database process issues for departments, focusing on timely problem resolution and effective customer communications. This may involve coordination with vendors or other ITS staff and responding to helpdesk tickets.
Manages technical components of report and software implementations, integrations, upgrades, and maintenance for department stakeholders. Coordinates and collaborates with stakeholders to determine the appropriate rollout or maintenance strategies to promote the health and stability of the systems and processes, and accuracy of analytical reports. Specifies testing requirements based on design and project goals, and resolves testing feedback from users.
Continually analyzes stakeholders' business processes and needs to identify, plan, and deliver solutions to improve operational efficiency, reduce errors, and adapt to new requirements. This includes creative problem solving for projects that require an atypical approach for a solution.
Serves as technical liaison between stakeholders and other Enterprise Systems staff for project requests, problem solving, solution design, and issue escalations. Represents departments, as well as Enterprise Systems, in meetings related to technical/system matters.
Department: Enterprise Systems
Preferred Qualifications:
Bachelor's Degree – Business or information technology-related field
1 – 3 years work experience.
Experience with SQL required. Experience with the support and use of Ellucian Banner, IBM Cognos, and other enterprise class document imaging systems is preferred. Experience in a college or university setting is preferred. Demonstrate a basic understanding of project management and coordination. Demonstrate a thorough knowledge of relational database concepts. Demonstrate ability to apply knowledge in solving new and varied problems. Demonstrate good oral and written communication skills with both technical and non-technical users required. Demonstrate ability to work within a team-oriented environment and with users/administrators who are not technically skilled.
Known for its innovative curriculum, Dickinson is a highly selective, private liberal-arts college. One of the nation's oldest colleges, and named in honor of a signer of the U.S. Constitution, Dickinson became the first college chartered in the newly recognized United States in September 1783. Dickinson has just under 900 full and part-time employees - administrators, faculty and staff - and its 144-acre campus is populated by students from 43 U.S. states and territories and 40 foreign countries. More than half of students study abroad through the school's 50 programs in 24 countries on six continents. Dickinson is recognized as a leader among institutions committed to sustainability and green initiatives and is continually recognized by such groups as the Association for the Advancement of Sustainability in Higher Education, Sierra Club, Sustainable Endowments Institute, Princeton Review and Second Nature. Dickinson's stunning campus - featuring beautiful landscaping and buildings made of limestone - is located in the heart of the historic central Pennsylvania town of Carlisle, a key marker in Civil War activity. Founded in 1751, Carlisle, named a "most livable city" by Forbes, i...s a cosmopolitan town of 20,000 people, nestled between mountains that have long been a destination for outdoor enthusiasts. The Appalachian Trail and several mountain lakes are within easy reach of the campus, as are Hershey Park and historic Gettysburg. The town is a transportation hub linked by highway, rail and air to prominent East Coast cities, with driving times that make these cities readily accessible: Harrisburg, 20 minutes; Gettysburg, 30 minutes; Baltimore, 90 minutes; Washington, D.C., two hours; Philadelphia, two hours; New York, three hours; Pittsburgh, four hours. Dickinson takes pride in its campus wellness and professional development programs, offering an array of opportunities to faculty and staff.
