Salary $74,269.41 - $109,947.49 AnnuallyLocation Hennepin CountyJob TypeFull-timeDepartmentHuman Services and Public HealthJob Number23HSPH20597MN010Closing2/1/2023 11:59 PM Central
DescriptionThe Information Technology and Records Management (ITRM) area of Human Services and Public Health is seeking a Business Intelligence Developer to assist with the design, development and support of business intelligence implementations. The ideal candidate will be skilled in ETL development, data modeling (relational/dimensional), and advanced report development.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 to a Hennepin County facility in downtown Minneapolis, Minnesota an average of 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, 8 a.m. - 4:30 p.m. with flexibility. While this position is designated as remote, based on current requirements, hires must reside in Minnesota or Wisconsin. 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) Developer II.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,198.87 that can be earned annually based on performance. In this position, you will:
Provide support of applications in relevant environments – troubleshoot problems, upgrades, and incremental enhancements.
Interpret business needs to implement new solutions based on Hennepin County standards and industry best practices.
Participate in the remediation and/or enhancement of existing software process.
Partake in agile scrum events and work within a team.
Research and prepare technology recommendations to be presented, both verbally and in writing, to business stakeholders.
Use creative problem-solving skills when confronted with issues.
Collaborate with other developers, managers, and customers.
Need to have:
One of the following:
Four or more years of IT experience.
Two-year college/vocational technical degree in a technology field or an approved information technology certificate and two or more years of information technology experience.
Completion of five college/vocational technical technology courses or completion of an approved IT Hennepin County internship and two or more years of information technology experience.
Bachelor's degree or higher in a technology field and one or more years of IT experience.
Nice to have:
Two or more years of experience:
Designing facts and dimensions for data warehousing.
Developing reports in SQL Server Reporting Services (SSRS) or PowerBI.
Developing ETL in SQL Server Integration Services (SSIS) or Azure Data Factory.
Performing installation, operation, maintenance, and debugging computer applications.
Experience with Microsoft Azure:
Basic Azure administration with cost management, security, etc.
Azure Data Factory, Synapse Pipelines, and Databricks.
Two or more years of experience with:
BIML, SSAS (tabular or dimensional models).
SQL Master Data Services or other metadata management tools.
Version control system preferably GIT and Azure DevOps.
Basic understanding of Agile processes and working on a Scrum team.
Knowledge of scripting language (PowerShell is preferred).
Knowledge of SQL administration, SQL security, and Windows security.
Certification in a leading professional level certification area, such as MCSA, MCSE, IBM, CDMP, etc.
About the department:Human Services delivers a variety of services to individuals or families that assist with basic needs or encourage client change around specific objectives. We work with individuals as well as systems and communities in order to develop policy and advocate for the people we serve. The people we serve and our communities are connected. By helping one, we help the other. 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 (log in as Guest).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 position may have access to systems or other documentation that contains HIPAA data.