Data Engineer
Apply NowCompany: Rockford Public School District #205
Location: Rockford, IL 61107
Description:
Position Type:
Technology/Engineer
Date Posted:
10/9/2023
Location:
Administration - Information Technology/Services
Job Title: Data Engineer
Department: Information Services
Supervisor: Director of Information Services
Date: 9/19/2023
FLSA Status: Exempt
Grade: 16
PURPOSE OF THE POSITION: The Data Engineer will play a crucial role in managing and optimizing our data infrastructure, focusing on the IBM Cognos platform, data warehousing, data lakes, and reporting.
SUPERVISORY RESPONSIBILITIES: None
DUTIES AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. In addition to the requirements listed below, regular attendance is an essential function of this position.Ensures that all actions are in concert with the Board policies as well as the mission statement, beliefs, objectives, and parameters found in the Board's strategic plan. Participates in job training and professional growth opportunities in order to enhance ability to perform the essential functions of the job. Performs other related duties as assigned for the purpose of ensuring an efficient and effective work environment. Design, develop, and maintain data pipelines to collect, process, and transform data from various sources into a structured format. Manage and configure data lakes, ensuring data accessibility, security, and performance. Develop and maintain widgets and reports using the IBM Cognos platform to provide actionable insights to educational stakeholders. Collaborate with cross-functional teams to gather data requirements and translate them into technical solutions. Implement data quality checks and ensure data accuracy and integrity. Troubleshoot and optimize data engineering processes for improved performance and efficiency. Stay current with emerging data engineering technologies and best practices to recommend and implement improvements. Provide technical guidance and mentorship to various IT/IS colleagues as needed. QUALIFICATIONS: Bachelor's degree in Computer Science, Information Technology, or a related field required. Master's degree preferred. Certified in IBM Cognos, IBM Certified Data Engineer or similar certification preferred or the commitment to obtain certification within the first 90 days. Minimum of 5 years of experience as a Data Engineer or similar position, with a focus on the IBM Cognos platform. KNOWLEDGE, SKILLS, AND ABILITIES: Ability to demonstrate qualities aligned to our core values of Character, Communication, Collaboration and Continuous Improvement. Ability to work independently and as part of a team. Excellent communication and interpersonal skills. Proficiency in data warehousing concepts and ETL processes. Strong SQL and scripting skills (e.g., Python, Java, or Scala). Experience with data modeling and data visualization tools. Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP). Deep understanding of data engineering best practices Experience in K-12 education is helpful. WORK CALENDAR: 12 Months
WORKING CONDITIONS: Moderate in-district travel as well as intermittent in-state and out-of-state travel. Intermittent prolonged and irregular hours of work.
OTHER: This job description describes duties and responsibilities which are representative of the nature and level of work assigned to the position. The identified duties and responsibilities are intended only as illustrations of the various types of work that may be performed. The omission of specific duties does not exclude them from the position.
The job description does not constitute an employment agreement between the school district and employee and is subject to change by the school district as the needs of the school district and requirements of the job change.
Physical Aspects of the Position
1.
Climbing - Ascending or descending ladders, stairs, scaffolding ramps, poles and the like, using feet and legs and/or hands and arms. Body agility is emphasized.
2.
X
Balancing - Maintaining body equilibrium to prevent falling when walking, standing or crouching on narrow, slippery or erratically moving surfaces.
3.
Stooping - Bending body downward and forward by bending spine at the waist.
4.
Kneeling - Bending legs at knee to come to a rest on knee or knees.
5.
Crouching - Bending the body downward and forward by bending leg and spine.
6.
Crawling - Moving about on hands and knees or hands and feet.
7.
X
Reaching - Extending hand(s) and arm(s) in any direction.
8.
Standing - Particularly for sustained periods of time.
9.
X
Walking - Moving about on foot to accomplish tasks, particularly for long distances.
10.
Pushing - using upper extremities to press against something with steady force order to thrust forward, downward, or outward.
11.
Pulling - Using upper extremities to exert force in order to draw, drag, haul or tug objects in a sustained motion.
12.
Lifting - Raising objects from a lower to a higher position or moving objects horizontally from position to position. This factor is important if it occurs to a considerable degree and required the substantial use of upper extremities and back muscles.
13.
X
Finger use - Picking, pinching, typing or otherwise working, primarily with the fingers rather than the whole hand or arm as in handling.
14.
X
Grasping - Applying pressure to an object with the fingers or palm.
15.
X
Talking - Expressing or exchanging ideas by means of spoken word. Those activities in which you must convey detailed or spoken instructions to other workers accurately, loudly, or quickly.
16.
X
Hearing - Perceiving the nature of sounds. Ability to receive detailed information through oral communication, and to make fine discriminations in sounds such as when making fine adjustments on machinery.
17.
X
Repetitive Motions - Substantial movements (motions) of the wrist, hands, and/or fingers.
The Physical Requirements of the Position
1.
X
Sedentary Work - Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, push, pull or otherwise move objects, including the human body. Sedentary Work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
2.
Light Work - Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects. If the use of arm and/or leg controls requires exertion of force greater than that for sedentary work and the worker sits most of the time, the job is rate for Light Work.
3.
Medium Work - Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
4.
Heavy Work - Exerting up to 100 pounds of force occasionally, and/or up to 50 pounds of force frequently, and/or up to 20 pounds of force constantly to move objects.
5.
Very Heavy Work - Exerting in excess of 100 pounds of force occasionally, and/or in excess of 50 pounds of force frequently, and/or in excess of 20 pounds of force constantly to move objects.
The visual acuity requirements including color, depth perception and field of vision
1.
X
Machine Operations - inspection, close assembly, clerical, administration. This is a minimum standard for use with those whose work deals largely with preparing and analyzing data and figures, accounting, transcription, computer terminal, extensive reading, or visual inspection.
2.
Mechanics - Skilled tradespeople - This is a minimum standard for use with those whose work deals with machines such as power tools, lathes, and drills.
3.
Mobile Equipment - This is a minimum standard for use with those who operate cars, trucks, forklifts, cranes, and high equipment.
4.
Other - This is a minimum standard based on the criteria of accuracy and neatness of work for janitors, sweepers, etc.
The Conditions the Worker will be subject to in this position
1.
X
The worker is subject to inside environment conditions.
2.
X
The worker is subject to outside environment conditions.
3.
The worker is subject to extreme heat or cold for periods of greater than one hour.
4.
The worker is subject to noise which would cause them to have to shout.
5.
The worker is subject to hazards: Includes a variety of physical conditions, such as proximity to moving mechanical parts, electrical current, chemicals, etc.
Technology/Engineer
Date Posted:
10/9/2023
Location:
Administration - Information Technology/Services
Job Title: Data Engineer
Department: Information Services
Supervisor: Director of Information Services
Date: 9/19/2023
FLSA Status: Exempt
Grade: 16
PURPOSE OF THE POSITION: The Data Engineer will play a crucial role in managing and optimizing our data infrastructure, focusing on the IBM Cognos platform, data warehousing, data lakes, and reporting.
SUPERVISORY RESPONSIBILITIES: None
DUTIES AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. In addition to the requirements listed below, regular attendance is an essential function of this position.
WORKING CONDITIONS: Moderate in-district travel as well as intermittent in-state and out-of-state travel. Intermittent prolonged and irregular hours of work.
OTHER: This job description describes duties and responsibilities which are representative of the nature and level of work assigned to the position. The identified duties and responsibilities are intended only as illustrations of the various types of work that may be performed. The omission of specific duties does not exclude them from the position.
The job description does not constitute an employment agreement between the school district and employee and is subject to change by the school district as the needs of the school district and requirements of the job change.
Physical Aspects of the Position
1.
Climbing - Ascending or descending ladders, stairs, scaffolding ramps, poles and the like, using feet and legs and/or hands and arms. Body agility is emphasized.
2.
X
Balancing - Maintaining body equilibrium to prevent falling when walking, standing or crouching on narrow, slippery or erratically moving surfaces.
3.
Stooping - Bending body downward and forward by bending spine at the waist.
4.
Kneeling - Bending legs at knee to come to a rest on knee or knees.
5.
Crouching - Bending the body downward and forward by bending leg and spine.
6.
Crawling - Moving about on hands and knees or hands and feet.
7.
X
Reaching - Extending hand(s) and arm(s) in any direction.
8.
Standing - Particularly for sustained periods of time.
9.
X
Walking - Moving about on foot to accomplish tasks, particularly for long distances.
10.
Pushing - using upper extremities to press against something with steady force order to thrust forward, downward, or outward.
11.
Pulling - Using upper extremities to exert force in order to draw, drag, haul or tug objects in a sustained motion.
12.
Lifting - Raising objects from a lower to a higher position or moving objects horizontally from position to position. This factor is important if it occurs to a considerable degree and required the substantial use of upper extremities and back muscles.
13.
X
Finger use - Picking, pinching, typing or otherwise working, primarily with the fingers rather than the whole hand or arm as in handling.
14.
X
Grasping - Applying pressure to an object with the fingers or palm.
15.
X
Talking - Expressing or exchanging ideas by means of spoken word. Those activities in which you must convey detailed or spoken instructions to other workers accurately, loudly, or quickly.
16.
X
Hearing - Perceiving the nature of sounds. Ability to receive detailed information through oral communication, and to make fine discriminations in sounds such as when making fine adjustments on machinery.
17.
X
Repetitive Motions - Substantial movements (motions) of the wrist, hands, and/or fingers.
The Physical Requirements of the Position
1.
X
Sedentary Work - Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, push, pull or otherwise move objects, including the human body. Sedentary Work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
2.
Light Work - Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects. If the use of arm and/or leg controls requires exertion of force greater than that for sedentary work and the worker sits most of the time, the job is rate for Light Work.
3.
Medium Work - Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
4.
Heavy Work - Exerting up to 100 pounds of force occasionally, and/or up to 50 pounds of force frequently, and/or up to 20 pounds of force constantly to move objects.
5.
Very Heavy Work - Exerting in excess of 100 pounds of force occasionally, and/or in excess of 50 pounds of force frequently, and/or in excess of 20 pounds of force constantly to move objects.
The visual acuity requirements including color, depth perception and field of vision
1.
X
Machine Operations - inspection, close assembly, clerical, administration. This is a minimum standard for use with those whose work deals largely with preparing and analyzing data and figures, accounting, transcription, computer terminal, extensive reading, or visual inspection.
2.
Mechanics - Skilled tradespeople - This is a minimum standard for use with those whose work deals with machines such as power tools, lathes, and drills.
3.
Mobile Equipment - This is a minimum standard for use with those who operate cars, trucks, forklifts, cranes, and high equipment.
4.
Other - This is a minimum standard based on the criteria of accuracy and neatness of work for janitors, sweepers, etc.
The Conditions the Worker will be subject to in this position
1.
X
The worker is subject to inside environment conditions.
2.
X
The worker is subject to outside environment conditions.
3.
The worker is subject to extreme heat or cold for periods of greater than one hour.
4.
The worker is subject to noise which would cause them to have to shout.
5.
The worker is subject to hazards: Includes a variety of physical conditions, such as proximity to moving mechanical parts, electrical current, chemicals, etc.