Database Developer - Instructional Support Facility

FLSA:   Exempt

• SALARY SCHEDULE: Link to https://www.cherrycreekschools.org/Page/2906 Professional Technical Salary Schedule 
• PAY GRADE: Range 8 

BENEFITS:
Our employee benefits package includes medical insurance, dental insurance, vision insurance, health savings accounts, flexible spending accounts, life insurance, accidental death and dismemberment, long term disability, critical illness insurance, and accident insurance. Visit our website for full details.

• SUPERVISOR:
• Director or designee. 

SUMMARY:  
Maintain accuracy and quality of data collected from District users and systems. Design, build, maintain databases and produce reports. Collect and retrieve data from multiple sources. Perform query/report writing and other statistical elements.

DUTIES AND RESPONSIBILITIES:
Duties and assignments may vary based on building assignment, academic year, and school needs. The following frequencies and percentages of time spent are approximations only.

• Design and develop ETL/ELT solutions for managing data movement in, out of and between various data systems, platforms, and file types and moving and transforming data for ODS, Staging, and Data Warehousing. [Daily, 15%]
• Map out the conceptual design for a planned database. Refine the logical design so that it can be translated into a specific data model using relational database concepts, data modeling, and design. [Daily, 15%]
• Create, perform, and manage routine data operations in bulk (replication, distribution, import, export, reporting, warehousing, purging, and archival, etc.) and in detail (record error corrections, new code assignments, etc.). [Daily, 10%]
• Maintain data standards, including adherence to data protection as defined by the District. [Daily, 10%]
• Track usage, performance, integrity, security, and incidents of critical applications for the purpose of making improvement and planning changes. [Daily, 10%]
• Assist in the development and manage the implementation of data policy decisions, data collection rules, business rules, integrity measures, security measures, etc. [Daily, 10%]
• Address long-term and strategic data issues such as coding schemes, data mapping, data structures, archival data formats, data integration and migration, data mining and analysis, coordination of data interactions on multiple platforms, and user training. [Daily, 10%]
• Consider both back-end organization of data and front-end accessibility for end-users. [Daily, 5%]
• Work with users to troubleshoot, design, and create interim solutions as needed. [Daily, 5%]
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata). [Daily, 5%]
• Perform other related duties as assigned or requested. [Daily, 5%] 

Minimum Qualifications:

• • Bachelor's degree in Information Technology or related field. 
• Intermediate knowledge of typical office equipment such as telephones, copiers, fax machines, email, etc.
• Information technology experience. Intermediate knowledge of Microsoft Office.
• Intermediate English language skills.
• Intermediate level of understanding of reporting principles and practices.
• Advanced analytical/technical skills to collect and prepare productivity data, etc.
• Advanced oral and written communication skills.
• Advanced interpersonal relations skills.
• Ability to work alone and with others.
• Ability to exercise good judgment, problem solving ability, and resourcefulness in the absence of formalized guidelines.
• Ability to identify, analyze, and resolve business issues through solution-oriented projects.
• Ability to coordinate diverse administrative tasks requiring advanced organizational skills.
• Ability to work efficiently under conditions of multiple deadlines and changing priorities. 
• REQUIRED EXPERIENCE, CERTIFICATES, LICENSES, AND REGISTRATIONS:
• All certifications, licenses, and registrations must be valid and unexpired.
• Criminal background check and fingerprinting required for hire.
• Five (5) years of experience with MS SQL Server Administration. 

Preferred Qualifications:

• Experience with SQL querying and reporting.
• Experience with C# programming.
• Experience with relational database design.
• Experience with Tableau, SSRS, and SSIS.
• Knowledge of data security.

Physical And Mental Demands/Work Environment:

• Sedentary work.
• Light physical effort (lifting up to 10 pounds).
• Eye/hand coordination (e.g., typing, ten key).
• Visual concentration.
• Concentrated reading/writing/mathematics.
• Occasional lifting, pulling, and/or pushing.
• Normal school district environment.

Last Updated:  2020/2021

.cs95E872D0{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt} .cs393807C9{color:#000000;background-color:transparent;font-family:Calibri;font-size:10pt;font-weight:bold;font-style:normal;} .cs887C2D5B{color:#000000;background-color:transparent;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:normal;} .csDF797851{color:#000000;background-color:transparent;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:normal;text-decoration: none;} .cs8138E5D8{color:#0000FF;background-color:transparent;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:normal;text-decoration: underline;} .cs44694EDE{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto} .cs87FCDD7D{color:#000000;background-color:transparent;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:italic;} .csDC062E5{color:#000000;background-color:#FFFFFF;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:normal;} .cs31AF52D0{text-align:left;text-indent:-18pt;margin:0pt 0pt 0pt 18pt} .csEC316DA9{color:#000000;background-color:#FFFFFF;font-family:Calibri;font-size:10pt;font-weight:normal;font-style:italic;} .csF70856CC{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 18pt} .cs6B0DEBED{color:#000000;background-color:#FFFFFF;font-family:Arial;font-size:9pt;font-weight:normal;font-style:normal;}