Metropolitan Council
Business Systems Analyst I or II - Service Development (Hybrid)
Metropolitan Council, Saint Paul, Minnesota, United States, 55130
Salary:
See Position Description
Location :
Minneapolis, MN
Job Type:
Full-Time
Remote Employment:
Flexible/Hybrid
Job Number:
2024-00339
Division:
Metro Transit
Department:
System Support
Opening Date:
10/22/2024
Closing Date:
11/5/2024 11:59 PM Central
WHO WE ARE
We are the
Metropolitan Council , the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services.
We are committed to supporting a diverse workforce that reflects the communities we serve.
The Metropolitan Council's Metro Transit Division
is one of the country's largest transit systems, employs more than 3,000 people, and provides ridership through an integrated network of buses, light rail and commuter trains, as well as a resource for those who carpool, vanpool, walk or bike in the Twin Cities.
How your work would contribute to our organization and the Twin Cities region:
The
Business Systems Analyst I (BSA 1) or
Business Systems Analyst II (BSA 2)
in Service Development's System Support unit supports the technologies used by department staff to plan, analyze, schedule, and communicate fixed-route bus and rail service.
This position works as a member of a team of BSAs, each of whom specializes in areas such as application development and support; database development and management; data flow (ETL); data analysis and reporting; hardware management; project management; and general technology administration. This position may be assigned primary or backup responsibility over specific applications, databases, projects, or other functions. Assignments may be fluid, depending on staff availability, individual skills, and the evolving needs of the department.
NOTE:
This position is eligible for a hybrid (both remote and onsite) telework arrangement. The candidate's permanent residence must be in Minnesota or Wisconsin.This recruitment will establish a six-month eligible list for current and future positions.What you would do in this job
These responsibilities apply to both BSA 1 and 2:
Work collaboratively with Information Services to support hardware, software, databases, and content used for planning and scheduling transit service.Gather and document business requirements to support the development of applications, data sets, and technical procedures.Develop and maintain small-scale applications using programming languages and development environments.Support third-party applications through procurement, implementation, and disposal.Maintain databases, data sets, and data flow procedures.Analyze operational data sets, develop reports, and create visualizations to support service planning and scheduling.Administer collaborative technologies and digital content management systems.Participate in technical working groups and cross-departmental projects.Serve as a liaison between Information Services and department users on the acquisition, installation, and troubleshooting of hardware and software.Develop technical documentation, user instructions, workflow diagrams, and data flow diagrams.Provide direct training to users in group and individual settings.Perform other related duties.Additional responsibilities of a BSA 1:
Support purchasing and invoicing for technology-related items.Provide clerical support for content management projects, such as organizing and indexing digital documents.Provide A/V support for occasional department meetings.Provide general support for office management and organization.Additional responsibilities of a BSA 2:
Lead technical working groups and cross-departmental projects.Lead the design and implementation of applications, data sources, data flow processes, and other technical functions.Lead technology procurements, including scope development, proposal evaluation, and project management.What education and experience are required for this job (minimum qualifications)
Any of the following combinations of relevant work experience with database management, data analysis, application development, or content management
AND
completed education degree in Information Technology, Management Information Systems, Data Science, or closely related field:
BSA I:
High school diploma/GED with six (6) years of experience.Associate's degree with four (4) years of experience.Bachelor's degree or higher with two (2) years of experience.BSA II:
High school diploma/GED with seven (7) years of experience.Associate's degree with five (5) years of experience.Bachelor's degree or higher with three (3) years of experience.What additional skills and experience would be helpful in this job (desired qualifications):Advanced and well-rounded knowledge of the Microsoft Stack, including Windows and Office (Outlook, Word, Excel, Access, and PowerPoint).Knowledge of transit-specific software products used for planning and scheduling (e.g., HASTUS, Remix).Knowledge of relational databases, ETL languages, data lakes, and cloud-based data hosting.Knowledge of data analysis and visualization software (e.g., R, Shiny, Power BI).Knowledge of content management platforms such as SharePoint and Teams.Knowledge of programming languages (e.g., C#, Java, Python, Visual Basic).Knowledge of other software useful in fulfilling the job requirements (e.g., Power Automate, Power Apps, Visio, Project)Experience with transit data (e.g., APC, AVL, GTFS).Experience working with a diverse workforce and communities.What knowledge, skills and abilities you should have within the first six months on the job:Knowledge of the public transit industry.Advanced skills in Microsoft Windows and Office (Outlook, Word, Excel, Access, and PowerPoint).Skills in one or more computer programming languages.Skills in database development and ETL, including proficiency with SQL.Skills in business intelligence report design and implementation.Skills in content management and collaborative software.Ability to interpret and apply mathematics and statistical methods and procedures.Ability to plan and lead projects.Ability to effectively present information and respond to questions from internal and external stakeholders.Ability to instruct users of all skill levels in the use of computer applications, including verbal and written instruction.Ability to provide basic client services to other departments within the organization and external partners (e.g., government agencies, vendors, etc.). Requires tact, courtesy and cooperation in dealings with others.Ability to read, analyze and interpret professional publications, technical procedures, government regulations, and legal contract language.Ability to write reports, business correspondence and procedure manuals, both to lay and technical audiences.Ability to promote an equitable, positive, and respectful work environment that values cultural diversity among all employees.Additional information
Union/Grade :
BSA I
- Non-Represented / Grade F |
BSA II
- Non-Represented / Grade G
FLSA Status :
BSA I
Non-Exempt |
BSA II
- Exempt
Safety Sensitive:
No
BSA I Full Salary Range:$34.11 - $55.35 Hourly$70,948.80 - $115,128.00 Annually
BSA
II Full Salary Range:
$36.87 - $59.84 Hourly$76,689.60 - $124,467.20 Annually
What your work environment would be:You would perform your work in a standard office setting. Work may sometimes require travel between your primary work site and other sites.
What steps the recruitment process involves:
We review your minimum qualifications.We request your Work Record Evaluation (ATU employees only).We rate your education and experience.We conduct a structured panel interview.We conduct a selection interview.
Once you have successfully completed the steps above, then:
I f you are new to the Metropolitan Council , you must pass a drug test (safety sensitive positions only), and a background check which verifies education, employment, and criminal history. A driving record check and/or physical may be conducted if applicable to the job. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation.
If you are already an employee of the Metropolitan Council , you must pass a drug test (if moving from a non-safety sensitive position to a safety sensitive position) and criminal background check if the job you're applying for is safety sensitive, is a supervisory or management job, is in the Finance, Information Services, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. A driving record check and/or physical may be conducted if applicable to the position.
IMPORTANT: If you make a false statement or withhold information, you may be barred from job consideration.
The Metropolitan Council is an Equal Opportunity, Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply.
If you have a disability that requires an accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us.
We believe our employees are a key to our agency's success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:
Guaranteed monthly retirement income through Minnesota State Retirement System pension fundOpportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) planTwo or more medical plans from which to choose, with employer contribution towards premiums over 80%Dental insurance, life insurance and vision insuranceThe following benefits are provided to all employees as part of working for the Council. You will have access to free:
Well@Work clinicbus/rail pass valued at over $1200 per yearparking at many job locationsfitness centers at many job locationsEmployee Assistance Programextensive health and wellness programs and resources
01
Applicant Instructions: The supplemental questions listed below are to further evaluate your education and experience and to determine your eligibility for this position. Answer each question completely and please do not type "see resume" otherwise your application will be considered incomplete, and you will not receive further consideration for this position. The experience you indicate in your responses should also be consistent with the Work History section of this application. If you attached a resume and/or cover letter to your application, it will be reviewed at the education and experience review step.I have read and understand the above instructions regarding supplemental questions.
YesNo
02
How did you
first
hear about this job opening?
CareerForce CenterCommunity Event/OrganizationEmployee ReferralFacebookGlassdoorIndeedJob FairLinkedInMetro Transit Bus AdvertisementTwitterWebsite: governmentjobs.comWebsite: metrocouncil.orgWebsite: metrotransit.orgWebsite: minnesotajobnetwork.comOther
03
If you selected 'Other', please describe where you first heard about this job. if you selected 'Employee Referral' please enter the employee's first and last name, ID number (if known), and job title.Type N/A if not applicable.
04
Describe your experience developing a data source or software application to aid in decision-making. Consider solutions such as database design and implementation; application design and development; or data query, analysis, and presentation. Describe your process and the tools you used. If you do not have this experience, please type "None".
05
Describe your experience managing a project, technical working group, or technical process. Describe how you defined the objectives, assigned roles and responsibilities, assigned tasks, set timelines, monitored progress, and evaluated the outcome. If you do not have this experience, please type "None".
06
Business Systems Analysts on this team specialize in various technical areas such as (1) application development / support, (2) database management, (3) data analysis / visualization, and (4) content management. Which of those areas do you consider your specialty (or specialties), and which platforms or tools do you use most in this work? If you do not have this experience, please type "None".
07
Describe your experience working with a diverse workforce or communities. If you do not have this experience, please type "None".
Required Question
See Position Description
Location :
Minneapolis, MN
Job Type:
Full-Time
Remote Employment:
Flexible/Hybrid
Job Number:
2024-00339
Division:
Metro Transit
Department:
System Support
Opening Date:
10/22/2024
Closing Date:
11/5/2024 11:59 PM Central
WHO WE ARE
We are the
Metropolitan Council , the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services.
We are committed to supporting a diverse workforce that reflects the communities we serve.
The Metropolitan Council's Metro Transit Division
is one of the country's largest transit systems, employs more than 3,000 people, and provides ridership through an integrated network of buses, light rail and commuter trains, as well as a resource for those who carpool, vanpool, walk or bike in the Twin Cities.
How your work would contribute to our organization and the Twin Cities region:
The
Business Systems Analyst I (BSA 1) or
Business Systems Analyst II (BSA 2)
in Service Development's System Support unit supports the technologies used by department staff to plan, analyze, schedule, and communicate fixed-route bus and rail service.
This position works as a member of a team of BSAs, each of whom specializes in areas such as application development and support; database development and management; data flow (ETL); data analysis and reporting; hardware management; project management; and general technology administration. This position may be assigned primary or backup responsibility over specific applications, databases, projects, or other functions. Assignments may be fluid, depending on staff availability, individual skills, and the evolving needs of the department.
NOTE:
This position is eligible for a hybrid (both remote and onsite) telework arrangement. The candidate's permanent residence must be in Minnesota or Wisconsin.This recruitment will establish a six-month eligible list for current and future positions.What you would do in this job
These responsibilities apply to both BSA 1 and 2:
Work collaboratively with Information Services to support hardware, software, databases, and content used for planning and scheduling transit service.Gather and document business requirements to support the development of applications, data sets, and technical procedures.Develop and maintain small-scale applications using programming languages and development environments.Support third-party applications through procurement, implementation, and disposal.Maintain databases, data sets, and data flow procedures.Analyze operational data sets, develop reports, and create visualizations to support service planning and scheduling.Administer collaborative technologies and digital content management systems.Participate in technical working groups and cross-departmental projects.Serve as a liaison between Information Services and department users on the acquisition, installation, and troubleshooting of hardware and software.Develop technical documentation, user instructions, workflow diagrams, and data flow diagrams.Provide direct training to users in group and individual settings.Perform other related duties.Additional responsibilities of a BSA 1:
Support purchasing and invoicing for technology-related items.Provide clerical support for content management projects, such as organizing and indexing digital documents.Provide A/V support for occasional department meetings.Provide general support for office management and organization.Additional responsibilities of a BSA 2:
Lead technical working groups and cross-departmental projects.Lead the design and implementation of applications, data sources, data flow processes, and other technical functions.Lead technology procurements, including scope development, proposal evaluation, and project management.What education and experience are required for this job (minimum qualifications)
Any of the following combinations of relevant work experience with database management, data analysis, application development, or content management
AND
completed education degree in Information Technology, Management Information Systems, Data Science, or closely related field:
BSA I:
High school diploma/GED with six (6) years of experience.Associate's degree with four (4) years of experience.Bachelor's degree or higher with two (2) years of experience.BSA II:
High school diploma/GED with seven (7) years of experience.Associate's degree with five (5) years of experience.Bachelor's degree or higher with three (3) years of experience.What additional skills and experience would be helpful in this job (desired qualifications):Advanced and well-rounded knowledge of the Microsoft Stack, including Windows and Office (Outlook, Word, Excel, Access, and PowerPoint).Knowledge of transit-specific software products used for planning and scheduling (e.g., HASTUS, Remix).Knowledge of relational databases, ETL languages, data lakes, and cloud-based data hosting.Knowledge of data analysis and visualization software (e.g., R, Shiny, Power BI).Knowledge of content management platforms such as SharePoint and Teams.Knowledge of programming languages (e.g., C#, Java, Python, Visual Basic).Knowledge of other software useful in fulfilling the job requirements (e.g., Power Automate, Power Apps, Visio, Project)Experience with transit data (e.g., APC, AVL, GTFS).Experience working with a diverse workforce and communities.What knowledge, skills and abilities you should have within the first six months on the job:Knowledge of the public transit industry.Advanced skills in Microsoft Windows and Office (Outlook, Word, Excel, Access, and PowerPoint).Skills in one or more computer programming languages.Skills in database development and ETL, including proficiency with SQL.Skills in business intelligence report design and implementation.Skills in content management and collaborative software.Ability to interpret and apply mathematics and statistical methods and procedures.Ability to plan and lead projects.Ability to effectively present information and respond to questions from internal and external stakeholders.Ability to instruct users of all skill levels in the use of computer applications, including verbal and written instruction.Ability to provide basic client services to other departments within the organization and external partners (e.g., government agencies, vendors, etc.). Requires tact, courtesy and cooperation in dealings with others.Ability to read, analyze and interpret professional publications, technical procedures, government regulations, and legal contract language.Ability to write reports, business correspondence and procedure manuals, both to lay and technical audiences.Ability to promote an equitable, positive, and respectful work environment that values cultural diversity among all employees.Additional information
Union/Grade :
BSA I
- Non-Represented / Grade F |
BSA II
- Non-Represented / Grade G
FLSA Status :
BSA I
Non-Exempt |
BSA II
- Exempt
Safety Sensitive:
No
BSA I Full Salary Range:$34.11 - $55.35 Hourly$70,948.80 - $115,128.00 Annually
BSA
II Full Salary Range:
$36.87 - $59.84 Hourly$76,689.60 - $124,467.20 Annually
What your work environment would be:You would perform your work in a standard office setting. Work may sometimes require travel between your primary work site and other sites.
What steps the recruitment process involves:
We review your minimum qualifications.We request your Work Record Evaluation (ATU employees only).We rate your education and experience.We conduct a structured panel interview.We conduct a selection interview.
Once you have successfully completed the steps above, then:
I f you are new to the Metropolitan Council , you must pass a drug test (safety sensitive positions only), and a background check which verifies education, employment, and criminal history. A driving record check and/or physical may be conducted if applicable to the job. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation.
If you are already an employee of the Metropolitan Council , you must pass a drug test (if moving from a non-safety sensitive position to a safety sensitive position) and criminal background check if the job you're applying for is safety sensitive, is a supervisory or management job, is in the Finance, Information Services, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. A driving record check and/or physical may be conducted if applicable to the position.
IMPORTANT: If you make a false statement or withhold information, you may be barred from job consideration.
The Metropolitan Council is an Equal Opportunity, Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply.
If you have a disability that requires an accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us.
We believe our employees are a key to our agency's success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:
Guaranteed monthly retirement income through Minnesota State Retirement System pension fundOpportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) planTwo or more medical plans from which to choose, with employer contribution towards premiums over 80%Dental insurance, life insurance and vision insuranceThe following benefits are provided to all employees as part of working for the Council. You will have access to free:
Well@Work clinicbus/rail pass valued at over $1200 per yearparking at many job locationsfitness centers at many job locationsEmployee Assistance Programextensive health and wellness programs and resources
01
Applicant Instructions: The supplemental questions listed below are to further evaluate your education and experience and to determine your eligibility for this position. Answer each question completely and please do not type "see resume" otherwise your application will be considered incomplete, and you will not receive further consideration for this position. The experience you indicate in your responses should also be consistent with the Work History section of this application. If you attached a resume and/or cover letter to your application, it will be reviewed at the education and experience review step.I have read and understand the above instructions regarding supplemental questions.
YesNo
02
How did you
first
hear about this job opening?
CareerForce CenterCommunity Event/OrganizationEmployee ReferralFacebookGlassdoorIndeedJob FairLinkedInMetro Transit Bus AdvertisementTwitterWebsite: governmentjobs.comWebsite: metrocouncil.orgWebsite: metrotransit.orgWebsite: minnesotajobnetwork.comOther
03
If you selected 'Other', please describe where you first heard about this job. if you selected 'Employee Referral' please enter the employee's first and last name, ID number (if known), and job title.Type N/A if not applicable.
04
Describe your experience developing a data source or software application to aid in decision-making. Consider solutions such as database design and implementation; application design and development; or data query, analysis, and presentation. Describe your process and the tools you used. If you do not have this experience, please type "None".
05
Describe your experience managing a project, technical working group, or technical process. Describe how you defined the objectives, assigned roles and responsibilities, assigned tasks, set timelines, monitored progress, and evaluated the outcome. If you do not have this experience, please type "None".
06
Business Systems Analysts on this team specialize in various technical areas such as (1) application development / support, (2) database management, (3) data analysis / visualization, and (4) content management. Which of those areas do you consider your specialty (or specialties), and which platforms or tools do you use most in this work? If you do not have this experience, please type "None".
07
Describe your experience working with a diverse workforce or communities. If you do not have this experience, please type "None".
Required Question