> Markdown version of [/jobs/ext/190419-information-technology-specialist-5](https://www.wearedevelopers.com/jobs/ext/190419-information-technology-specialist-5). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Information Technology Specialist 5 - **Company:** State of Minnesota - **Location:** Minneapolis, MN, United States - **Experience:** Experienced - **Salary:** $152,088.0 - $178,848.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Software Applications, Application Performance Management, Software Documentation, Information Systems, Computer Programming, Databases, Data Governance, Extract Transform Load (ETL), Relational Databases, Database Design, Database Security, Database Storage Structures, Software Debugging, Entity Framework, JSON, Microsoft SQL Server, Online Analytical Processing, OLAP Cube, Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Transact-SQL, Data Processing, Database Optimization, Information Technology, Data Management, Api Design, Web Api - **Published:** May 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a20308e1b0240924 ## About the Role 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). ## Description 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)