Salary
$72,075.41 - $108,113.11 Annually
Job Type
Full-time
Job Number
25IT10101rla001
01/14/2025
Closing Date
1/28/2025 11:59 PM Central
Description
Hennepin County's Information Technology (IT) department is seeking an IT Business Intelligence 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 Employee Orientation (NEO) for all new benefit-earning employees is in-person in downtown Minneapolis. Details about NEO will be provided upon hire.
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.
Note: You must attach a resume with your application materials to be considered for this position. At this time, employees may be eligible to receive an additional cash merit of up to $2,162.27 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 manage access and file-level permissions.
· Research new data technologies, tune resources to efficiently meet the needs of analytics activities, monitor and maintain 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:
o Four years or more of information technology experience.
o Associate/vocation/technical degree in computer science/engineering or a related information technology field and two years or more of information technology experience.
o Bachelor’s degree in computer science, management information systems, data engineering, business intelligence, data analytics or a related information technology field.
AND
· Current certification or the ability to be certified in a leading professional level certification area (e.g., Microsoft, Azure, Power BI, Fabric, etc.).
Nice to have:
· One or more years of experience:
o Administering tool(s) such as PowerBI, Cognos, SSRS, Planning Analytics, or SQL.
o Developing reports in SQL Server Reporting Services (SSRS), PowerBI or any other reporting tools.
· Two or more years of Enterprise experience:
o Developing ETL in SQL Server Integration Services (SSIS), Azure Data Factory, Azure Synapse, or any other market leading ETL tools.
o Managing data storage solutions such as databases and/or data lakes for efficient reporting.
o Scripting/coding automation processes with one or more of the following: PowerShell, PL/SQL, T-SQL, Python, R, DAX, M, Kusto and/or other language.
If you have any questions, please contact:
Roberta Arpinar
APPLY HERE!IT Business Intelligence Engineer | Job Details tab | Career Pages