Fayette County Public Schools KY
JOB DESCRIPTIONData 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: Superintendents 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 Bachelors degree and demonstrated experience using SQL for data management and reporting. (Required)
- Bachelors 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.