Fayette County Public Schools, KY
JOB DESCRIPTION – Data Engineer
To perform this job successfully, an individual must be able to perform the essential job functions satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary job functions herein described. Since every duty associated with this position may not be described herein, employees may be required to perform duties not specifically spelled out in the job description.
Data Engineer
Job Class Code: 8424
Position Type: Salary
Job Type: Classified
Pay Grade: Salary calculations are based on verified education and related experience levels
Reports To: Superintendent’s Designee
Supervises: N/A
Work Calendar Name: 12 month salard
Days in work calendar: 245
JOB SUMMARY
Develops mission critical processes to ensure district compliance with local, state, and federal regulations and requirements; Creates and maintains requested student information system reports for school and district personnel; Leads efforts around data management, validation, storage, and collection; Increases efficient and consistent access to data by developing queries, functions, and stored procedures
ESSENTIAL JOB FUNCTIONS
- Uses version control systems and documentation to maintain and distribute source code.
- Maintains business rules and technical documentation for data systems.
- Leads processes to ingest student assessment data from vendors and ensure data integrity and validity in the student information system.
- Develops reports for district and school personnel from student information system.
- Manages processes and requirements to fulfill Civil Rights Data Collection reporting requirements.
- Develops, maintains, and extends data models to store, manage, and access data efficiently.
- Works with program offices, school leaders, and IT staff to identify, specify, and manage data collection requirements and processes.
- Develop queries, functions, and stored procedures to ensure consistent and efficient data access for team members.
- Maintains knowledge of current data storage, management, and access technologies.
- Selects appropriate technologies for data storage, maintenance, and application development.
- Maintains current understanding of FERPA, HIPAA, and any/all other regulatory requirements regarding the protection of individually identifiable data.
- Develops and maintains reports in the Business Intelligence platform.
- Implements Software Development Life Cycle methodologies as appropriate.
- Demonstrates the ability to communicate in more than one language or the willingness to learn to communicate in more than one language at the novice level of proficiency.
- Performs other duties as assigned.
- Maintains regular attendance.
KNOWLEDGE OF:
- Agile SDLC methodology.
- Developing queries, functions, and stored procedures in SQL-based relational database management systems.
- Database performance tuning.
- Data system architectures, including the use of NoSQL technologies.
- Logical and physical data modeling.
- Business Intelligence and reporting tools.
- Git and/or GitHub/GitLab.
- Data governance.
- Use of SQL for data retrieval.
ABILITY TO:
- Learn federal, state, and local regulatory reporting requirements for school and district accountability, assessment, and special programs.
- Learn new programming languages/techniques, computing skills, software lifecycle development, and analytical methods to develop robust, efficient, and effective workflows.
- Determine best tools and technologies to use for data management and storage.
- Help business owners define business rules and processes used to manage the data systems.
- Effectively plan workflows to meet project deadlines and milestones.
- Train others in the District in their area of expertise.
- Communicate in writing and verbally to all stakeholder groups.
- Support publication of research with team members.
- Present work at professional conferences with other team members or independently.
QUALIFICATIONS
Education and Experience:
- Minimum of a Bachelor’s degree and demonstrated experience using SQL for data management and reporting. (Required)
- Bachelor’s Degree or higher in a program that included significant training in information systems, data architecture, data engineering, information technology, or computer science. (Preferred)
Licenses or Certifications:
Special Requirements:
N/A
PHYSICAL DEMANDS
- Work is performed while standing, sitting and/or walking
- Requires the ability to communicate effectively using speech, vision and hearing
- Requires the use of hands for simple grasping and fine manipulations
- Requires bending, squatting, crawling, climbing, reaching
- Requires the ability to lift, carry, push or pull light weights
Job Description Creation Date:
9/2016
Revision Date:
10/2024
The Fayette County Board of Education is an Equal Opportunity Employer. The Superintendent shall adhere to a policy of equal employment opportunity in all personnel matters. No person shall be subjected to discrimination in regard to employment, retention, promotion, demotion, transfer or dismissal because of race, color, religion, sex (including sexual orientation or gender identity), genetic information, national or ethnic origin, political affiliation, age or disabling condition or limitations related to pregnancy, childbirth, or related medical conditions.
Please see the salary schedule here.
A Salary Estimator is available here
Read Full Description