Bridge Fellow - Associate BI Developer

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

Apply



Bridge Fellow - Associate BI Developer

Salary

$29.69 - $44.82 Hourly

Location

390 Robert St. N St. Paul, MN

Job Type

Temporary Long Term (up to 2 years)

Remote Employment

Flexible/Hybrid

Job Number

2024-00178

Division

Regional Administration

Department

IS-Admin

Opening Date

05/05/2024

Closing Date

5/19/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.Information about us on our website. (https://metrocouncil.org/About-Us/The-Council-Who-We-Are.aspx)

The 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.

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

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

TheBridge Fellow -Associate BI Developeris an entry-level role responsible for helping design, develop, and maintain business intelligence (BI) reporting and analytical solutions. They help collaborate with technology and business units to understand BI objectives and Key Performance Indicators and may use quantitative and/or qualitative analysis. They help create a variety of solutions including paginated reports, dashboards, interactive visualizations, metrics, dataflows, shared datasets, and/or predictive models (AI/ML). They help make these 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. They help administer, monitor, and maintain reporting solutions, ensuring their security, performance, and availability. They may also help administer BI tools and may identify and resolve data quality issues.

The Bridge Fellow - Associate BI Developerworks on matters of limited complexity in a support role and their work is closely managed. They work with reporting solutions of less complexity that typically do not have council-wide impact and perform routine and less complex reporting and maintenance tasks. They are often directed in several aspects of the work. This role requires entry-level knowledge of reporting technologies, databases (DBs), data modeling, structured and unstructured data, and programming skills. They must learn and become aware of and comply with data governance and data security requirements.

What is the Bridge Program?

The Bridge Program is a long-term, two-year position, which allows students and recent graduates to bridge the gap between their education and experience to become successful in the workplace. The Bridge program is designed to be along-term temporary (2 years) position. This position is eligible for benefits.

What you would do in this job

• Determine and analyze stakeholder requirements.

• Design, develop, and maintain reports, data visualizations, dashboards, metrics, and analytical solutions using a variety of BI tools and technologies.

• 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.

• Perform BI development using various software methodologies.

• Write and understand SQL queries and SQL best practices.

• Understand data security and data classifications.

• Innovate and leverage emerging technology.

• Provide on-going BI reporting production support and maintenance.

• Install and configure BI software.

• Script, automate, configure, and monitor BI processes.

• Setup and manage BI code repositories.

• Support non-production BI environments and code pipelines.

• Partner with Servers, Storage and Backup on server OS and file backups.

• Monitor BI performance, manage IS alerts and user subscriptions.

• Comply with all data-related federal, state, and local laws.

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

• Adhere to Data Practices retention schedules.

• Support end users with self-service reporting.

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

Bachelor’s degree (or soon to graduate within 6 months) in computer science/engineering, information technology, or related field.

OR

Associate’s degree (or soon to graduate within 6 months) computer science/engineering, information technology, or related field AND two years of relating experience in information technology.

Bridge Program Eligibility:

Graduated (or soon to graduate within 6 months) with a 4-year degree/master’s degree within the last 2 years from posting date.

OR

Graduated (or soon to graduate within 6 months) with a 2-year degree within the last 2 years from posting date AND 2 years of relatable experience.

OR

Current Intern of the Metropolitan Council

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

• Ability to gather and analyze stakeholder requirements.

• Ability to design, develop, and maintain reports, data visualizations, dashboards, metrics, and analytical solutions using a variety of BI tools and technologies.

• Experience using databases, data stores, data lakes, data warehouses, and/or data marts for reporting and analytics.

• Programming language knowledge with at least one scripting language.

• Writing SQL queries and defining BI standards and best practices.

• BI tools installation, administration, maintenance, and support.

• Production and Non-production BI environment support and code pipelines.

• Experience managing BI performance, alerts, and user subscriptions.

• Being up to date on emerging technologies around reporting and analytics.

• Experience consulting with technology and business units.

• Experience developing BI solutions for the cloud.

• Experience supporting self-service reporting.

• Experience with the Council’s business processes and/or operations.

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

Union/Grade:AFSCME/Grade E

FLSA Status: Non-Exempt

Safety Sensitive: No

Work Environment:

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

Full Salary Range: $29.69 - $44.82 hourly / $61,755 - $93,226 annually

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 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 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.

Agency

Metropolitan Council

Address

390 Robert St. N.

St. Paul, Minnesota, 55101

Website

https://metrocouncil.org

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 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.

• Yes

• No

  02

  Select your level of completed education:

• Associate's Degree in computer science/engineering, information technology, or related field.

• Bachelor's Degree in in computer science/engineering, information technology, or related field

• Master's Degree in in computer science/engineering, information technology, or related field.

• None of the above.

  03

  Select your level of experience of relating experience in information technology:

• No experience

• Less than one (1) year

• One (1) year but less than two (2) years

• Two (2) years or more

  04

  Select which option best describes your eligibility to the Bridge Program:

• Graduated with a 4-year Degree within the last 2 years from posting date

• Graduated with a Master's Degree within the last 2 years from posting date

• Graduated with a 2-year degree within the last 2 years from posting date AND 2 years of relatable experience

• Current intern with the Metropolitan Council

• None of the above

  05

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

• Yes

• No

  06

  Have you previously interned with the Met Council?

• Yes

• No

  07

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

• Knowledge about the Council's business processes and/or operations.

• Supporting self-service reporting.

• Developing BI solutions for the cloud.

• Consulting with technology and business units.

• Being up to date on emerging technologies around reporting and analytics.

• Managing BI performance, alerts, and user subscriptions.

• Production and Non-production BI environment support and code pipelines.

• BI tools installation, administration, maintenance, and support.

• Writing SQL queries and defining BI standards and best practices.

• Programming language knowledge with at least one scripting language

• Using databases, data stores, data lakes, data warehouses, and/or data marts for reporting and analytics.

• Designing, developing, and maintaining reports, data visualizations, dashboards, metrics, and analytical solutions using a variety of BI tools and technologies

• Gathering and analyzing stakeholder requirements.

• None of the above

  08

  Describe your strengths and how you will best utilize them for this position.

  09

  Describe your knowledge/education/experience in designing, developing, and delivering reports, dashboards, and/or visualizations. If you do not have any experience, please indicate "N/A".

  10

  The Council values having a workplace that is as diverse as the people we serve. Describe your work experience as a professional in a diverse, multicultural, and inclusive environment. If you do not have any experience, please indicate "N/A".

  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