Systems Analyst/Developer

Park Hill; United States; On-site; USD 67,465 - 91,260; Full time

Job summary

Park Hill is seeking a Systems Analyst/Developer (full-time with benefits) to analyze requirements for database solutions, develop and maintain integrations, and streamline processes. The role also serves as product owner for multiple applications and provides technical guidance to staff and district personnel.

The position collaborates with network, infrastructure and analytics teams to design hosted and cloud data processes, develop ETL and BI reporting, and ensure secure, reliable database

Qualifications

• Knowledgeable in advanced SQL programming (T-SQL), relational databases (SQL Server and Oracle), database design and data warehousing.
• Ability to coordinate meetings, manage multiple projects, and communicate with diverse technical groups.
• Strong leadership, customer service, interpersonal, and communication skills are essential.

Responsibilities

• Builds and maintains positive working relationships with stakeholders for collaboration toward district goals.
• Collaborates in designing hosted and cloud database processes for accurate data access.
• Collaborates with Network and Infrastructure on tuning, backup, and recovery for security and stability of databases.
• Collaborates with Technology Projects and Training to communicate with staff and provide training on software usage.
• Coordinates data integration with other tech teams and external vendors for efficient services.
• Designs, develops, and maintains automated workflows to improve operational efficiency.
• Develops materials documenting activities and standards for reference.

Skills

Leadership

Customer service

Interpersonal skills

Teamwork

Analytical and problem-solving

Communication

Education

Bachelor's degree

Tools

SQL Server

Oracle

SSRS

Power Platform

Job description

Position Title: Systems Analyst/Developer, full-time, with benefits

Salary: $79,312 annually

Purpose Statement

The purpose of the Systems Analyst/Developer is to analyze requirements for database solutions; develop, implement, maintain database integrations and interfaces; streamline processes; collaborate on database administration; develop reporting solutions; develop automations between internal and/or external systems; document system components, processes, end user instructions; serve as product owner for multiple applications; and serve as a technical advisor to staff and other district personnel for enterprise application data.

Reports To: Lead Systems Analyst/Developer

Essential Functions

• Builds and maintains positive working relationships with all stakeholders (e.g. team members, vendors and other departments) for the purpose of working collaboratively towards district goals and ensuring open channels of communication.
• Collaborates in the design of a variety of hosted and cloud database processes (e.g. logical data models, structures, data warehousing, security, jobs, scripts and stored procedures, etc.) for the purpose of providing end users with access to accurate data.
• Collaborates with the Network and Infrastructure group on database administrative functions (tuning, backup, recovery) for the purpose of ensuring the security and stability of district databases.
• Collaborates with the Technology Projects and Training group for the purpose of communicating effectively with staff, students and parents as well as providing training on the proper use of new and/or existing software.
• Coordinates the integration of data with other technology teams and/or external vendors, for the purpose of ensuring efficient and streamlined services.
• Designs, develops, and maintains automated workflows to improve operational efficiency, accuracy, and service delivery.
• Develops a wide variety of complex materials (e.g. instructions, notices, reminders, memos, technical standards, security policies, training materials, etc.) for the purpose of documenting activities, providing references and/or conveying information.
• Develops ETL processes for reporting/data warehouse solutions for the purpose of interfacing various data sources and enhancing district reporting capabilities.
• Develops integrations and automations between internal and external software applications for the purpose of providing timely and accurate data exchange.
• Develops reporting and business intelligence (BI) solutions for the purpose of providing accurate, integrated information to support data-driven decision making.
• Ensures change management processes and effective communication methods are utilized for the purpose of accurately disseminating information related to application changes.
• Ensures district applications are monitored, maintained, updated, and supported through preventative maintenance practices for the purpose of optimizing performance and reliability.
• Establishes and utilizes application testing environments for the purpose of validating functionality and ensuring solutions meet defined requirements before production implementation.
• Participates in meetings, workshops and/or training for the purpose of conveying and/or gathering information required to perform job functions and stay up to date on the latest best practices.
• Participates in the migration/upgrade process of district databases for the purpose of ensuring continued functionality and compatibility with new and/or existing systems.
• Performs a variety of department activities as assigned for the purpose of ensuring the security and reliable operation of district databases.
• Promotes the innovative use of existing technology to district business process owners for the purpose of increasing effectiveness and providing streamlined solutions to organizational practices.
• Researches applications, vendors and emerging technology for the purpose of recommending products that meet district requirements for capability, cost, and sustainability.
• Responds to inquiries from a variety of sources (e.g. staff, administrators, school site personnel, outside vendors and service providers, etc.) for the purpose of providing technical assistance, advice and support.
• Reviews customer feedback for the purpose of monitoring effectiveness of support and developing technology strategies to address customer current and future needs.
• Serves as a product owner for assigned applications for the purpose of collaborating effectively with stakeholders and ensuring business needs are met.
• Serves as a technical resource to department and district staff for the purpose of providing information, consultation and guidance regarding active or planned projects.
• Shares new practices, documentation and improvement opportunities with team members for the purpose of cross-training and ensuring departmental excellence.
• Supports project operations (e.g. estimates of task deliverables, schedule updates, reporting status, etc.) for the purpose of ensuring project success and objectives are achieved.

Other Functions

Performs other related duties as assigned for the purpose of ensuring the efficient and effective functioning of the work unit.

Job Requirements

Minimum Qualifications

Skills, Knowledge and Abilities

SKILLS are required to perform multiple, technical tasks simultaneously with a need to periodically upgrade skills to meet changing job conditions. Specific skill-based competencies required to satisfactorily perform the functions of the job include: strong leadership skills, demonstrated customer service skills, excellent interpersonal skills including oral and written communication, strong team skills and strong analytical and problem-solving skills.

KNOWLEDGE is required to perform basic math, including calculations using fractions, percentages, and/or ratios, read technical information, compose a variety of documents, facilitate collaborative group discussions; and analyze situations to define issues and draw conclusions. Specific knowledge-based competencies required to satisfactorily perform the functions of the job include: advanced SQL programming (T-SQL), stored procedures, relational databases (both SQL Server and Oracle), database design (keys, normalization and record structures), SSRS, business intelligence, data warehousing; and current generation programming methodology including: object-based design, operating systems, protocols, and programming languages. Knowledge of Microsoft Power Platform tools is preferred.

ABILITY is required to coordinate and schedule meetings and events and often gather, collate and/or classify data. Flexibility is required to work with diverse groups and individuals; analyze data using defined processes; and operate equipment. Ability is also required to manage multiple small or medium sized projects simultaneously. Independent problem-solving is required to analyze issues and create action plans. Problem-solving with data frequently requires independent interpretation of guidelines. Specific ability-based competencies required to satisfactorily perform the functions of the job include: being attentive to detail; establishing and maintaining effective working relationships; communicating with persons of diverse technical knowledge and skills; maintaining confidentiality; analyzing situations; defining issues; drawing conclusions; setting priorities; and working with frequent interruptions. Ability to keep current on developing technologies and potential impact on district operations. Ability to relate to people and to observe, listen, motivate, and provide leadership.

Responsibility

Responsibilities include: working under limited supervision following standardized practices and/or methods; directing other persons within a small work unit; directing the use of budgeted funds within a work unit. Utilization of resources from other work units is often required to perform the job’s functions. There is a continual opportunity to impact the organization’s services.

Working Environment

The usual and customary methods of performing the job’s functions require the following physical demands: occasional lifting, carrying, pushing, and/or pulling, some climbing and balancing, some stooping, kneeling, crouching, and/or crawling and significant fine finger dexterity. Generally, the job requires 70% sitting, 15% walking, and 15% standing. This job is performed in a generally clean and healthy environment.

Experience

Job-related experience within a specialized field is required.

Education

Targeted, job related education with study in job-related area. Bachelor’s degree in job-related area is preferred.

Required Testing

Job-Related Skills Proficiency Test

Clearances

Criminal Justice Fingerprint/Background Clearance