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 country's largest transit systems, employing more than 3,200 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 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 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.
• Bachelor's 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 the opportunity 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 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 accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us.