Data Warehouse Developer

Research & Evaluation

Support Staff - Position - Other - Other

Job Number : 4600240073

Start Date :

Open Date : 11/15/2021

Closing Date : 01/31/2022

POSITION SUMMARY

The Data Warehouse Developer is responsible for building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting by the Data and Analytics department. The incumbent builds data processing frameworks that handle the district's growing database. Designs, develops and implements statistical models to carry out various novel aspects of classification and information extraction from data. Leverages existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes. Analyzes data to spot anomalies, trends and correlate similar data sets. Designs, develops and implements natural language processing software modules. Troubleshoots problems, identifies possible solutions, and resolves accordingly.

ESSENTIAL DUTIES

• Serve as Tableau Server Administrator, providing highest level of technical support for Tableau
• Serve as AWS Administrator, providing highest level of technical support for AWS environment
• Develop and maintain ETL tools for data analysis
• Write and review complex sql scripts that extract data for analysis
• Conduct data analysis for forensic analysis to aid in accountability decisions
• Design, produce and maintain actionable data dashboards to inform key stake holders
• Require regular contact with outside agencies and vendors; may require contact with officials at higher levels (e.g., senior leaders at GADOE or GOSA)
• Investigate, review and evaluate new technology solutions for feasibility and compatibility with current technology solutions.
• Required to have prompt, regular attendance in-person or virtually and be available to work on-site, in-person during regular business hours, and as needed.

Requirements :

MINIMUM REQUIREMENTS

EDUCATION:
? Bachelor's degree required

CERTIFICATION/LICENSE:
?n/a

WORK EXPERIENCE:
? Minimum 5 years in data analysis

KNOWLEDGE, SKILLS & ABILITIES

• Analytical Thinking
• Ability to organize work in a precise manner
• Solves problems using clear logic from problem definition to solution
• Ability to concentrate for long periods of time and is relentless in pursuit of meaningful solutions

PHYSICAL ABILITIES AND WORKING CONDITIONS

The Physical Abilities and Other Conditions of Continued Employment listed in this section are representative of but are not intended to provide an exhaustive list of Physical Abilities and Other Conditions of Continued Employment which may be required of positions in this class. Atlanta Public Schools encourages persons with disabilities who are interested in employment in this class and need a reasonable accommodation of those disabilities to contact the Human Resources Department for further information.

Vision: Ability to read small print and view a computer screen for prolonged periods.

Hearing: Ability to tolerate exposure to noisy conditions

Speech: Ability to be understood in face-to-face communications, to speak with a level of proficiency and volume to be understood over a telephone or computer.

Upper Body Mobility: Ability to use hands to grasp and manipulate small objects; manipulate fingers, twist and bend at wrist and elbow; extend arms to reach outward and upward; use hands and arms to lift objects; turn, raise, and lower head.

Strength: Ability to lift, push, pull and/or carry objects which weigh as much as 15 or more pounds on a frequent basis.

Environmental Requirements: Ability to encounter constant work interruptions; work cooperatively with others; work independently; work indoors.

Mental Requirements: Ability to read, write, understand, interpret and apply information at a moderately complex level essential for successful job performance; math skills at a high school proficiency level; judgement and the ability to process information quickly; learn quickly and follow verbal procedures and standards; give verbal instruction; rank tasks in order of importance; copy, compare, compile and coordinate information and records. Understand how to manage stress

Additional Work Conditions & Physical Abilities: Will require travel to multiple sites.



Atlanta Public Schools assures Equal Employment Opportunities and equal education opportunities for employees and students as required by Federal and State Orders and Laws. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential tasks. This job description is intended to accurately reflect the position activities and requirements. However, management and administration reserves the right to modify, add, or remove duties and assign other duties as necessary. It is not intended to be and should not be construed as an all-inclusive list of all the responsibilities, skills, or working conditions associated with the position.

Compensation :

Salary Grade: 135

Salary Range: FY'21 APS Salary Schedule (All Positions)

Work Year: ANNUAL

FLSA Status : EXEMPT

Employment Category :
CLASSIFIED