Bridge Fellow - Associate Developer

Full job description 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.


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:


The Bridge Fellow - The Bridge Fellow - Associate BI Developer is 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 Developer works 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 a long-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! 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 .

Agency
Metropolitan Council

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

Website 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: 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