Information Technology Specialist 5

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., * 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.

Application Support:

• Provides application support. Responds to support tickets for Production Applications as well as ad hoc report requests.

Computer Programmer:

• 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.

Report Writer:

• 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.

Database Administrator:

• 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.

Knowledge, Skills and Abilities

Knowledge and Skills: Computer Programmer:

• Web API; JSON; Entity Framework;

Reporting Writing

• Microsoft SQL Server; TSQL; Store Procedures; SSRS; RDL; Power BI; SSAS; Parameterized Reports and Report Designer

Database Administrator

• Microsoft SQL Server; Database Administration; Database Tuning; Database Management; Database Security; and RDBMS
• Knowledgeofreportingandquerytoolsand practices
• Application System Architecture
• BusinessStrategyandhowtobestutilizetechnologytodrivethat strategy
• API architecture
• Relational data modeling
• Application Support
• Experienceworkinginateam-oriented,collaborative environment with abilitytopresentideasinuser-friendlylanguage
• ExtensiveknowledgeandexperiencewithSystemsDevelopmentLifeCycle methodologies.

Do you have experience in Technical solutions implementation?, Do you have a Bachelor's degree?, * Ability toprioritizeandexecutetasksinahigh-pressure environment

• Self-motivated and directed, with keen attention to detail with ability to plan, organize and work on multiple tasks simultaneously, * BE or BS Degree in one of the following subject areas: Computer Science, Information Technology or related ?eld preferred
• 2 years SSIS and SSAS experience
• 2-3years 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 ?owcharting techniques

Preferred Qualifications:

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

Pulled from the full job description

• Paid parental leave
• AD&D insurance
• Parental leave
• Health insurance
• Dental insurance
• Flexible spending account
• Life insurance, The State of Minnesota offers benefits through the State Employee Group Insurance Program (SEGIP). Benefits-eligible employees are entitled to the following insurance and pre-tax benefits:

Full time employee and part time employee benefits:

Medical insurance

Single coverage as low as $38.50 a month

Family coverage $262.66 a month

Dental insurance

Single coverage as low as $13.50 a month

Family coverage $55.40 a month

Basic Life insurance

6 week paid Parental Leave (eligible after 1 year of employment)

Retirement Savings

11 paid holidays

2 Floating holiday