Manager, BI and Analytics (IS Manager 1)

Print (https://www.governmentjobs.com/careers/metrocouncil/jobs/newprint/4473559)

Apply



Manager, BI and Analytics (IS Manager 1)

Salary

$89,606.40 - $145,433.60 Annually

Location

390 Robert St. N St. Paul, MN

Job Type

Full-Time

Job Number

2024-00115

Division

Regional Administration

Department

IS-Admin

Opening Date

04/22/2024

Closing Date

5/6/2024 11:59 PM Central

• Description

• Benefits

• Questions

WHO WE ARE

This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin.

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. (https://metrocouncil.org/About-Us/The-Council-Who-We-Are.aspx)

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

Information Services is the central IT department supporting all divisions of the Metropolitan Council. Our 140 team members provide technology, practices, and innovative solutions that enable the core services of the Council.

How your work would contribute to our organization and the Twin Cities region:

TheManager, BI & Analyticsmanages, plans, and leads the Information Services team including business intelligence (BI) reporting and analytics development, delivery and support functions and administrative, supervisory, and managerial duties. This includes strategic planning, operating and capital budget development, coaching and performance management, workforce planning and hiring, and establishment of goals and priorities, and overseeing software and/or hardware selection and implementation. Has significant responsibility in the selection and coordination of vendor services and licensing agreements.

TheManager, BI & Analyticsleads all work tasks within the job function. This role requires a high degree of expertise in SQL and reporting technologies, data modeling, structured and unstructured data, and strong programming skills. They must be able to manage the team’s work from small to large initiatives and develop BI and analytical strategies.

The ideal candidate for the position has a proven track record of effective management and possesses advanced leadership and strategic planning skills. They have strong communication and interpersonal abilities which are crucial for fostering a collaborative team environment. The ideal candidate showcases adaptability, resilience, and the capacity to navigate change seamlessly. A history of successful cross-functional collaboration and the ability to motivate teams toward common goals would further enhance the candidate's suitability for this leadership role.

Benefits:Great work/life balance, insurance starting on day one, MN State Retirement Program pension, in-house clinic, salary continuance for injury or illness, 13 paid holidays per year plus generous annual leave, employee development, free Metro Transit rides, and much more!

What you would do in this job

• Supervise a team of professionals, working collaboratively to develop, review, and adjust employee work plans, performance goals, and development plans. This includes recruiting and hiring, performance management and evaluation, mentoring, coaching, team building and serving.

• Collaborate with technology and business units to understand BI needs, objectives, and Key Performance Indicators, and oversee the design, development, and maintenance of BI and analytical solutions.

• Make solutions available to reporting consumers, including executives, managers, line-of-business users, business analysts, data scientists, citizen developers, government partners, and/or the public at large.

• Operate as a cost center/function within an IT Service Management model, establishing and maintaining Service Level commitments and developing and maintaining a budget for the function.

• Responsible for creating and implementing BI and Analytical strategies, procedures, and best practices that are aligned with the Council information technology standards, goals, and objectives.

• Provide analytical support and leadership in assessment of overall functionality and effectiveness of Council technology systems, integration with existing or planned systems, and ongoing support.

• Act as a liaison between the IS department and other departments to ensure transparency and strong, positive relationships.

• Manage technical staff to participate in and manage projects efficiently, including project definitions, work plans, documentation, scheduling, control methods, status reporting and collaborating with vendors when needed.

• Develop contract specifications and manage/monitor contractor work.

• Create a data and analytics center of excellence/enablement and support IS and business end users with self-service reporting.

• Mentor, train, and support IS and business users on BI and analytics, providing leadership and guidance.

• Administer, monitor, and maintain BI and Analytics alerts and users subscriptions, ensuring security, performance, and availability.

• Provide on-going BI reporting production support and maintenance, troubleshooting, and resolving related issues to minimize business impacts.

• Work with IS and business teams on data security and data classifications.

• Partner with Cybersecurity on security issues/investigations/breaches and may help conduct security incident investigation and response.

• Manage and perform BI development using various software methodologies.

• Utilize a variety of data sources including structured and unstructured data.

• Where applicable, use operational and reporting DBs, data stores, data lakes, data warehouses, and data marts for reporting and analytics.

• Write and understand SQL queries and SQL best practices.

• Manage the BI software installations and configurations, BI code repositories, and non-production BI environments and code pipelines.

• Manage scripting, automation, configuration, and monitor BI processes.

• Follow incident, service, and change management processes and procedures.

• Partner with Data Architects on BI and reporting architecture and design.

• Conduct BI capacity planning, feasibility studies, and analyze requirements.

• Innovate and use emerging technology and participate in strategic planning.

• May work with application integrations, APIs, and Web Services.

What education and experience are required for this job (minimum qualifications)

Any of the following combinations of education (in Computer Science/Engineering, Information Technology, or related) and experience (in information technology or related field):

• Bachelor's degree and six (6) years of experience, including three (3) years of experience leading people and/or projects.

• Associate's degree and eight (8) years of experience, including three (3) years of experience leading people and/or projects.

• High school diploma/GED and ten (10) years of experience, including three (3) years of experience leading people and/or projects.

Metropolitan Council Employees Only:Successful completion of any one of the following four Metropolitan Council Leadership/Supervisory training programs will substitute for lead/supervisory experience. You must attach your certificate(s) as proof of completion of the program to your application. Only completion of one of the four programs listed below will substitute credit (6 months or 1 year) for lead/supervisory experience.

Met Council's Programs and years of lead/supervisory experience program count for:

• Metro Transit Leadership Academy: 1 year of lead/supervisory experience

• Project Management Development Program - 12-month session: 1 year of lead/supervisory experience

• Project Management Development Program - 6-month session: 6 months of lead/supervisory experience

• Four Learning Institute Certificates - You must obtain all four certificates listed below to receive credit: 6 months of lead/supervisory experience.

• Leading Self-Personal Effectiveness Certificate

• Leading Self-Communication Certificate

• Leading Self-Business Skills Certificate

• Leading Others-Preparing for Supervisor Certificate

Knowledge, Skills, and Abilities Required:

• In-depth understanding of BI and Analytical solutions and architectures.

• Design, develop, and manage BI solutions including reports, dashboards, and visualizations using a variety of BI tools and technologies.

• Define KPIs, using quantitative and qualitative analysis.

• Interpret complex data using statistical and computational techniques with predictive and analytical models to forecast future outcomes, opportunities, and identify potential risks.

• Collaborate, train, and consult with IS and business units and understand stakeholder BI requirements, needs, and objectives.

• Understand and use Big Data, operational and reporting DBs, data stores, data lakes, data warehouses, and data marts for reporting and analytics.

• BI development methodologies, best practices, standards, and procedures.

• Write complex SQL and define SQL best practices.

• Programming language knowledge with at least one scripting language.

• Manage BI solutions, ensuring their security, performance, and availability.

• Report and visualization accessibility methods.

• Manage static and data-driven report subscriptions and alerts.

• Strong leadership in problem-solving and analytical skills to resolve issues.

• Installing, configuring, administering, and supporting BI tools.

• Knowledge of data classifications and data practice retention methods.

• Experience supporting self-service reporting solutions.

• Know about emerging technologies and laws around reporting and analytics.

• Attention to detail to ensure the accuracy and reliability of BI solutions.

• Ability to define and articulate BI strategies and align to organizational goals.

• Team and leadership skills and the ability to manage multiple initiatives.

• Budgeting, planning, scheduling, staffing and process management.

• ITIL, Incident, Service and Change Management, including SLAs and metrics.

• Familiarity with IT vendors, products, and services.

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

• Demonstrated experience in project management, budget oversight, and implementing process improvements.

• Familiarity with industry technologies with a forward-thinking approach to innovation.

• Experience promoting an equitable, positive, and respectful work environment that values culture and diversity among all employees.

• Experience developing cloud BI solutions and accessing cloud data sources.

• Experience building a data and analytics center of excellence/enablement.

• Data engineering, data pipelines, ETL/ELT and data warehousing experience.

• Knowledge of data security incident investigation and reporting methods.

• A solid understanding of the business processes and operations at the Council (e.g. transit, human resources, accounting, finance).

• Experience using APIs, Web Services, and Integration Platform as a Service.

• Cloud and on-prem Artificial Intelligence and Machine Learning experience.

• Knowledge of laws relating to data including those in public agencies.

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! (http://metrocouncil.org/Employment/Making-A-Difference.aspx)

Additional information

Bargaining Unit(s)/Grade: MANA/Grade J

FLSA Status: Exempt

Safety Sensitive: No

Work Environment:

Work is performed in a standard office setting. Some positions may require travel between primary work site to other sites.

Physical Requirements:

Regularly required to sit for long periods, stand/walk occasionally, speak, hear normal conversation and telephone ring tones, operate a computer and other office equipment, reach with hands/arms frequently below chest height and occasionally overhead, must occasionally lift/carry/push/pull up to 10 pounds, must have adequate close vision for reading and computer work.

Security Policy:

This position involves direct access to Criminal Justice Information (CJI) as defined by the FBI CJIS (Criminal Justice Information Services) Security Policy. In accordance with section 5.12.1.1 of the FBI CJIS Security Policy, final candidates must agree to submit to a state of residence and national fingerprint-based record check. If the result of the record check reveals criminal convictions, the nature and circumstances of those convictions will be reviewed by the Metropolitan Transit Police Department and/or the Minnesota Bureau of Criminal Apprehension to determine if access to Criminal Justice Information would be permissible. If it is determined that access to Criminal Justice Information would not be permissible, the candidate will no longer be eligible for this position.

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.

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 fund

• Opportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) plan

• Two or more medical plans from which to choose, with employer contribution towards premiums over 80%

• Dental insurance, life insurance and vision insurance

The following benefits are provided to all employees as part of working for the Council. You will have access to free:

• Well@Work clinic

• bus/rail pass valued at over $1200 per year

• parking at many job locations

• fitness centers at many job locations

• Employee Assistance Program

• extensive 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 attach a resume 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.

• Yes

• No

  02

  How did youfirsthear about this job opening?

• CareerForce Center

• Community Event/Organization

• Employee Referral

• Facebook

• Glassdoor

• Indeed

• Job Fair

• LinkedIn

• Metro Transit Bus Advertisement

• Twitter

• Website: governmentjobs.com

• Website: metrocouncil.org

• Website: metrotransit.org

• Website: minnesotajobnetwork.com

• Other

  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

  The salary range for this position is $43.08 - $69.92 hourly/$89,606 - $145,434 annually. Please list your minimum compensation expectation below. NOTE: If selected for the position, our salary offer will NOT exceed the top of the full salary range.

  05

  Please select the option that best describes your level of education.

• High school diploma or GED

• Associate's degree

• Bachelor's degree

• Master's degree or higher

• None of the above

  06

  If you have a degree, please list the degree field below. If this does not apply to you, type "N/A."

  07

  Please indicate your years of progressively responsible experience in IT or a related field (e.g., business intelligence and analytics, data engineering, or application development/support).

• Less than six (6) years

• Six (6) years but less than seven (7) years

• Seven (7) years but less than nine (9) years

• Nine (9) years but less than eleven (11) years

• Eleven (11) or more years

• None of the above

  08

  Do you have at least three (3) years of experience leading IT staff? NOTE: If you completed an approved Metropolitan Council leadership development/supervisory training program, you must attach your program completion certificate to your application.

• Yes

• No

  09

  Please select the areas below with which you have experience (select all that apply).

• In-depth understanding of BI and Analytical solutions and architectures.

• Designing, developing, and managing BI solutions including reports, dashboards, and visualizations, using a variety of BI tools and technologies.

• Defining KPIs, using quantitative and qualitative analysis.

• Interpreting complex data using statistical and computational techniques with predictive and analytical models to forecast future outcomes, opportunities, and identify potential risks.

• Collaborating, training, and consulting with IS and business units and understanding stakeholder BI requirements, needs and objectives.

• Understanding and using Big Data, operational and reporting DBs, data stores, data lakes, data warehouses, and data marts for reporting and analytics.

• BI development methodologies, best practices, standards, and procedures.

• Writing complex SQL and defining SQL best practices.

• Managing BI solutions, ensuring their security, performance, and availability.

• Programming language knowledge with at least one scripting language.

• Reporting and visualization accessibility methods.

• Managing static and data-driven report subscriptions and alerts.

  10

  Please select the areas below with which you have experience (select ALL that apply).

• Strong leadership in problem-solving and analytical skills to resolve issues.

• Installing, configuring, administering, and supporting BI tools.

• Knowledge of data classifications and data practice retention methods.

• Experience supporting self-service reporting solutions.

• Know about emerging technologies and laws around reporting and analytics.

• Attention to detail to ensure the accuracy and reliability of BI solutions.

• Ability to define and articulate BI strategies and align to organizational goals.

• Team and leadership skills and the ability to manage multiple initiatives.

• Budgeting, planning, scheduling, staffing and process management.

• ITIL, Incident, Service and Change Management, including SLAs and metrics.

• Familiarity with IT vendors, products, and services.

  11

  Please describe your management experience including the organization, responsibilities held, and duration of position(s). If this experience doesn't apply to you, please type "N/A".

  12

  In detail, please describe your experience promoting an equitable, positive, and respectful work environment that values culture and diversity among all employees. If this experience doesn't apply to you, please type "N/A".

  13

  Please select the areas below in which you have knowledge, skills, and abilities (select ALL that apply).

• Relevant and industry technologies and innovations.

• Experience developing cloud BI solutions and accessing cloud data sources.

• Experience building a data and analytics center of excellence/enablement.

• Data engineering, data pipelines, ETL/ELT, and data warehousing experience.

• Knowledge of data security incident investigation and reporting methods.

• A solid understanding of the business processes and operations at the Council (e.g. transit, human resources, accounting, finance).

• Experience using APIs, Web Services, and Integration Platform as a Service.

• Cloud and on-prem Artificial Intelligence and Machine Learning experience.

• Knowledge of laws relating to data, including those in public agencies

  14

  This is a hybrid position that requires working at least one day per week in the 390 Robert St., St. Paul MN office. Can you meet this requirement?

• Yes

• No

  Required Question

Agency

Metropolitan Council

Address

390 Robert St. N.St. Paul, Minnesota, 55101

Website

https://metrocouncil.org

Apply

Please verify your email addressVerify Email