Metropolitan Council
Business Systems Analyst 2 or 3
Metropolitan Council, Saint Paul, Minnesota, United States, 55130
WHO WE AREWe 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, employs more than 3,000 people, and provides ridership 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 (BSA) works within the Material Management department , which is a subunit of the Finance department within Metro Transit. The BSA will be responsible for the proper administration, maintenance, and execution of all technological, reporting, and analysis processes utilized by the department to meet its responsibilities and mandates with respect to financial reporting, security, and stewardship.The BSA role is dually responsible for the lifecycle of all departmental technology (Informational and Operational) and ensuring its ongoing applicability, adoption, and performance within the Supply Chain operations (warehousing, logistics, and inventory management) of Metro Transit. In these capacities, the BSA will function as both a technical leader, trainer, and liaison to others as well as a primary source of business process expertise and work product (analyses and project leadership) as derived from departmental technologies and knowledge of various data sources.The range of BSA responsibilities and tasks include (but are not limited to):
database administration; server administration; software installations, patching, and upgrades; device/hardware support (e.g., computers and mobile devices); first responder for systems troubleshooting and service inquiries; closed loop management of large-scale Operational Technology (automated material handling and storage systems); data mining, transformation, and warehousing; programming/coding and scripting; application development; root cause and statistical analysis; financial reporting and auditing; inventory optimization; business process (re)design and documentation; business and use case development; lifecycle management (including divestiture); vendor management; contract management; technology sourcing; training and development; and project management.This posting will create a six-month eligible list for current and future openings.What you would do in this jobBSA 2:Management of departmental-specific Supply Chain Operational Technology (OT), Information Technology (IT), and associated capabilities:Automated material handling and storage systems (vertical lift modules and horizontal-driven carousel) and their closed loop integration with Enterprise Resource Planning (ERP) and associated reportingEnsuring uptime and efficiency of departmental analysis server (Windows Server 2012R2)Android-based mobile devices with integrated imager/scanner (CipherLab RK95)Network thermal transfer printing (Zebra Technologies)Barcode design, development, deployment, and reporting integrationDatabase Administrator (DBA) and Developer level activities associated with departmental-specific SQL Server and Access databasesMaintenance and development of departmental SharePoint site, Teams groups, and enterprise shared driveManaging all departmental technology procurement processes and refreshes/leases (e.g., laptops, printers, etc.)Inclusive of all IT system design, sourcing, data integration (e.g., closed loop with legacy ERP), implementation, training, and operational supportIncludes OT, IT, and device preventive maintenance contracts, IT service agreements, and software licensingManagement of Supply Chain reporting and analysis:
Holistic management of all recurring/structural and ad hoc departmental reporting and visualizations/dashboardsRecurring and periodic statistical analysis, root cause analysis, report development, and data mining, transformation, warehousing, deployment, presentation, and interpretationManagement of Supply Chain systems and technology:
Technical liaison to all departmental staff and with other departments, personnel, and enterprise support groupsFirst line of support and remediation within department for technology inquiries from staff and errors generated by departmental and enterprise systems and technologyLead and drive completion of any fixes and enhancements to IS-supported systems, particularly ERP or Enterprise Asset Management (EAM)Managing life cycle (e.g., upgrades, patches, etc.) and end-of-life activities for all departmental technologyManaging all departmental technology procurement processes, refreshes, and leases (e.g., laptops, printers, etc.)Administering all data access, identity management, roles, and permissions processes for the departmentSystems and data lead in support of all departmental capital projects and facility expansions/movementsEstablishing need for, sourcing, and implementing solutions in the areas of business intelligence, collaboration, document retention, and content managementIdentification and development of solutions (e.g., available/supported in the enterprise, custom, or commercial-off-the-shelf) to address any process, workflow, or data integration gaps (including interdepartmental and enterprise-wide)Leading large-scale departmental business system implementation projects from end-to-end including directing internal and enterprise staff and resourcesTechnical lead in all enterprise IS efforts affecting departmental technology and operationsTechnical liaison and leader in support of pending ERP system migrationRepresent department on various enterprise technology governance, standards, security, and project management efforts, initiatives, and teamsSupport of critical Supply Chain programs:
Departmental metrics/KPIsInventory obsolescence - Recovery (e.g., auctioning business processes) and waste stream managementInventory optimization - Applying statistical optimization and forecasting techniques to balance cost and service levelsInventory reverse logistics - Centralized pooling of inventory and buffers to further availability, optimization, and cost avoidanceInclusive of all data mining, transformation, integration, warehousing, and deploymentIncludes all system design, sourcing, development, distribution/visualization, interpretation, and any associated IT service agreements and licensingProvides work direction to departmental staff as required.
Performs other related duties as assigned.
BSA 3:The BSA 3 position is inclusive of all the job duties above, but also engenders a broader understanding of business systems available and employed, a greater degree of independent judgment exercised, further autonomy and responsibility to perform more complex modifications and configurations within the business systems, and independent extensions and transformations of systems' data and capabilities that facilitate decision-making and improve business processes. BSA 3 incumbents have a significant role in system and platform selection, analysis, problem identification, and recommendation/presentation of solutions and enhancements to upper management. BSA 3 positions lead organization-wide teams on system implementation projects and serve as a champion for business process improvements.What education and experience are required for this job (minimum qualifications)BSA 2, Non-Rep, Grade G:Any of the following combinations of progressively responsible experience in management analysis and business systems administration, or related experience in a Business Analyst capacity and closely related experience
AND
completed education in Management Information Systems (MIS), Computer Science, Supply Chain Management (purchasing, operations management, and logistics), Finance, Business Administration, or closely related field.High school diploma/GED with seven (7) years of experience.
Associate's degree with five (5) years of experiences.
Bachelor's degree or higher with three (3) years of experience.
Master's degree with one (1) year of experience.
BSA 3, Non-Rep, Grade H:
Any of the following combinations of progressively responsible experience in management analysis and business systems administration, or related experience in a Business Analyst capacity or closely related experience
AND
completed education in Management Information Systems (MIS), Computer Science, Supply Chain Management (purchasing, operations management, and logistics), Finance, Business Administration, or closely related field. A minimum of one (1) year of experience must include performing configurations and modifications within specific business systems or extracting, transforming, and deploying system data to facilitate operational decision-making and business process improvement.High school diploma/GED with eight (8) years of experience.
Associate's degree with six (6) years of experiences.
Bachelor's degree or higher with four (4) years of experience.
Master's degree with two (2) years of experience.
What additional skills and experience would be helpful in this job (desired qualifications):
Experience working and collaborating in diverse, multicultural, and inclusive environments.At least two (2) years or more experience utilizing and interpreting various coding languages and SQL to support business systems, projects, analysis, reporting, and operational processesAt least one (1) year or more experience working on large technology projects in a technical or analytical capacitySpecific project experience migrating ERP systems, business processes, and data requirements to a new software and platformAt least one (1) year or more experience producing business analyses or metrics that require root cause analysis, statistical calculations, and the use of large data sourcesAt least one (1) year or more experience documenting and training staff on the use of departmental and enterprise business systems and processesAt least one (1) year or more experience working in warehousing, distribution, logistics (i.e., transportation), inventory management, manufacturing, or operations planning and scheduling
What knowledge, skills and abilities you should have for this job:
Development, implementation, and enhancement of collaborative, workflow- or process-based software systems, and visualization/dashboard toolsets that involves the extension and transformation of data sources.Application of statistical techniques, methodologies, and algorithms.Practical experience managing master data (Master Data Management (MDM)) and operational data in support of business operations.Specific systems and systems-related skills (required):
Access database, Visual Basic for Applications (VBA), and associated Structured Query Language (SQL)SQL Server database and associated SQLSybase database and associated SQLT-SQL scripting (e.g., stored procedures, triggers) and job schedulingWindows Server 2012R2 (Virtual Machine)Microsoft Power Platform (BI, Automate, and Apps) and DAXERP systems (legacy and PeopleSoft)Office 365 applicationsSharePoint and TeamsCrystal ReportsSAP BI/BOManagement of groups (e.g., SharePoint, Office 365, Active DirectoryApplicationEnhancer.NET and Visual StudioPythonRAzure Data FactoryJava and C# languagesBusiness Process Model and Notation (BPMN) or similar
Ability to train staff on departmental business systems and processes.Ability to collaborate as the technical liaison to all departmental staff and with other departments, personnel, and enterprise support groups.Ability to be the first line of support and remediation within department for technology inquiries from staff and errors generated by departmental and enterprise systems and technology.What you can expect from us: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!
Additional informationBSA 2 Union/Grade:
Non-Represented / Grade GBSA 3 Union/Grade:
Non-Represented /Grade HFLSA Status : ExemptSafety Sensitive:
No
BSA 2 Salary Range:
$36.87 - $59.84 Hourly | $76,689.60 - $124,467.20 AnnuallyBSA 3 Salary Range:
$39.86 - $64.69 Hourly | $82,908.80 - $134,555.20 Annually
Work EnvironmentWork is performed in a standard office setting. Some positions may require travel between primary work site to other sites.
What steps the recruitment process involves:
We review your minimum qualifications.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:
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 an accommodation during the selection process, please email HR-CCHealth@metc.state.mn.us.
Business Systems Analyst (BSA) works within the Material Management department , which is a subunit of the Finance department within Metro Transit. The BSA will be responsible for the proper administration, maintenance, and execution of all technological, reporting, and analysis processes utilized by the department to meet its responsibilities and mandates with respect to financial reporting, security, and stewardship.The BSA role is dually responsible for the lifecycle of all departmental technology (Informational and Operational) and ensuring its ongoing applicability, adoption, and performance within the Supply Chain operations (warehousing, logistics, and inventory management) of Metro Transit. In these capacities, the BSA will function as both a technical leader, trainer, and liaison to others as well as a primary source of business process expertise and work product (analyses and project leadership) as derived from departmental technologies and knowledge of various data sources.The range of BSA responsibilities and tasks include (but are not limited to):
database administration; server administration; software installations, patching, and upgrades; device/hardware support (e.g., computers and mobile devices); first responder for systems troubleshooting and service inquiries; closed loop management of large-scale Operational Technology (automated material handling and storage systems); data mining, transformation, and warehousing; programming/coding and scripting; application development; root cause and statistical analysis; financial reporting and auditing; inventory optimization; business process (re)design and documentation; business and use case development; lifecycle management (including divestiture); vendor management; contract management; technology sourcing; training and development; and project management.This posting will create a six-month eligible list for current and future openings.What you would do in this jobBSA 2:Management of departmental-specific Supply Chain Operational Technology (OT), Information Technology (IT), and associated capabilities:Automated material handling and storage systems (vertical lift modules and horizontal-driven carousel) and their closed loop integration with Enterprise Resource Planning (ERP) and associated reportingEnsuring uptime and efficiency of departmental analysis server (Windows Server 2012R2)Android-based mobile devices with integrated imager/scanner (CipherLab RK95)Network thermal transfer printing (Zebra Technologies)Barcode design, development, deployment, and reporting integrationDatabase Administrator (DBA) and Developer level activities associated with departmental-specific SQL Server and Access databasesMaintenance and development of departmental SharePoint site, Teams groups, and enterprise shared driveManaging all departmental technology procurement processes and refreshes/leases (e.g., laptops, printers, etc.)Inclusive of all IT system design, sourcing, data integration (e.g., closed loop with legacy ERP), implementation, training, and operational supportIncludes OT, IT, and device preventive maintenance contracts, IT service agreements, and software licensingManagement of Supply Chain reporting and analysis:
Holistic management of all recurring/structural and ad hoc departmental reporting and visualizations/dashboardsRecurring and periodic statistical analysis, root cause analysis, report development, and data mining, transformation, warehousing, deployment, presentation, and interpretationManagement of Supply Chain systems and technology:
Technical liaison to all departmental staff and with other departments, personnel, and enterprise support groupsFirst line of support and remediation within department for technology inquiries from staff and errors generated by departmental and enterprise systems and technologyLead and drive completion of any fixes and enhancements to IS-supported systems, particularly ERP or Enterprise Asset Management (EAM)Managing life cycle (e.g., upgrades, patches, etc.) and end-of-life activities for all departmental technologyManaging all departmental technology procurement processes, refreshes, and leases (e.g., laptops, printers, etc.)Administering all data access, identity management, roles, and permissions processes for the departmentSystems and data lead in support of all departmental capital projects and facility expansions/movementsEstablishing need for, sourcing, and implementing solutions in the areas of business intelligence, collaboration, document retention, and content managementIdentification and development of solutions (e.g., available/supported in the enterprise, custom, or commercial-off-the-shelf) to address any process, workflow, or data integration gaps (including interdepartmental and enterprise-wide)Leading large-scale departmental business system implementation projects from end-to-end including directing internal and enterprise staff and resourcesTechnical lead in all enterprise IS efforts affecting departmental technology and operationsTechnical liaison and leader in support of pending ERP system migrationRepresent department on various enterprise technology governance, standards, security, and project management efforts, initiatives, and teamsSupport of critical Supply Chain programs:
Departmental metrics/KPIsInventory obsolescence - Recovery (e.g., auctioning business processes) and waste stream managementInventory optimization - Applying statistical optimization and forecasting techniques to balance cost and service levelsInventory reverse logistics - Centralized pooling of inventory and buffers to further availability, optimization, and cost avoidanceInclusive of all data mining, transformation, integration, warehousing, and deploymentIncludes all system design, sourcing, development, distribution/visualization, interpretation, and any associated IT service agreements and licensingProvides work direction to departmental staff as required.
Performs other related duties as assigned.
BSA 3:The BSA 3 position is inclusive of all the job duties above, but also engenders a broader understanding of business systems available and employed, a greater degree of independent judgment exercised, further autonomy and responsibility to perform more complex modifications and configurations within the business systems, and independent extensions and transformations of systems' data and capabilities that facilitate decision-making and improve business processes. BSA 3 incumbents have a significant role in system and platform selection, analysis, problem identification, and recommendation/presentation of solutions and enhancements to upper management. BSA 3 positions lead organization-wide teams on system implementation projects and serve as a champion for business process improvements.What education and experience are required for this job (minimum qualifications)BSA 2, Non-Rep, Grade G:Any of the following combinations of progressively responsible experience in management analysis and business systems administration, or related experience in a Business Analyst capacity and closely related experience
AND
completed education in Management Information Systems (MIS), Computer Science, Supply Chain Management (purchasing, operations management, and logistics), Finance, Business Administration, or closely related field.High school diploma/GED with seven (7) years of experience.
Associate's degree with five (5) years of experiences.
Bachelor's degree or higher with three (3) years of experience.
Master's degree with one (1) year of experience.
BSA 3, Non-Rep, Grade H:
Any of the following combinations of progressively responsible experience in management analysis and business systems administration, or related experience in a Business Analyst capacity or closely related experience
AND
completed education in Management Information Systems (MIS), Computer Science, Supply Chain Management (purchasing, operations management, and logistics), Finance, Business Administration, or closely related field. A minimum of one (1) year of experience must include performing configurations and modifications within specific business systems or extracting, transforming, and deploying system data to facilitate operational decision-making and business process improvement.High school diploma/GED with eight (8) years of experience.
Associate's degree with six (6) years of experiences.
Bachelor's degree or higher with four (4) years of experience.
Master's degree with two (2) years of experience.
What additional skills and experience would be helpful in this job (desired qualifications):
Experience working and collaborating in diverse, multicultural, and inclusive environments.At least two (2) years or more experience utilizing and interpreting various coding languages and SQL to support business systems, projects, analysis, reporting, and operational processesAt least one (1) year or more experience working on large technology projects in a technical or analytical capacitySpecific project experience migrating ERP systems, business processes, and data requirements to a new software and platformAt least one (1) year or more experience producing business analyses or metrics that require root cause analysis, statistical calculations, and the use of large data sourcesAt least one (1) year or more experience documenting and training staff on the use of departmental and enterprise business systems and processesAt least one (1) year or more experience working in warehousing, distribution, logistics (i.e., transportation), inventory management, manufacturing, or operations planning and scheduling
What knowledge, skills and abilities you should have for this job:
Development, implementation, and enhancement of collaborative, workflow- or process-based software systems, and visualization/dashboard toolsets that involves the extension and transformation of data sources.Application of statistical techniques, methodologies, and algorithms.Practical experience managing master data (Master Data Management (MDM)) and operational data in support of business operations.Specific systems and systems-related skills (required):
Access database, Visual Basic for Applications (VBA), and associated Structured Query Language (SQL)SQL Server database and associated SQLSybase database and associated SQLT-SQL scripting (e.g., stored procedures, triggers) and job schedulingWindows Server 2012R2 (Virtual Machine)Microsoft Power Platform (BI, Automate, and Apps) and DAXERP systems (legacy and PeopleSoft)Office 365 applicationsSharePoint and TeamsCrystal ReportsSAP BI/BOManagement of groups (e.g., SharePoint, Office 365, Active DirectoryApplicationEnhancer.NET and Visual StudioPythonRAzure Data FactoryJava and C# languagesBusiness Process Model and Notation (BPMN) or similar
Ability to train staff on departmental business systems and processes.Ability to collaborate as the technical liaison to all departmental staff and with other departments, personnel, and enterprise support groups.Ability to be the first line of support and remediation within department for technology inquiries from staff and errors generated by departmental and enterprise systems and technology.What you can expect from us: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!
Additional informationBSA 2 Union/Grade:
Non-Represented / Grade GBSA 3 Union/Grade:
Non-Represented /Grade HFLSA Status : ExemptSafety Sensitive:
No
BSA 2 Salary Range:
$36.87 - $59.84 Hourly | $76,689.60 - $124,467.20 AnnuallyBSA 3 Salary Range:
$39.86 - $64.69 Hourly | $82,908.80 - $134,555.20 Annually
Work EnvironmentWork is performed in a standard office setting. Some positions may require travel between primary work site to other sites.
What steps the recruitment process involves:
We review your minimum qualifications.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:
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 an accommodation during the selection process, please email HR-CCHealth@metc.state.mn.us.