It Engineer

Hennepin County
Full Time $67,612 - $101,419 Per year MN City of Minneapolis Department of Information Technology, 310 4th Ave S, Minneapolis, MN 55415, United States


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.
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.  
About the position type:
This is a full-time, benefit-earning position. You must be a of Hennepin County's IT department to apply for this position. Limited duration employees are not eligible.   

This position is internally classified as an Information Technology (IT) Engineer - IT Database Engineer. Click 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.
  • 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 .
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 
 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: 
Pajoua Chang