ANALYST I, SENIOR PROGRAMMER - DATA WAREHOUSE

Uses a deep understanding of SQL Server programming to perform computer programming tasks, writing, testing, and optimizing code, documenting workflows, and creating technical documentation to ensure systems operate efficiently and meet end-user needs. Assists with system and data analysis to quickly troubleshoot and resolve technical issues related to applications and application code. Facilitates the extraction, transformation, and loading of data from various sources into the data warehouse. Provides direct written and verbal technical support to end-users and staff, leveraging technical skills to address and resolve issues and requests.

The salary range is $67,340 - 96,891 (12-months/260 days)

This position may allow for a hybrid remote work schedule (work from home for a portion of the workweek) within the state of Wisconsin.

Administrative applications for the following position are being accepted by the Office of Human Resources no later than Monday, September 23, 2024. A current resume and transcripts confirming a Bachelor's Degree must be attached to the completed application (if you are unable to electronically attach these documents, you must notify human resources that you are sending hard copies which must be received on or before the deadline date listed above). Caution: When attaching documents to the application, be sure the documents are legible. If the documents cannot be read, your application may be disqualified from consideration. If you are selected for the next stage of the interview process, you will be asked to request three electronic professional references. No applications will be accepted after the deadline date and time. Appointment is subject to a criminal background check, a drug/alcohol test and credential verification.

As of November 1, 2021, all MPS employees are required to be fully vaccinated. The health and safety of our staff and students is our number one priority. That's why all offers of employment are contingent on the candidate showing proof of being fully vaccinated against COVID-19 (currently one dose of the Johnson & Johnson vaccine or two doses of the Pfizer or Moderna vaccine) to pass the pre-employment requirements. Individuals with medical issues or sincerely held religious beliefs that prevent them from getting the vaccine may request an accommodation from the vaccine requirement.

• Bachelor's Degree in Computer Science, Information Technology, Software Engineering or a related field is required.
• A combination of education and experience will be considered.
• Minimum of 2-4 years programming experience is required.
• Strong SQL skills are fundamental to all aspects of this role with experience writing and understanding complex queries, functions, and stored procedures.
• Experience with ETL processes and data warehousing.
• Proficiency in using SSMS or equivalent tools for querying, managing, and analyzing databases.
• Experience with writing and deploying SQL Server Integration Services (SSIS) packages is a plus.
• Demonstrates proficiency in analyzing and understanding existing codebases, including deciphering complex code structures and identifying key components and logic.
• Competent in using Microsoft Office applications to enhance productivity and support team collaboration.
• Ability to troubleshoot and debug data, software, and system issues with minimal supervision.
• Excellent problem-solving skills and attention to detail.
• Exhibits the ability to break down complex problems into manageable parts.
• Basic project management skills to prioritize and manage multiple tasks, timelines, and workload effectively.
• Ability to explain technical concepts to non-technical stakeholders.
• Capability to document workflows and write technical and system specifications.
• Evidence of strong communication and organizational skills.
• Motivation to learn new technologies quickly with minimal support and guidance.
• Ability to work both independently and in a team environment and follow instructions.

• Ability to write, test, and maintain code according to operational guidelines, best practices, and district standards.
• Participates in writing and optimizing SQL queries to retrieve data for analysis, reporting and distribution to end-users under the direction of more senior programmers and analysts.
• Interprets, reviews, and makes modifications to pre-existing code structures.
• Integrates data from multiple sources, including databases, flat files, and external systems.
• Analyzes and documents system requirements, workflows, and data warehouse processes.
• Develops procedures and scripts for data migration.
• Assists in coding, debugging, and testing nightly build procedures and data warehouse integrations.
• Troubleshooting code and software applications to identify, analyze, and resolve technical issues promptly.
• Monitoring and enforcing data quality standards to ensure accuracy, consistency, and completeness of data.
• Implementing data validation and cleansing routines to correct data discrepancies in the data warehouse.
• Learns new technologies and maintains familiarity with existing application languages demonstrating ability to adapt to changing requirements or environments.
• Participates in professional training activities as directed.
• Ensures compliance with all district policies, data governance policies and regulatory requirements.
• Attends meetings as requested to provide technical expertise and advice.
• Actively supports the MPS Strategic Plan.
• Performs additional tasks and duties as required.

The Milwaukee Public Schools does not discriminate in its programs, activities, facilities, employment, or educational opportunities on the basis of a person's sex, race, age, religion, color, national origin, ancestry, creed, pregnancy, marital or parental status, sexual orientation, or disability. Reasonable accommodations requested by qualified individuals with disabilities will be made in accordance with the Americans with Disabilities Act (ADA) of 1990, as amended by the Americans with Disabilities Act Amendments Act (ADAAA) of 2008.

In accordance with Wisconsin Statutes, every applicant for a position with Milwaukee Public Schools will be subject to the open records law. Any applicant not wishing to have his/her identity released, must submit a written statement to that effect to the Office of Human Resources. The identities of all "final candidates" may be released. Milwaukee Public Schools reserves the right to interview the best qualified candidates.