Information Technology Specialist 5

State of Minnesota Board of Public Defense•Minneapolis, MN

13h

About The Position

Under the general direction of the Information Systems Director, the Information Technology Specialist V provides service in application system architecture, application support, computer programming, report writing and database management. This role ensures applications are scalable, reliable, available, and manageable by crafting the correct architecture to solve problems. It involves continuous research and review of current and projected solutions, working with internal and external IT staff to ensure best practices are followed, and providing work direction to external contractor application developers. The specialist will create and maintain the technical application architecture, work with external business partners on standardized integration solutions, and provide application support by responding to tickets and ad hoc report requests. Additionally, the role includes designing, coding, and implementing computer programs, creating and deploying new custom applications, databases, and reports, and performing analysis and modification of existing programs. The specialist will also analyze data and produce reports, develop customized reports from databases, monitor application performance, and be responsible for the performance, integrity, and security of agency databases. This includes creating and maintaining database documentation, managing and testing back-up and recovery plans, overseeing database development, and assessing new technologies.

Requirements

BE or BS Degree in Computer Science, Information Technology or related field preferred
2 years SSIS and SSAS experience
2-3 years IT operation with strong understanding of database structures, theories, principles, and practices
3-5 years Microsoft SQL Server experience
Minimum of 4 years working with systems design and support.
3 years' experience in complex relational data modeling
3 years of experience developing, testing and implementing new technical computer program solutions
Experience developing new and modifying SSRS reports
Experience in development and maintenance of T-SQL stored procedures, functions, and views to facilitate reporting
Experience with data management and data processing flowcharting techniques
Web API
JSON
Entity Framework
Reporting Writing Microsoft SQL Server
TSQL
Store Procedures
SSRS
RDL
Power BI
SSAS
Parameterized Reports and Report Designer
Microsoft SQL Server
Database Administration
Database Tuning
Database Management
Database Security
RDBMS
Knowledge of reporting and query tools and practices
API architecture
Relational data modeling
Experience working in a team-oriented, collaborative environment with ability to present ideas in user-friendly language
Extensive knowledge and experience with Systems Development Life Cycle methodologies.
Ability to prioritize and execute tasks in a high-pressure environment
Self-motivated and directed, with keen attention to detail with ability to plan, organize and work on multiple tasks simultaneously

Nice To Haves

Business Intelligence Analyst/Developer
Multi-dimensional and OLAP modeling, star schemas, OLAP cube database design and concepts, and ETL (SSIS).

Responsibilities

Ensures that applications are scalable, reliable, available and manageable.
Crafts the correct architecture to solve the problems at hand.
Provides continuous research and review of current and projected solutions to address the ongoing need for the agency.
Works with internal and external IT staff to ensure that best practices as identified for the agency are being followed.
Participates in the hiring of additional contract application developers as needed.
Provides work direction to external contractor application developers.
Creates and maintains the technical application architecture use by the BOPD.
Works with external business partners to establish and or maintain a standardized integration solution/process.
Provides application support.
Responds to support tickets for Production Applications as well as ad hoc report requests.
Design, code and implement computer programs for a variety of data processing needs.
Creates and deploys new custom applications, databases, computer programs and reports.
Perform analysis and modification of existing programs and operations to meet changing needs and to provide for system enhancements.
Write maintenance and user documentation to support programs.
Test and debug programs for accuracy and reliability.
Instruct program users in proper operation.
Provides estimates for additions/changes to Production Application.
Works on production issues as needed.
Analyze data and produce reports for a wide variety of applications.
Develop customized reports from databases to extract and collect data according to end user and or management needs.
Monitors application performance and provides solution and or recommendations on optimization as needed.
Responsible for the performance, integrity and security of all agency databases.
Creates and maintains database documentation, including data standards, procedures and definitions.
Responsible for managing and testing back-up and recovery plans for agency databases.
Oversee the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the agency.
Works on assigned projects designing and or deploying databases/tables, adding data fields and or tables to accommodate changes in agency needs.