Summary of Responsibilities: Under the general direction of the Director of Application Services, this intermediate position will leverage their business and technical knowledge to architect and build a secure business intelligence infrastructure and develop secure production-ready data models to meet college goals and objectives.

1. Collaborate with cross-functional teams to identify and implement data solutions that meet college needs.
2. Analyze requirements and recognize alternative solutions that may be more efficient or effective for the college.
3. Design and develop advanced business intelligence reporting solutions based on input and analysis.
4. Integrate multiple campus data sources, analyze data, and develop scripts to transform/convert data.
5. Ensure data quality and accuracy by implementing data validation and testing processes.
6. Implement security and compliance measures to ensure the protection of sensitive data.
7. Design and develop scalable data solutions using cloud technologies.
8. Migrate existing data solutions to cloud platform technologies.

Essential Responsibilities: (These essential responsibilities are those the individual must be able to perform unaided or with the assistance of reasonable accommodation.)

1. Business Requirements and Process Analysis:
   1. Partners with subject matter experts to learn and understand data and reporting requirements.
   2. Conducts business requirements reviews and independently formulates logical statements of business requirements.
2. Systems Analysis:
   1. Transform the logical statements of business requirements into technical/functional specifications.
   2. Implements the functional/technical steps by revising existing data models or creating new data models.
   3. Creates prototype data model designs.
   4. Develops system architecture and assembles solutions for a modern business intelligence infrastructure.
   5. Develop test transactions and use cases to verify the results of the data transformation (conversion) and identify data quality issues.
3. Deployment/Maintenance/Operations Analysis
   1. Evaluates and documents operational performance as directed.
   2. Diagnoses moderately complex to complex issues/incidents as directed.
   3. Research and gather data/information, analyze information, and propose alternative solutions for moderately complex to complex data/reporting requirements.
   4. Completes service requests/problem resolution for moderately complex to complex data/reporting requirements.
   5. Additionally, this position may be required to maintain a standby status as part of a rotation within the team. This requires 24 hours per day, 7 days per week availability during the standby period. The frequency varies based upon the number of colleagues in the rotation.
4. Hosted Services Support
   1. Works with vendor(s) for day-to-day systems operations support including related data architecture.
   2. Reviews systems operations needs including software updates and upgrades, database server and instance maintenance including backup operations.
5. Report Writing
   1. Develop and deliver reports based on college requirements.
6. Programming/Development:
   1. Modify and/or write scripts as needed.
   2. Test and debug script modifications for correctness.
   3. Assist in Peer reviews.
7. Project Management
   1. Works with project manager to define tasks and create teamwork plans with moderate supervision on moderately to complex projects.
   2. Delegates work to others and monitor’s progress.
   3. Identifies issues affecting work progress and recommends solutions.
   4. Communicates schedule variances and potential scope changes in status reports.
   5. Controls project costs, communicating any project-related expenses and recommends ways to control costs.
   6. Manages small projects including Project scope, statement(s) of work, MS Project plan(s), estimates, and communications.
8. Educational/Knowledge Requirements:
   1. Completes on-going training on-the-job, through courses, self-study, certifications and/or advanced degrees to maintain and enhance technical and business capabilities.
   2. Demonstrates understanding of the fundamental tools and concepts of one of the information technology professional disciplines (i.e., Applications, Business Analysis, Development, etc.) and applies that understanding to make independent practical contributions to IT work within Application Services.
9. Miscellaneous:
   1. Perform other duties as assigned.

Exhibits behavior that is consistent with and supportive of Geneva’s mission, vision, core values, and standards of conduct:

1. Geneva Mission Statement: Geneva College is a Christ-centered academic community that provides a comprehensive education to equip students for faithful and fruitful service to God and neighbor.
2. Vision Statement: Geneva College will inspire students to integrate faith in Christ into all aspects of life in the real world, and to serve faithfully within their callings for Christ and Country.
3. Core Values:
   1. Serve with grace
   2. Pursue Godly wisdom
   3. Foster academic strength
   4. Engage culture faithfully
   5. Inspire vibrant hospitality
   6. Honor one another
4. Standards of Conduct: Employees of Geneva College will affirm upon hire, and annually thereafter, their promise to abide by the College’s Standard of Conduct Policy. All employees must conduct their personal affairs so there can be no opportunity for unfavorable reflections upon the Christian beliefs and mission of the College, either expressed or implied. It is expected that employees will conduct themselves in a manner consistent with biblical standards, values, and character. These standards of personal conduct do not apply to family members and/or friends of the employee.

Job Requirements - Administrative:

1. General: Individuals must possess the knowledge, skills, and abilities listed or are able to explain and demonstrate that they can perform the essential responsibilities of the job, with or without reasonable accommodations to safely perform the essential responsibilities of the job.
2. Physical: Must be able to perform the following: talking, hearing, and seeing. Must have sufficient manual dexterity to be able to operate all office equipment including, but not limited to computers, copy machines, scanners, and telephones.
3. Confidentiality: Individuals must recognize that management of data, including personal information, grades, budgets, programs, and policies is necessary to the operation of the College. Such information must be kept private and confidential for the protection of the College and to obey Federal and/or State laws. Should there be doubt as to whether a certain matter is to be protected, it should be discussed with your supervisor before making a disclosure.
4. Mental: Must be able to reason, analyze, prioritize, conceptualize, make judgments, and solve problems.

Qualifications:

1. Minimum:
   1. Education/Certification: 4-year academic degree includes courses in data analytics, big data analytics, database management, systems analysis, data visualization, and four years’ experience or at least seven years Business Intelligence experience without a degree.
   2. Skill/Abilities:
      1. Knowledge of modern BI platforms and apps,
      2. Understand relational database concepts and constructs,
      3. Experience with enterprise DBMS,
      4. SQL, Python, R programming languages,
      5. Proven understanding of data architecture, data transformation, BI schemas, and BI presentation,
      6. Cloud-based project implementation experience,
      7. Strong problem-solving skills and the ability to work independently and in a team environment,
      8. Ability to communicate effectively with colleagues.
   3. Christian Commitment: Eligible candidates must be a thoughtful and articulate Christian and an active member of a Protestant evangelical Christian church. Preference will be given to candidates who support and have an articulate understanding of the Reformed faith. The individual must understand and support the College’s “Foundational Concepts of Christian Education” by expressing an evangelical Christian profession of faith and demonstrate the ability to integrate a Christian perspective in their work.
2. Preferred:
   1. Bachelor’s Degree in Data Science or similar,
   2. Prior experience standing up BI Solutions in Higher Education,
   3. Experience in Information Technology Services Management
   4. Skill/Abilities:
      1. Hands-on experience with cloud services, such as Azure Data Factory, Azure Databricks, and Azure SQL Database.
      2. Hands-on experience with Data Lakehouse, including medallion architecture data pipelines, metadata, and governance for data quality control.

About Geneva College

Geneva College is a challenging Christian college that prepares students to challenge the world and succeed. We provide an academically rigorous education comprised of distinctive and innovative courses. Geneva offers over 40 undergraduate majors and seven master’s degree programs, with the most popular including business, engineering, education, biology, communication, psychology, student ministry and human services. And our liberal arts core fosters a breadth of knowledge through the study of humanities, the social and natural sciences, biblical studies, and experiential learning. Founded by the Reformed Presbyterian Church of North America, Geneva helps students meet the challenge of becoming everything God means them to be. Our 55-acre campus is located in Beaver Falls, Pennsylvania, about 35 miles northwest of Pittsburgh. Geneva College is a founding member of the Council for Christian Colleges and Universities (CCCU).

Connections working at Geneva College