IT Engineer

Description

Hennepin County's Information Technology (IT) department is seeking an IT Engineer to join the Enterprise Business Intelligence team. This position will collaborate with technologists from all areas of the organization and help the team define and expand our work. Our key candidate brings a technical background in the ELT/ETL space, excitement for learning, and the ability to elevate technical curiosity within the team.

Current Hennepin County employees who refer a candidate hired into an open competitive position may be eligible for a $500 referral bonus. For more information visit employee referral program.

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 between 7 a.m. to 5 p.m. Based on business needs of this position, hires must live in or relocate to Minnesota.

New employees who are hired into remote or hybrid positions between January 2, 2022 to December 31, 2024, will receive $500 toward the cost of establishing consistent internet connectivity, payable upon completion of 6 months of employment.

About the position type:

This is a full-time, benefit-earning position.

This position is internally classified as an Information Technology (IT) Engineer - IT Database Engineer. Click here to view the job classification specification.

At this time, employees may be eligible to receive an additional cash merit of up to $2,079.11 that can be earned annually based on performance.

In this position, you will:

• Administer and support interface tools including appropriate system data models, workflows, API's, ETL, data warehouse and integrations.

• Design and develop cloud services and sustainable data structures in a data warehouse and/or data lake for the organization, enforce design standards and managing access and file-level permissions.

• Research new data technologies, tunes resources to efficiently meet the needs of analytics activities, monitors and maintains resource availability.

• Implement, monitor, and maintain complex data pipelines, manipulate data to prepare for analytics workloads, and load data into data stores for consumption by developers and analysts.

• Provide backup and support for the Senior IT Data Engineers, troubleshoot, and resolve root cause problems on complex data systems.

• Promote business intelligence best practices around data governance, security and quality, metadata management, data modeling, ETL and ELT, reporting and visualization technologies; stay current with data technologies to ensure Hennepin County Business Intelligence practices are in-line with the evolvement of consumer needs and technological resources.

Need to have:

One of the following:

• Four years or more of information technology experience.

• Associate/vocation/technical degree in computer science/engineering or a related information technology field and two years or more 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.

AND

• Current certification in a leading professional level certification area (e.g., Microsoft, Cisco, CompTIA, Infoblox Core DDI, etc.).

Nice to have:

• Two years or more of experience in data storage solutions for efficient reporting.

• One year or more of experience developing ETL in SQL Server Integrations Services (SSIS), Azure Data Factory, Azure Synapse, or any other market leading ETL tools.

• Experience:

• Scripting/coding with one or more of the following: PowerShell, PL/SQL, T-SQL, Python, R, DAX, M, or Kusto language.

• Developing reports in SQL Server Reporting Services (SSRS), Power BI, or any other reporting tools.

• Administering tool(s) specific to PowerBI, Cognos, SSRS, Planning Analytics, or SQL.

• Managing data storage solutions such as databases and/or data lakes.

About the department:

Technology is the foundation of our work - and the work of every county employee. The Information Technology department is here to help our employees work smarter, faster and better. It is made up of 9 divisions: Business Solutions, Service Management Office, Architecture, Central Services Administration & Imaging Operations, Enterprise Development, IT Finance & Support Services, Operations, IT Strategic Alignment, and IT Security.

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 to one or more of our overarching goals -- that Hennepin County residents are healthy, protected and safe, self-reliant, assured due process, and mobile.

Our employees receive a combination of generous 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 reduction 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 documentation that contains HIPAA data.

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

If you have any questions, please contact:

Toufue Vue

toufue.vue@hennepin.us

#LI

Why work here?

Hennepin County embraces the Total Rewards philosophy. We want our employees to succeed - not only at work but as they move through life and its milestones. We offer advantages and opportunities others can't - including:

• Meaningful work

• Public service

• Competitive pay

• Work-life balance

• Generous benefits

• Opportunities to grow

• Commitment to your success

By working in public service, we are a part of something larger than ourselves. Together, we support those in need. We help people access information and services. We empower vibrant and diverse communities. We serve residents.

Employee Benefits Summary

Visit our benefits page to learn more: bridge.hennepin.us/eligibility.

If you are a current Hennepin County employee please be aware that any change in job classification may affect your current benefits (such as a conversion from Vacation/Sick Leave to Paid Time Off and/or enrollment in a Health Care Saving Plan.) Information about the impact of job changes on benefits can be found here.

01

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 between 7 a.m. to 5 p.m.

Based on business needs of this position, hires must live in or relocate to Minnesota

Are you able and willing to meet these requirements?

• Yes

• No

02

Which of the following best describes your education and experience in relation to this position? Check all that apply.

• I have four years or more of information technology experience

• I have an associate/vocation/technical degree in computer science/engineering or a related information technology field and two years or more of information technology experience

• I have a bachelor's degree in computer science, management information systems, data engineering, business intelligence, data analytics or a related information technology field

• None of the above

03

Have you completed a certification in a leading professional level certification area (e.g., Microsoft, Cisco, CompTIA, Infoblox Core DDI, etc.)?

• Yes

• No

04

Describe your relevant education, including area(s) of study, school(s) attended, degree(s) earned and current certification in a leading professional level certification. If you do not have any relevant education and/or certification, type "None" in the space provided.

05

How many full-time equivalent years of IT experience do you have?

• I do not have this experience

• Less than 2 years

• 2 years or more, but less than 4 years

• 4 years or more

06

Describe your full-time equivalent IT experience, referencing positions listed on your application/resume. If you do not have this experience, type "None" in the space provided.

07

Do you have two years or more of experience in data storage solutions for efficient reporting?

• Yes

• No

08

Describe your experience in data storage solutions for efficient reporting, referencing positions listed on your application/resume. If you do not have this experience, type "None" in the space provided.

09

Do you have one year or more of experience developing ETL in SQL Server Integrations Services (SSIS), Azure Data Factory, Azure Synapse, or any other market leading ETL tools?

• Yes

• No

10

Describe your experience developing ETL in SQL Server Integrations Services (SSIS), Azure Data Factory, Azure Synapse, or any other market leading ETL tools, referencing positions listed on your application/resume. If you do not have this experience, type "None" in the space provided.

11

Which of the following do you have experience scripting/coding with? Check all the apply.

• DAX
• Kusto language
• M
• PowerShell
• PL/SQL
• Python
• R
• T-SQL
• None of the above

12

Describe your experience scripting/coding with the options you've selected from above, referencing positions listed on your application/resume. If you do not have this experience, type "None" in the space provided.

13

Do you have experience developing reports in SQL Server Reporting Services (SSRS), Power BI, or any other reporting tools?

• Yes

• No

14

Describe your experience developing reports in SQL Server Reporting Services (SSRS), Power BI, or any other reporting tools, referencing positions listed on your application/resume. If you do not have this experience, type "None" in the space provided.

15

Do you have experience administering tools such as PowerBI, Cognos, SSRS, Planning Analytics, or SQL?

• Yes

• No

16

Describe your experience administering tools such as PowerBI, Cognos, SSRS, Planning Analytics, or SQL, referencing jobs listed on your application/resume. If you do not have this experience, type "None" in the space provided.

17

Please choose the one recruitment source that best describes how you first learned about this job opening. Please review all possible choices before making your selection. Your response to this question helps us evaluate the effectiveness of our recruitment methods.

• College or university (job board, career services, or instructor)

• Community or nonprofit organization (counselor, job board, etc.)

• Employee or recruiter of Hennepin County

• Friend or family member that is not a Hennepin County employee

• Hennepin County job notification emails

• Indeed.com

• Job fair or networking event

• LinkedIn

• Print advertisement (flyer, postcard, billboard, transit ad, etc.)

• Professional association (job board or email)

• Social media (Facebook, Twitter, Instagram, etc.)

• www.hennepin.jobs or www.governmentjobs.com

• Other

18

For the recruitment source selected above, please provide the specific name of the person, website, or media source.

Required Question

Agency Hennepin County

Address Hennepin County Government Center

300 South Sixth Street

Minneapolis, Minnesota, 55487

Phone 612-348-7855

Website https://www.hennepin.us/jobs