The Operations and Innovation Services (OIS) Systems Management area within Community Corrections and Rehabilitation (DOCCR) department is seeking an Information Technology (IT) Engineer to assist with building structures and systems to ensure technical capacity for service delivery to business partners, focusing on the business intelligence and data warehouse disciplines using strong SQL development skills.

Location and hours:
This position is remote. Remote workers may be required to come on-site 0 to 12 days a year for work meetings, trainings, or for any other reasons that their supervisor may deem necessary (may include additional days for onboarding and new employee training). Supervisors will provide as much advance notice as practicable. Work hours will be Monday through Friday, with typical hours of 8 a.m. to 4:30 p.m. Based on business needs of this position, based on current requirements hires must reside in or relocate to Minnesota or Wisconsin.

About the position type:
This is a full-time benefit earning position. You must be a current regular or probationary employeeof Hennepin County to apply for this position. Note: Limited duration employees are not eligible.
This position is internally classified as an Information Technology (IT) Engineer.
Click here to view the job classification specification.

In this position, you will:

Serve as the database administrator for DOCCR, which includes managing the data warehouse, create databases for webforms, and build reports
Support system related releases and system outage resolutions
Collaborate effectively with data analyst team members, developers, technical teams, and business stakeholders
Design and develop stored procedures, views and functions using SQL development skills
Identify opportunities to optimize our environment ensuring efficiency and adherence to industry best practices related to security and infrastructure
Analyze manual processes, identify process bottlenecks, and effectively resolve them
Build repeatable automated and sustainable data migration (ETL) and reporting routines and processes for both on-premises and cloud
Provide guidance in modernizing legacy, maintenance, and automation processes
Interpret business needs to implement new solutions based on Hennepin County standards and industry best practices

Need to have:

One of the following:
- Four years of information technology experience.
- Associate/vocational/technical degree in computer science/engineering or a related information technology field and two years of information technology experience.
- Bachelor's degree in computer science, management information systems, data engineering, business Intelligence, data analytics or a related Information Technology field.
Certification or ability to be certified in a leading professional level certification area (ex: MCSA, MCSE, IBM, CDMP, etc.)

Nice to have:

Experience:
- In data architecture, data modeling, database administration, and security.
- Leading technical solution design in an environment that includes on prem and cloud infrastructure.
- Deploying applications in the cloud for internal and external users.
- Designing and building out cloud components.
- Applying and auditing SQL and Windows security.
- Working with automating processes, such as pipelines, flows, and power automate.
Ability to:
- Present and communicate reports on key performance indicators (KPIs) for service operations.
- Work with Enterprise Architecture to balance cost and efficiency related to software and infrastructure.
- Work with and support SQL database administration and IIS.
Knowledge of:
- Server/windows administration including migrating servers, databases, PowerShell, SQL scripting and automation (IAAS).

About the department:
The Department of Community Corrections and Rehabilitation (DOCCR) works to enhance community safety, promote community restoration, and reduce the risk of re-offense. Department staff and volunteers serve Hennepin County at more than 20 service locations ranging from correctional facilities to probation reporting offices and occupational training centers. The department delivers sustainable correctional services to more than 26,000 adult and juvenile clients. It is the largest community corrections organization in Minnesota. Learn more at www.hennepin.us/corrections.

About Hennepin County:
Hennepin is the largest county government organization in Minnesota. Our employees work every day to improve the health, safety and quality of life for our residents and communities. All of our jobs align with our mission to serve residents through transformative services that eliminate disparities, eliminate inequities, and create opportunity for all and our vision of a community where all people are healthy, all people are valued, and all people thrive.

Our employees receive a combination of competitive benefits and positive workplace culture not found at other organizations. This includes meaningful work that impacts our community, competitive pay, work-life balance, a variety of benefits and opportunities to grow. Learn more at The Bridge.

Hennepin County envisions an organization where our commitment to diversity and the elimination of disparities is fundamental in providing excellent service to our community.

Your future. Made here.

This posting may be used to fill current and future vacancies.

Watch this video for application best practices and tips.

This position may have access to systems or other documentation that may contain HIPAA data.

Invitations to interview will be based upon an assessment of education and experience. Final candidates will be required to complete a background check.

If you have any questions, please contact:

Talent Acquisition division
Hennepin County Human Resources department
Submit a request at hennepin.us/ask-hr or 612-348-7855

#LI-DNI

Hennepin County jobs

IT Database Engineer (Internal Hennepin County applicants only)