Business Systems Analyst II (BSA 2)

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. More information about us on our website.

We are committed to supporting a diverse workforce that reflects the communities we serve.

Metro Transit is one of the countrys largest transit systems employing more than 3200 people and provides millions of rides a year through an integrated network of buses light rail and commuter trains as well as resources 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 II (BSA 2) in Service Developments 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 and can change rapidly depending on staff availability individual skills and the evolving needs of the department.

• Serves as product administrator of Service Development scheduling software (HASTUS) in both technical and administrative capacities.
• Oversees and carries out tasks for the team including vendor management installation configuration testing troubleshooting upgrading maintaining and exporting data into Council databases using HASTUS scripting language (OIG).
• Plans and prioritizes work coordinates with internal stakeholders and vendors manages timelines and dependencies and communicates progress and risks.
• Works with databases and other technical systems or software.
• Performs other technical and analytical work as needed in response to changing priorities emerging technologies or organizational needs.

Any of the following combinations of transit experience or related work experience with data systems management programming IT project management and/or data and systems analysis and completed education in Management Information Systems Business Administration or closely related field.

• High school diploma or GED and seven (7) years of relevant work experience.
• Associate degree and five (5) years of relevant work experience.
• Bachelors degree or higher and three (3) years of relevant work experience.

What additional skills and experience would be helpful in this job (desired qualifications):

• Experience working with HASTUS and/or other transit-related planning scheduling or operational software.
• Experience with transit data (e.g. APC AVL AFC GTFS).
• Knowledge of relational databases ETL or data analysis languages (e.g. SQL HASTUS OIG R Python etc. ).
• Ability to read and write basic computer code and work with complex software with many modules and facets.
• Knowledge of Microsoft suite (Word Excel SharePoint Teams)
• Knowledge of Power BI.
• Experience with project management.
• Experience working with a diverse workforce and communities.
• Demonstrates humility ambition emotional intelligence and a clear commitment to public service and public transportation.
• Recognizes and praises the contributions of others shares credit freely and acknowledges mistakes or limitations without defensiveness.
• Seeks opportunities to grow improve systems and increase impact while willingly taking on unglamorous or challenging work for the good of the team and riders.
• Supports a positive respectful workplace by listening attentively showing empathy and adapting their communication style to different situations.
• Values employees supports a safe and welcoming experience and contributes to service that is reliable convenient and environmentally sustainable.

What knowledge skills and abilities you should have within the first six months on the job:

• Knowledge of the public transit industry.
• Knowledge of workflow analysis and simplification techniques.
• Advanced skills in Microsoft Windows and Office (Word Excel and PowerPoint).
• Experience with the application development process and use of programming and scripting languages including basic SQL.
• Skills in content management and collaborative software such as Teams and SharePoint.
• Ability to plan and lead projects including definition of goals objectives and implementation steps; project timeline and dependencies; communication with participants; and monitoring and evaluation.
• Ability to effectively present information and respond to questions from groups of customers or clients.
• 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 the public and other agencies within the organization. Requires tact courtesy and cooperation in dealings with others.
• Ability to read analyze and interpret professional journals technical procedures government regulations and legal contract language.
• Ability to write reports business correspondence and procedure manuals both to lay and technical audiences.
• Promote an equitable positive and respectful work environment that values cultural diversity among all employees.

• We offer theopportunity to make a difference and positively influence the Twin Cities metropolitan area.
• We encourage our employees to develop their skills through on-site training and tuition reimbursement.
• We provide a competitive salary excellent benefits and a good work/life balance.
• More about why you should join us!

Union/Grade: Non Represented / Grade G
FLSA Status: Exempt
Safety Sensitive: No

What your work environment would be:
Work is performed in a standard office setting. You may travel between primary worksite and other sites.

What steps the recruitment process involves:
You must qualify at each of the numbered steps below to be considered a final candidate for the job.

1. We review your minimum qualifications.
2. We rate your education and experience.
3. We conduct a structured panel interview.
4. We conduct a selection interview.

Once you have successfully completed the steps above then:

If 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 youre 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 accommodation during the selection process please email.