Position Type: Professional/Technical/Senior Programmer Analyst Date Posted: 7/10/2024 Location: Instructional Support Center Date Available: 08/19/2024 Job Code: Senior Programmer Analyst - 020102 Standard Hours: 40 Department: Office of Data Governance - 282667 Empl Class: NA Minimum Salary: $75,438.00/Annually Maximum Salary: $110,783.00/Annually Scheduled Days: 245 Target Openings: 1   Job Description: Show/Hide License and Certification Qualifications: None required. Education Qualifications: High school diploma or equivalent required. Bachelor's degree in related field preferred. Experience Qualifications: Six years of experience in data integration development or similar work required. Experience with structured and unstructured data sets preferred. Experience with SQL required. Experience with C#, Python, and JavaScript preferred. Skills Qualifications: Demonstrates knowledge of Analysis; ability to analyze processes and identify areas for improvement; ability to translate logic to solve application problems; understanding of the Systems Development Process (Design, Debugging, Documentation, Testing, Maintenance); working knowledge of relational database design, including tables, views and indexes; ability to communicate effectively and to work well with others; strong organizational skills and the ability to multitask; ability to act as a representative of Gwinnett County Public Schools; and ability to work across functional boundaries and interact with employees at all levels of the organization. Primary Responsibilities: Responsible for the design, development, testing, and implementation of data integration between and among the various data stores and applications. 1. Support data integration by planning the delivery of solutions and answering technical and procedural questions. 2. Analyze data sources; define, analyze and validate data objects; identify the relationship among data objects. 3. Deliver data singularity by integrating data shared across legacy, new development, and purchased package environments. 4. Develop and modify functions, programs, routines, and stored procedures to export, transform, and load data. 5. Validate data integrity by documenting operational procedures and data connections. 6. Understand and use SQL databases (Structured Query Language), and utilize JSON (Java Script Object Notation) as well as APIs (Application Programming Interface). 7. Monitor and process inbound and outbound data files leveraging available tools and reporting. 8. Improve data integration by investigating and supporting new data interchange formats, standards, and procedures. 9. Update job knowledge by tracking new strategies and technologies; participating in educational opportunities; reading professional publications. 10. Perform other duties as assigned. Physical Demands: While performing the duties of this job, the employee is frequently required to sit for extended periods of time. The employee is also required to talk, hear, stand, and walk. The employee may be required to use hands to touch, handle, feel, and/or reach. The employee is occasionally required to stoop, kneel, or crouch. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, depth perception, and ability to adjust focus. Possible prolonged exposure to cold and noise in a server machine room. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function