Senior Programmer/Analyst - Research & Accountability

Job Description

ROLE AND PURPOSE:

Wrangle, clean, and transform complex data from multiple data sources into deliverables in various formats to drive strategic decision-making across the district. Continuously improve data quality and processes. Provide excellent customer service to other departments. The ideal candidate will combine strong technical skills with customer service skills to deliver high-quality data results and reporting solutions.

QUALIFICATIONS:

Education/Certification:

Bachelor's Degree or equivalent experience

Experience:

Three years of SQL programming experience in a database environment

Three years of experience with database design, implementation, and performance tuning

SPECIAL KNOWLEDGE AND SKILLS (REQUIRED):

Strong SQL skills working with Microsoft SQL Server and IBM DB2 databases

Experience with Database tools including SQL Management Studio

Strong Excel skills

Strong analytical and problem-solving skills

Ability to organize and prioritize workload

Excellent oral and written communications skills

Proficient in creating documentation and providing training as required

(Preferred)Experience with Power BI and SQL Serve Integration Services (SSIS)

(Preferred)Experience with Frontline ERP/SIS software (Formerly Prologic TEAMS)

(Preferred)Knowledge of SQL Server administration and Windows server administration

(Preferred)Experience with Microsoft Visual Studio, C#, ASP.NET Core, HTML, CSS, and JavaScript

(Preferred)Promote and maintain positive morale among department, district, and campus employees

(Preferred)Continually look for ways to improve processes/procedures that result in increased efficiency

MAJOR RESPONSIBILITIES AND DUTIES:

Identifies, prioritizes, and executes data reporting processes including data retrieval, preprocessing, analyses, visualization, and reporting for varying levels of stakeholders with fluctuating degrees of ambiguity.

Wrangle data from multiple data sources (e.g., SQL Server, independent spreadsheets, external databases, etc.) into a single source aligned to project needs.

Create and maintain SQL views, functions, and stored procedures

Automate processes using SQL, PowerShell, batch script, and other programming languages

Design, build, and maintain Power BI reports used to monitor the performance of cross-departmental initiatives

Document data processing routines for recurring data reports to decrease turnaround time, increase accuracy, establish standardization, and provide training as necessary

Identify problems and areas of improvement

Provide outstanding customer service on the phone, in person, and through written communication

Appropriately escalate unresolved issues and/or concerns to next level of support

Perform other duties as may be assigned by supervisor

Full-time