IT Business Intelligence Analyst
7 days ago
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 higher
• Crystal Reports
• Oracle Report Writer
• Cognos Analytics / Cognos Business Intelligence
• Embarcadero ER Studio / Erwin / Toad Data Modeler
• Microsoft Visio
• Microsoft SQL Services Management Studio (SSMS)
• Microsoft SQL Services Integration Services (SSIS)
• Microsoft Power BI
• Tableau
Duties & 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 direction
Business 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 benefits
- Excellent work-life balance
- Generous paid time off (accrual rate starts at four weeks per year)
- Eleven paid holidays and one floating holiday each year
- Pension with a generous employer contribution
- Ability to work from home some of the time
- You submit an online application that includes supplemental questions
- We assign you a score based on your qualifications
- Top scoring candidates are referred to the hiring manager for interview consideration
- We conduct interviews and reference checks before extending an offer
- We extend an offer and conduct background checks
Visit our Benefits site for more information.
01
*******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.
02
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 qualify
03
Briefly describe your combination of education and experience above. The combination of education and experience should be directly related to this position.
04
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 equivalent
- Professional/Technical Certificate equivalent to 1 year of full-time post secondary education
- Associate's Degree
- Bachelor's Degree
- Master's Degree
- Ph.D.
05
Is your degree in the field of Computer Science, Information Systems, Business Management, or Business Intelligence?
- Yes
- No
06
Indicate your years of full-time experience analyzing and reporting on relational databases with industry accepted business intelligence tools.
- Less than 1 year
- 1 year
- 2 years
- 3 or more years
- No experience
07
Indicate 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 year
- 1 year
- 2 years
- 3 or more years
- No experience
08
Indicate 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 year
- 1 year
- 2 years
- 3 or more years
- No experience
09
Do you have work experience or educational knowledge in the following areas? (check all that apply)
- Microsoft SQL Server Reporting Services (SSRS) 2008 or higher
- Crystal Reports
- Oracle Report Writer
- Cognos Analytics / Cognos Business Intelligence
- Embarcadero ER Studio / Erwin / Toad Data Modeler
- Microsoft Visio
- Microsoft SQL Services Management Studio (SSMS)
- Microsoft SQL Services Integration Services (SSIS)
- Microsoft Power BI
- Tableau
10
If selected for this position, what would be your minimum acceptable salary?
11
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.
- Friend, Family or Colleague
- InDeed
- Job Fair or Dakota County Event
- Job Interest e-mails from Dakota County
- JobsInMinneapolis/StPaul
- League of Minnesota Cities
- Minneapolis Diversity.com
- Minnesota Diversity.com
- Minnesota Works Website
- Minnesota Jobs Network.com
- Minnesota Association of Counties
- Monster
- Professional Association Website
- Referred by a Dakota County Employee
- St Paul Diversity.com
- College Website, Instructor, Career Services
- Dakota County Website
- Other
12
If you selected Other, please indicate where you heard about this opportunity with Dakota County.
Required Question
-
Business Intelligence Solutions Developer
2 days ago
Hastings, Minnesota, United States Dakota County Full timeJob DescriptionThe ideal candidate will possess strong analytical and problem-solving skills, with the ability to communicate complex ideas in a clear and concise manner. They will be responsible for working with various data sources, developing reports and dashboards, and providing insights to stakeholders.Key Responsibilities:Participate in the development...
-
Intelligent Data Systems Specialist
1 day ago
Hastings, Minnesota, United States Dakota County Full timeAbout Dakota CountyDakota County is a leading provider of public services, committed to delivering high-quality programs and services to its citizens. We are seeking an experienced Business Intelligence Analyst to join our team and contribute to our mission of excellence in public service.Key Responsibilities:Develop and maintain business intelligence...
-
Hastings, Minnesota, United States Dakota County Full timeJob Summary">We are seeking a highly skilled Financial Analyst/Financial Manager to join our team. In this role, you will be responsible for analyzing financial data, developing budget reports, and providing fiscal guidance to various departments. The ideal candidate will have a strong background in accounting and finance, excellent analytical skills, and...
-
Financial Expert
2 days ago
Hastings, Minnesota, United States Dakota County, MN Full timeAbout Dakota CountyDakota County is a dynamic and inclusive community serving over 400,000 residents. Our mission is to deliver exceptional public service, guided by our core values of Service, Integrity, People, and Innovation.Job DescriptionWe are seeking a skilled Financial Analyst/Senior Financial Analyst to join our team. The ideal candidate will...
-
Fiscal Specialist
2 days ago
Hastings, Minnesota, United States Dakota County, MN Full timeAbout Dakota CountyDakota County is a vibrant and diverse community, serving over 400,000 residents. Our organization is committed to delivering exceptional public service, guided by our core values of Service, Integrity, People, and Innovation.Job SummaryWe are seeking a highly skilled Financial Analyst/Senior Financial Analyst to join our team. As a key...
-
Senior Accounting Professional
2 days ago
Hastings, Minnesota, United States Dakota County, MN Full timeAbout Dakota CountyDakota County is a leader in providing public services to its residents, with a focus on innovation, integrity, and people-centric approach. Our organization is committed to creating an inclusive and welcoming environment that reflects the diversity of our communities.Job OverviewWe are currently seeking a Financial Analyst/Senior...
-
Ardor Health Solutions | Travel Nurse RN
6 days ago
Hastings-on-Hudson, United States Ardor Health Solutions Full timeArdor Health Solutions is seeking a travel nurse RN OR - Operating Room for a travel nursing job in Hudson, New York. Job Description & RequirementsSpecialty:OR - Operating Room Discipline:RN Start Date:02/10/2025 Duration:13 weeks 36 hours per week Shift:12 hours, days Employment Type:TravelLocation:Hudson,NYSetting:HospitalEmployment Type:TravelerArdor...
-
Travel Nurse
3 days ago
Hastings-on-Hudson, United States Ardor Health Solutions Full timeArdor Health Solutions is seeking a travel nurse RN OR - Operating Room for a travel nursing job in Hudson, New York. Job Description & RequirementsSpecialty:OR - Operating Room Discipline:RN Start Date:02/03/2025 Duration:13 weeks 36 hours per week Shift:12 hours, days Employment Type:TravelLocation:Hudson,NYSetting:HospitalEmployment Type:TravelerArdor...
-
Hastings-on-Hudson, United States Ardor Health Solutions Full timeArdor Health Solutions is seeking a travel MRI Technologist for a travel job in Hudson, New York. Job Description & RequirementsSpecialty:MRI Technologist Discipline:Allied Health Professional Start Date:02/10/2025 Duration:13 weeks 36 hours per week Shift:10 hours, days Employment Type:TravelLocation:Hudson,NYSetting:HospitalEmployment Type:TravelerArdor...
-
Mri Technologist
2 days ago
Hastings-on-Hudson, United States Ardor Health Solutions Full timeArdor Health Solutions is seeking a travel MRI Technologist for a travel job in Hudson, New York. Job Description & RequirementsSpecialty:MRI Technologist Discipline:Allied Health Professional Start Date:02/10/2025 Duration:13 weeks 36 hours per week Shift:10 hours, days Employment Type:TravelLocation:Hudson,NYSetting:HospitalEmployment Type:TravelerArdor...