Position Type:
TECHNOLOGY/DATA SERVICES/Data Services Positions
Date Posted:
9/20/2023
Location:
Data Services
Date Available:
09/20/2023
Software Engineer
Beginning Date: When Filled
Salary: $80,020- $128,680 Based on experience and education.
1 contract position available on Alpine School District’s Professional Salary Schedule; 8 hours per day; 250 days per year; Benefits and Retirement Plan included.
Hiring Manager: Paul Lewis
Phone: 801-610-8431
email: plewis@alpinedistrict.org
Job Summary
Alpine School District has purchased a data dashboarding tool for viewing and analyzing student achievement and performance data. It is an interactive tool that allows educators to track, analyze, and view KPIs and metrics.
Job Requirements
Applicants will be expected to have the skills needed below to create, maintain, and troubleshoot Alpine’s dashboarding tool. This position will require and use a data analysis skill set to combine historical and real-time data from multiple sources by providing data preparation, chart creation, and analysis. This position will work closely with both technical and educational departments to create specifications for new dashboard requirements then implement them through best programming practices. This position will also test results for accuracy through the use of State and District supported tools and direct SQL queries. This person may work with employees to maintain clean student data through training and data clean up. This position may also be involved with other various department projects. This position will also be involved in programming projects as needed within the department.
Skills needed:
- Analytical Skills – Understand, design and troubleshoot in a complex technical environment. Ability to problem solve data and logic issues that arise within database, middleware, and front end.
- Technical Skills – Basic understanding of relational transactional and analytical, databases, data warehouses, data relationships, DB schemas, and the ETL processes used to populate these databases. Ability to understand and create complex queries using SQL. Ability to create graphical elements/charts from SQL queries. Understanding of traditional software development and some experience in traditional programming.
- Numerical Skills – Ability to understand and implement statistical models in a graphical environment.
- Ability to gain a thorough understanding of student data systems in order to present that data to the end user. Ability to read and make judgments on student information and work with groups to understand, create and implement reporting requirements.
- Great people and communication skills.
- Ability to proactively work with and train individuals and groups.
Desired Experience:
- Thorough understand of database architecture, design and theory
- Experience with advanced SQL queries
- Experience in creating visualizations from SQL queries.
- Quality Assurance experience by validating and analyzing results/reports through raw SQL queries.
- Understanding of student educational systems and academic educational models
- Understanding statistical analysis and creating statistical visualizations based on those concepts.
- Experience in Power BI or other business analytics dashboarding tool, python, Javascript.
Essential Functions
- Collaborates with a variety of internal and external parties (e.g. programmers, programmer analysts, database administrators, users, government agencies, etc.) for the purpose of architecting, designing, developing solutions and ensuring project success.
- Develops and maintains code and systems solutions from researching existing software products and best practices for the purpose of automation of business processes and automated systems integration of data flow between systems, and system integration.
- Develops program code, user interfaces, application and user documentation for the purpose of providing computerized alternatives to manual processes.
- Develops functional and system/software requirements from information gathered at user meetings and/or interviews with internal staff and non-district sources for the purpose of documenting/interpreting user requests, identifying data sources and creating working plans.
- Implements software applications for the purpose of providing access to computerized alternatives to manual processes.
- Participates and provides project management support in a variety of planning and development activities, including district-wide committees for the purpose of creating short- and long-range plans for programming support to the district.
- Prepares a variety of materials (e.g. reports, memos, procedures, project documentation, flow charts, etc.) for the purpose of documenting activities, providing written reference, and/or conveying information.
- Researches database system, data models and schema, domain information, data and statistics for the purpose of responding to and fulfilling software requests.
- Serves as a technical resource to department and district staff for the purpose of providing information and/or advice regarding active or planned projects.
- Supports internally developed and 3rd party software for the purpose of functionality to fulfill user’s needs and enhance user’s software experience.
Job Requirements: Minimum Qualifications
Skills, Knowledge and Abilities
SKILLS are required to perform multiple, technical tasks with a need to routinely upgrade skills in order to meet
changing job conditions. Specific skill based competencies required to satisfactorily perform the functions of the job
include: operating standard office equipment; planning and managing projects; and preparing and maintaining
accurate records.
KNOWLEDGE is required to perform algebra and/or geometry; read technical information, compose a variety of
documents, and/or facilitate 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: relational
database theory and design, record structures, input and output devices; current generation programming
methodology including object based design, operating systems, protocols, and programming languages; and full
stack development practices.
ABILITY is required to schedule activities and/or meetings; gather, collate, and/or classify data; and consider a
variety of factors when using equipment. Flexibility is required to work with others in a variety of circumstances;
analyze data utilizing defined but different processes; and utilize equipment under a variety of conditions for multiple
purposes. Ability is also required to work with a diversity of individuals and/or groups; work with data of varied types
and/or purposes; and utilize a variety of types of job-related equipment. Problem solving is required to identify issues
and create action plans. Problem solving with data frequently requires independent interpretation of guidelines; and
problem solving with equipment is moderate to significant. Specific ability based competencies required to
satisfactorily perform the functions of the job include: utilizing pertinent software applications; applications (e.g. Java script, AJAX,
SQL. PHP, Java, XML, JSP,ASP, KHTML, C#, Python, etc.); programming using state-of-the-art programming
languages; communicating with persons of varied technical knowledge and backgrounds; establishing and
maintaining effective working relationships; working as part of a team; adapting to changing priorities; and applying
logical processes and analytical skills.
Responsibility
Responsibilities include: working under limited supervision using standardized practices and/or methods; leading,
guiding, and/or coordinating others; operating within a defined budget. Utilization of some 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.
Work Environment
The usual and customary methods of performing the job’s functions require the following physical demands: some
lifting, carrying, pushing, and/or pulling, and significant fine finger dexterity. Generally the job requires 98% sitting, 1%
walking, 1% standing. This job is performed in a generally clean and healthy environment.
Experience: Job related experience within a specialized field with increasing levels of responsibility is required
in software development and modern database technology.
Education: Targeted, job related education with study in job-related area with an emphasis in data science, software development.
Education (Preferred): Bachelor degree in data science, software development, or related field