What are the responsibilities and job description for the Senior Programmer/Analyst - Research & Accountability position at Arlington ISD?
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
