Address
Form of workSalary : $75,760.00 - $118,375.00 Annually
Location : Hastings, MN
Job Type: Full-Time
Job Number: 63113.23.002
Department: INFORMATION TECHNOLOGY ADMIN - 2300001
Opening Date: 12/20/2023
Closing Date: 1/5/2024 4:30 PM Central
General Description
The following is to be used for Posting purposes only
POSTING TYPE: Open-Competitive
DEPARTMENT: Information Technology
HOURS: Full-time
SALARY RANGE: $75,760- $118,375/year
LOCATION: Hastings ADC
UNION: None
CLOSE DATE: 4:30 p.m. on January 5th, 2024
The Senior IT Business Analyst's role is to gather the requirements to plan, design, develop, and launch efficient business, financial, and operations systems in support of core organizational functions and business processes. This includes, but is not limited to, gathering and analyzing data in support of business cases, proposed projects, and systems requirements. The Senior IT Business Analyst is also responsible for documenting findings, complete with probable causes and possible solutions to systems issues. This position is also involved with strategic business/technology analysis. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments.
Additionally, this person is the subject matter expert (SME) for the end user financial software, and, as such, regularly interacts with end users, vendors and other IT staff -- mostly by phone, videoconference, email or instant messaging.
Lastly, this position will be part of the County's internal ERP support team and should have experience with the Finance side (GL, AP, AR) of an ERP system and have had previous experience setting up user and role security within the software.
Who We AreDakota 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 excellent 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.
Minimum Qualifications
Bachelor's Degree in the field of business administration, computer science, accounting, finance or management information systems AND 6 years of IT Business Systems Analysis work experience.
**Candidates with an equivalent combination of education and experience to total 10 years may also qualify.
ABOVE WORK EXPERIENCE MUST INCLUDE THE FOLLOWING:
• 3 years' experience with Oracle database
• 3 years' experience with Oracle SQL Developer
• 5 years' experience gathering requirements, process and data modeling, writing system specifications, test planning, assisting with project plans, and executing and monitoring tasks.
PREFERRED QUALIFICATIONS BEYOND MINIMUM REQUIRED:
• Business Analysts Certificate Program (CBAP - Level 3 or CCBA - Level 2) or Project Management Institute Professional in Business Analysis (PMI-PBA) certification.
• Microsoft SQL Server Reporting Services (SSRS) 2008 or higher; Crystal Reports, Oracle Report Writer
• Microsoft Project 2010 or higher
• SQL Services Management Studio (SSMS)
• SQL Services Integration Services (SSIS)
• SplashBI
Duties & Responsibilities
Strategy & Planning:
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.
1. Provide input into strategic capability vision and a multi-year business capability roadmap for enterprise applications.
2. Participate in the creation of business/technology visions that promote operational change.
3. Participate in the creation of, and present technology recommendations to, business and technology leadership.
4. Meet with decision makers, systems owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
5. Identify and establish scope and parameters of systems analysis in order to provide input to the project plan that will define outcome criteria and measure-taking actions.
6. Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
7. Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
Acquisition & Deployment:
8. Participate fully in the planning, design, development, and deployment of new applications and enhancements to existing applications.
9. Conduct research on software and hardware products to justify recommendations and to support purchasing efforts.
Operational Management:
10. Help develop the project plan to define scope, work breakdown, and task assignments.
11. Create system design proposals and specifications from the design and prototyping sessions with IT staff and the business stakeholders.
12. Create data models, workflow models, report specifications, and use cases to provide direction to application developers.
13. Extract, transform, and load data from multiple relational databases for use in report software, data conversions, and system integrations.
14. Ensure compatibility and interoperability of in-house computing systems.
15. Lead business process/workflow analysis and fit/gap analysis.
16. Create and coordinate execution of test plans/and or test scripts to ensure the accuracy, integrity, and usability of applications.
17. Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
18. Research and recommend solutions to identify issues and problems; monitor status of open issues; collaborate with business, technical and vendor teams.
19. Provide orientation and training to end-users for modified and new systems.
20. Provide guidance and/or instruction to junior staff members.
21. Other duties as assigned.
ESSENTIAL JOB FUNCTIONS: Items 1-20 are essential to this position.
Knowledge, Skills & Abilities and Work Environment
• Proven experience in the analysis, design, and implementation of software and hardware solutions, systems, or products.
• Extensive knowledge in data modeling, workflow modeling, and use case development.
• Extensive practical knowledge of relational databases, such as Oracle and MS SQL.
• Extensive practical knowledge in importing data for use in report software, spreadsheets, graphs, and flow charts.
• Extensive experience with core software applications, such as Financial (ERP), Tax, Web, and EDMS.
• Working knowledge of Oracle Fusion Cloud Financials (ERP) and Human Capital Management (HCM)
• Working knowledge of programming languages, such as C#, Web, Windows .NET.
• Working knowledge of PC and server operating systems, including Windows OS.
• Proven experience in the analysis of databases, software, and standards, as well as data retrieval methodologies.
• Demonstrated project management skills.
• Hands-on experience developing test cases and test plans.
• Knowledge of applicable data privacy practices and laws.
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 conduct research into systems issues and products as required.
• Ability to communicate ideas in both technical and user-friendly language.
• Highly self-motivated and directed.
• Ability to effectively prioritize and execute tasks.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.
Work Environment
• On-call availability as assigned.
• Overtime hours may be required to meet project deadlines.
• Sitting for extended periods of time.
• Dexterity of hands and fingers to operate a computer keyboard or mouse, and to handle other computer components.
• Some travel between County locations.
• Lifting and transporting of moderately heavy objects, such as computers and peripherals.
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
Please select the highest level of education completed or Degree held. (Degree must be held by the closing date of this recruitment)
03
Is your degree in the field of computer science, accounting, finance, information systems, or a closely related discipline?
04
Minimum qualification screening: Select from below how you meet the minimum qualifications of this position. This information must be included in your application.
05
Indicate your years of experience with analysis, design, and implementation of software and hardware solutions, systems, or products.
06
Indicate your years of experience with data modeling, workflow modeling, and use case development.
07
Indicate your years of experience working with Oracle Fusion Cloud Financials (ERP) and Human Capital Management (HCM).
08
Indicate any current certifications you possess. Check all that apply.
09
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.
10
If you selected Other, please indicate where you heard about this opportunity with Dakota County.
Required Question
Location : Hastings, MN
Job Type: Full-Time
Job Number: 63113.23.002
Department: INFORMATION TECHNOLOGY ADMIN - 2300001
Opening Date: 12/20/2023
Closing Date: 1/5/2024 4:30 PM Central
General Description
The following is to be used for Posting purposes only
POSTING TYPE: Open-Competitive
DEPARTMENT: Information Technology
HOURS: Full-time
SALARY RANGE: $75,760- $118,375/year
LOCATION: Hastings ADC
UNION: None
CLOSE DATE: 4:30 p.m. on January 5th, 2024
The Senior IT Business Analyst's role is to gather the requirements to plan, design, develop, and launch efficient business, financial, and operations systems in support of core organizational functions and business processes. This includes, but is not limited to, gathering and analyzing data in support of business cases, proposed projects, and systems requirements. The Senior IT Business Analyst is also responsible for documenting findings, complete with probable causes and possible solutions to systems issues. This position is also involved with strategic business/technology analysis. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments.
Additionally, this person is the subject matter expert (SME) for the end user financial software, and, as such, regularly interacts with end users, vendors and other IT staff -- mostly by phone, videoconference, email or instant messaging.
Lastly, this position will be part of the County's internal ERP support team and should have experience with the Finance side (GL, AP, AR) of an ERP system and have had previous experience setting up user and role security within the software.
Who We AreDakota 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 excellent 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.
Minimum Qualifications
Bachelor's Degree in the field of business administration, computer science, accounting, finance or management information systems AND 6 years of IT Business Systems Analysis work experience.
**Candidates with an equivalent combination of education and experience to total 10 years may also qualify.
ABOVE WORK EXPERIENCE MUST INCLUDE THE FOLLOWING:
• 3 years' experience with Oracle database
• 3 years' experience with Oracle SQL Developer
• 5 years' experience gathering requirements, process and data modeling, writing system specifications, test planning, assisting with project plans, and executing and monitoring tasks.
PREFERRED QUALIFICATIONS BEYOND MINIMUM REQUIRED:
• Business Analysts Certificate Program (CBAP - Level 3 or CCBA - Level 2) or Project Management Institute Professional in Business Analysis (PMI-PBA) certification.
• Microsoft SQL Server Reporting Services (SSRS) 2008 or higher; Crystal Reports, Oracle Report Writer
• Microsoft Project 2010 or higher
• SQL Services Management Studio (SSMS)
• SQL Services Integration Services (SSIS)
• SplashBI
Duties & Responsibilities
Strategy & Planning:
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.
1. Provide input into strategic capability vision and a multi-year business capability roadmap for enterprise applications.
2. Participate in the creation of business/technology visions that promote operational change.
3. Participate in the creation of, and present technology recommendations to, business and technology leadership.
4. Meet with decision makers, systems owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
5. Identify and establish scope and parameters of systems analysis in order to provide input to the project plan that will define outcome criteria and measure-taking actions.
6. Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
7. Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
Acquisition & Deployment:
8. Participate fully in the planning, design, development, and deployment of new applications and enhancements to existing applications.
9. Conduct research on software and hardware products to justify recommendations and to support purchasing efforts.
Operational Management:
10. Help develop the project plan to define scope, work breakdown, and task assignments.
11. Create system design proposals and specifications from the design and prototyping sessions with IT staff and the business stakeholders.
12. Create data models, workflow models, report specifications, and use cases to provide direction to application developers.
13. Extract, transform, and load data from multiple relational databases for use in report software, data conversions, and system integrations.
14. Ensure compatibility and interoperability of in-house computing systems.
15. Lead business process/workflow analysis and fit/gap analysis.
16. Create and coordinate execution of test plans/and or test scripts to ensure the accuracy, integrity, and usability of applications.
17. Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
18. Research and recommend solutions to identify issues and problems; monitor status of open issues; collaborate with business, technical and vendor teams.
19. Provide orientation and training to end-users for modified and new systems.
20. Provide guidance and/or instruction to junior staff members.
21. Other duties as assigned.
ESSENTIAL JOB FUNCTIONS: Items 1-20 are essential to this position.
Knowledge, Skills & Abilities and Work Environment
• Proven experience in the analysis, design, and implementation of software and hardware solutions, systems, or products.
• Extensive knowledge in data modeling, workflow modeling, and use case development.
• Extensive practical knowledge of relational databases, such as Oracle and MS SQL.
• Extensive practical knowledge in importing data for use in report software, spreadsheets, graphs, and flow charts.
• Extensive experience with core software applications, such as Financial (ERP), Tax, Web, and EDMS.
• Working knowledge of Oracle Fusion Cloud Financials (ERP) and Human Capital Management (HCM)
• Working knowledge of programming languages, such as C#, Web, Windows .NET.
• Working knowledge of PC and server operating systems, including Windows OS.
• Proven experience in the analysis of databases, software, and standards, as well as data retrieval methodologies.
• Demonstrated project management skills.
• Hands-on experience developing test cases and test plans.
• Knowledge of applicable data privacy practices and laws.
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 conduct research into systems issues and products as required.
• Ability to communicate ideas in both technical and user-friendly language.
• Highly self-motivated and directed.
• Ability to effectively prioritize and execute tasks.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.
Work Environment
• On-call availability as assigned.
• Overtime hours may be required to meet project deadlines.
• Sitting for extended periods of time.
• Dexterity of hands and fingers to operate a computer keyboard or mouse, and to handle other computer components.
• Some travel between County locations.
• Lifting and transporting of moderately heavy objects, such as computers and peripherals.
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
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.
03
Is your degree in the field of computer science, accounting, finance, information systems, or a closely related discipline?
- Yes
- No
04
Minimum qualification screening: Select from below how you meet the minimum qualifications of this position. This information must be included in your application.
- Bachelor's degree in the field of computer science, accounting, finance, information systems or a related discipline AND 6 years of IT Business Systems Analysis work experience.
- An equivalent combination of education and experience totaling 10 years, including at least 6 years of IT Business Systems Analysis work experience.
- I do not qualify.
05
Indicate your years of experience with analysis, design, and implementation of software and hardware solutions, systems, or products.
- Less than one year
- 1 year
- 2 years
- 3 years
- 4 years
- 5 or more years
06
Indicate your years of experience with data modeling, workflow modeling, and use case development.
- Less than one year.
- 1 year
- 2 years
- 3 years
- 4 years
- 5 or more years
07
Indicate your years of experience working with Oracle Fusion Cloud Financials (ERP) and Human Capital Management (HCM).
- Less than one year.
- 1 year
- 2 years
- 3 years
- 4 years
- 5 or more years
08
Indicate any current certifications you possess. Check all that apply.
- Information Technology Infrastructure Library (ITIL) Foundations
- Business Analysts Certificate Program (CBAP - Level 3 or CCBA - Level 2)
- Project Management Institute Professional in Business Analysis (PMI-PBA) certification
- Microsoft SCCM Administration (any level)
09
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
10
If you selected Other, please indicate where you heard about this opportunity with Dakota County.
Required Question
