Programmer Analyst IV - 530329

The University of Alabama•Tuscaloosa, AL

2d•Hybrid

About The Position

The Programmer Analyst IV designs, develops, supports, and codes high-complexity and enterprise software systems to support the administrative function of the University under minimal supervision. Develops processes and web applications. Creates workflows. Installs, customizes, supports, and creates integrations for vendor-supplied software systems. Works on a team and collaborates with specific departments, colleges, and customers around campus. Supports their needs, troubleshooting and resolving issues, and responding to their questions and concerns in a timely manner. This lead-level position is a part of the IT Collaboration & Reporting team, which primarily designs, supports, and develops data integration platforms, reporting infrastructures, and automation solutions. The team develops reporting solutions utilizing tools such as Microsoft Fabric and Power BI, and Argos; develops processes utilizing Atlassian’s Cloud Suite; and supports vendor-supplied software systems, including Visix Signage Suites and the Boomi iPaaS. This position is expected to be both the primary and secondary support person for various applications and processes. Additionally, this position is expected to act as a mentor and help train lower-level team members and be the technical lead on projects of moderate to high complexity.

Requirements

Master's degree and four (4) years of IT programming experience; OR bachelor's degree and six (6) years of IT programming experience; OR associate's degree and eight (8) years of IT experience to include six (6) years of IT programming; OR high school diploma or GED and ten (10) years of IT experience to include six (6) years of IT programming.
An aptitude for solving problems, being self-motivated, desire to learn and improve skills, resourceful, finding ingenious solutions, and managing highly complex assignments and systems.
High level of experience supporting complex systems and troubleshooting application issues.
High level of experience with working with customers, gathering and analyzing requirements.
Expert level experience with relational databases and ability writing and analyzing SQL queries and reports; preferably with Oracle, MS SQL, or MySQL; and ability to analyze table data structures and patterns in the data to gain insights.
Expert level experience with the creation and management of database and data warehouse objects including tables, triggers, indexes, and procedures and processes, including SSIS.
Substantial level of programming knowledge and ability, with languages such as Oracle PL/SQL and scripting languages such as Python.
High level of experience with ETL tools and data management principles.
The ability to effectively communicate, both verbally and in writing, and work with customer groups and users of varying degrees of technical ability and understanding.
The ability to manage work tasks using Atlassian JIRA tickets and follow through to completion.
Effective time management skills and ability to work on multiple projects simultaneously.
Troubleshooting skills to independently learn of, analyze, track, and resolve issues.

Nice To Haves

Familiarity with ETL/ELT processes and other data warehousing techniques.
Familiarity with data warehousing platforms such as MS Fabric, and reporting tools such as Power BI.
Expert level experience supporting University of Alabama administrative applications and tools, such as MS Fabric, Power BI, Atlassian Cloud Suite, or integration tools such as Boomi.
Experience with advanced BI analytic concepts, including OLAP, data warehousing, data lakes, scaling and performance tuning, and dashboard design.
Experience with other programming concepts and tools including restful APIs; shell, Powershell, and Python scripting; Git versioning; and managing flat file data feeds.

Responsibilities

Designs, develops, supports, and codes high-complexity and enterprise software systems.
Develops processes and web applications.
Creates workflows.
Installs, customizes, supports, and creates integrations for vendor-supplied software systems.
Collaborates with specific departments, colleges, and customers around campus.
Supports customer needs, troubleshooting and resolving issues, and responding to their questions and concerns.
Designs, supports, and develops data integration platforms, reporting infrastructures, and automation solutions.
Develops reporting solutions utilizing tools such as Microsoft Fabric and Power BI, and Argos.
Develops processes utilizing Atlassian’s Cloud Suite.
Supports vendor-supplied software systems, including Visix Signage Suites and the Boomi iPaaS.
Acts as a mentor and helps train lower-level team members.
Acts as the technical lead on projects of moderate to high complexity.
Implements critical third-party applications, analyzing installation and configuration documentation, to successfully install and take on support for an application.