Salary : $70,518.00 - $110,185.00 Annually
Location : Hastings, MN
Job Type : Full-Time
Job Number : 63117.25.001
Department : Information Technology
Opening Date : 01 / 10 / 2025
Closing Date : 1 / 27 / 2025 4 : 30 PM Central
General Description
POSTING TYPE : Open competitive
DEPARTMENT : Information Technology
HOURS : Full Time
SALARY RANGE : $70,518- $110,185
LOCATION : Hastings, ADC
UNION : None
CLOSE DATE : 4 : 30 p.m. on 1 / 27 / 2025
Who We Are
Dakota County is Minnesota's third largest county and home to more than 400,000 residents. Our motto is "Be More" and we strive every day to achieve excellence in public service, with a focus on four values : Service, Integrity, People and Innovation.
Dakota County aims to create an environment that is welcoming and inclusive of diverse people, backgrounds and experiences. Our goal is to have a workforce that is reflective of the communities and individuals we serve. We promote an equitable and culturally aware work environment where everyone can be their authentic selves.
Individuals within the Business Intelligence (BI) Analyst role participate on a team to produce reports and dashboards supporting business intelligence, reporting, and data analysis needs for the various County business areas. They work with several reporting / BI tools as applicable for the various data sources. They may also be involved with the extract, transfer, and loading of data from operational data sources into the County data warehouse. It is essential that BI Analysts build an understanding of the business at a level of detail that enables them to identify and address critical data related issues. They leverage their team and business partners to ensure data delivered is accurate, congruent and reliable. BI Analysts also educate and train clients to use the data as an analytical tool, displaying the information in many different forms for the purpose of analysis and option exploration.
The BI Analyst participates in facilitating information gathering, structured documentation, and presentation of findings to their team and business partners. They understand how data is turned into information and knowledge and how that knowledge supports and enables key business processes. They must have an in-depth understanding of the business environment and an interest in going beyond the obvious. They must be self-motivated and have strong interpersonal skills.
Minimum Qualifications
Bachelor's degree in Computer Science, Information Systems, Business Management or Business Intelligence.
AND 1 year experience in any of the following :
- Analyzing and reporting on relational databases with industry accepted business intelligence tools.
- C#, Windows and Web .NET software development experience with desire to move in the direction of business intelligence.
- Business analysis working directly with business contacts from various business functional areas to deliver scheduled reports and / or data dashboards.
OR an equivalent combination of education and experience.
PREFERRED SKILLS BEYOND MINIMUM QUALIFICATIONS :
Microsoft SQL Server Reporting Services (SSRS) 2008 or higherCrystal ReportsOracle Report WriterCognos Analytics / Cognos Business IntelligenceEmbarcadero ER Studio / Erwin / Toad Data ModelerMicrosoft VisioMicrosoft SQL Services Management Studio (SSMS)Microsoft SQL Services Integration Services (SSIS)Microsoft Power BITableauDuties & Responsibilities
These examples do not include all possible tasks in this work and do not limit the assignment of related tasks in any position of this classification. Regular attendance according to the position's management approved work schedule is required for all positions.
Project / Work Planning
Participates in work stream planning process including inception, technical design, development, testing and delivery of BI solutions including but not limited to reports, dashboards, data mining packages, and reporting views / packages.Participates in project management estimation process.Participates in the development of business cases in the support of process changes and / or IT projects.Research / Evaluation
Uses best practices at the direction of BI Administrator and IT Senior Business Intelligence Analysts.Participates in discussions surrounding selection of tools, frameworks and mechanisms for data mining and reporting.Contributes to discussions regarding BI products / tools, strategies, and directionBusiness Requirements & Analysis
Works with team to evaluate internal and external customers' needs and abilities in order to provide appropriate solutions.Provides input to business requirements for the design of solutions.Contributes to discussions surrounding new technology opportunities that will have an impact on the enterprise wide BI systems.Explores the data and discovers patterns, meaningful relationships, anomalies and trends.May perform analysis for a wide range of requests using data in different formats and from various platforms.Follows best practices for report development and deployment at the direction of BI Administrator and IT Senior Business Intelligence Analysts.Testing, Training, Coaching
Continuously looks to learn business data to improve ability to deliver quality data with fewer iterations.Analyzes testing / data validation results to ensure the solution meets the needs of the business.Leverages training opportunities to enhance knowledge of BI tools as needed.Coaches business users on the use of developed reports / dashboards.Knowledge, Skills & Abilities and Work Environment
Experience in the analysis, design, and implementation of data mining solutions.Practical knowledge of relational databases, such as MS SQL or Oracle.Knowledge of Relational, Dimensional Data Modeling.Practical knowledge in importing data for use in report software, spreadsheets, graphs, and flow charts.Working knowledge of PC and server operating systems, including Windows OS.Experience in the analysis of databases, software, and standards, as well as data retrieval methodologies.Basic project management skills.Hands-on experience with test cases, test plans, and validation of reports.Knowledge of applicable data privacy practices and laws.Understanding of ETL transformations and processing of Data.Knowledge of Data Warehouse and Operational Data Store concepts and principles.Experience working with clients to prioritize work requests.Experience in creation of Technical Design Documents, Data Flow Diagrams, Process layout etc.Experience with core software applications, such as Financial, Tax, and EDMS a plus.Working knowledge of programming languages, such as C#, Web, Windows .NET a plus.Personal Attributes
Excellent analytical, mathematical, and creative problem-solving skills.Strong written and oral communication skills.Excellent listening and interpersonal skills.Logical and efficient.Keen attention to detail.Ability to communicate ideas in both technical and user-friendly language.Highly self-motivated and directed.Ability to effectively prioritize and execute tasks in a high-pressure environment.Strong customer service orientation.Experience working in a team-oriented, collaborative environment.Work Conditions
Dexterity of hands and fingers to operate a computer keyboard or mouse, and to handle other computer components.Some travel between County and State locations.Overtime hours may be required to meet project deadlines.On-call availability as assigned.Benefits
Comprehensive and affordable medical, dental, vision, and other benefitsExcellent work-life balanceGenerous paid time off (accrual rate starts at four weeks per year)Eleven paid holidays and one floating holiday each yearPension with a generous employer contributionAbility to work from home some of the timeSelection Process
You submit an online application that includes supplemental questionsWe assign you a score based on your qualificationsTop scoring candidates are referred to the hiring manager for interview considerationWe conduct interviews and reference checks before extending an offerWe extend an offer and conduct background checksVisit our Benefits site for more information.
Applicants for this recruitment will be rated based on their answers to the supplemental questions listed below and application materials. It is IMPERATIVE that information provided on the application and resume are detailed and clearly outline your work experience & skills. They must also support and / or match answers to the supplemental questions.Please initial the box below to CONFIRM that the information provided is accurate and true to the best of your knowledge. Falsification may result in disqualification from consideration for this and subsequent recruitments with Dakota County for up to three years.Indicate how you meet the minimum qualifications.
Bachelor's degree in Computer Science, Information Systems, Business Management or Business Intelligence.. AND 1 year experience in either analyzing and reporting on relational databases with industry accepted business intelligence tools, OR C#, Windows and Web .NET software development, OR Business analysis working directly with business contract from various business functional areas to deliver scheduled reports and / or data dashboards.Equivalent combination of education and experience to equal 5 years.I don't qualifyBriefly describe your combination of education and experience above. The combination of education and experience should be directly related to this position.
Please select the highest level of education completed or Degree held. (Degree must be held by the closing date of this recruitment)
High School Diploma or G.E.D equivalentProfessional / Technical Certificate equivalent to 1 year of full-time post secondary educationAssociate's DegreeBachelor's DegreeMaster's DegreePh.D.Is your degree in the field of Computer Science, Information Systems, Business Management, or Business Intelligence?
Indicate your years of full-time experience analyzing and reporting on relational databases with industry accepted business intelligence tools.
Less than 1 year1 year2 years3 or more yearsNo experienceIndicate your years of full-time experience in C#, Windows and Web .NET software development experience with desire to move in the direction of business intelligence.
Less than 1 year1 year2 years3 or more yearsNo experienceIndicate your years of full-time experience in business analysis working directly with business contacts from various business functional areas to deliver scheduled reports and / or data dashboards.
Less than 1 year1 year2 years3 or more yearsNo experienceDo you have work experience or educational knowledge in the following areas? (check all that apply)
Microsoft SQL Server Reporting Services (SSRS) 2008 or higherCrystal ReportsOracle Report WriterCognos Analytics / Cognos Business IntelligenceEmbarcadero ER Studio / Erwin / Toad Data ModelerMicrosoft VisioMicrosoft SQL Services Management Studio (SSMS)Microsoft SQL Services Integration Services (SSIS)Microsoft Power BITableauIf selected for this position, what would be your minimum acceptable salary?
Your response to this question will help Dakota County evaluate the effectiveness of recruitment sources for this specific position. Please select the one source that most closely describes how you first learned about this opportunity.
FacebookFriend, Family or ColleagueInDeedJob Fair or Dakota County EventJob Interest e-mails from Dakota CountyJobsInMinneapolis / StPaulLeague of Minnesota CitiesLinkedInMinneapolis Diversity.comMinnesota Diversity.comMinnesota Works WebsiteMinnesota Jobs Network.comMinnesota Association of CountiesMonsterProfessional Association WebsiteReferred by a Dakota County EmployeeSt Paul Diversity.comCollege Website, Instructor, Career ServicesDakota County WebsiteOtherIf you selected Other, please indicate where you heard about this opportunity with Dakota County.
Required Question
Salary : $70,518 - $110,185
