New

Business Intelligence Developer 3

Metropolitan Council
$85,987.20 - $139,526.40 Annually
medical insurance, dental insurance, life insurance, vision insurance, retirement plan, pension
United States, Minnesota, Saint Paul
390 Robert Street North (Show on map)
Dec 27, 2024
WHO WE ARE 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. 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: The Business Intelligence Developer 3 is a senior-level role responsible for designing, developing, and maintaining business intelligence (BI) reporting and data analysis solutions. They collaborate with technology and business units across multiple divisions within the Metropolitan Council: Regional Administration, Metro Transit, Metropolitan Transportation Services, Environmental Services, and Community Development. The Business Intelligence Developer creates a variety of solutions including paginated reports, dashboards, interactive visualizations, metrics, dataflows, semantic models, and/or predictive models (AI/ML). They 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 administer, monitor, and maintain reporting solutions, ensuring their security, performance, and availability. They also administer BI tools and may identify and resolve data quality issues. The Business Intelligence Developer 3 works on the highest level of complex tasks within the job function. This role requires a high degree of expertise in reporting technologies, databases (DBs), data modeling, structured and unstructured data, and strong programming skills. They must be able to work on small to large initiatives and develop BI and analytical strategies. They often mentor others and may act in a technical lead role. They generally work independently and are occasionally directed in a few aspects of the work. They are aware of and comply with data governance and data security requirements. This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin. What you would do in this job Design and develop reports, semantic models, dataflows, dashboards, scorecards, and other reporting artifacts, using Power BI and other modern business intelligence tools Maintain and enhance existing BI solutions and architecture Collaborate with stakeholders to understand reporting requirements and business process outcomes Consultations and training to empower self-service users Assist junior developers when they encounter complex requirements or tasks Stay updated with the latest trends and advancements in business intelligence and data analytics Code and optimize SQL queries in Microsoft T-SQL, Sybase SQL, and/or Oracle PL-SQL Other job-related duties as assigned What education and experience are required for this job (minimum qualifications) Any of the following combinations of education (in computer science, information systems, social sciences, data science, mathematics, statistics, or a related field) and experience gathering business user requirements, querying data with SQL (T-SQL or PL-SQL) programming language, analyzing data with DAX and/or Power Query (M) language, and designing data visualizations using modern business intelligence platforms: Master's degree and two years of experience Bachelor's degree and four years of experience Associate degree and six years of experience High school diploma/GED and eight years of experience What additional skills and experience would be helpful in this job (desired qualifications): Experience developing BI solutions for the cloud Experience developing reports from start to finish, coding SQL, defining tables and relationships, developing metrics and quantitative measures, designing visualizations and report pages, and performing data analysis Statistical analysis experience for business administration, econometrics, and/or public administration Experience with APIs and other web-based data services Experience with BI tools installation, administration, and maintenance Python and/or R programming experience Experience working and collaborating in diverse, multicultural, and inclusive environments What knowledge, skills, and abilities you should have within the first six months on the job: Ability to understand data models and relationships, business processes, and functions. Ability to work independently and with others to conceptualize and formulate data visualizations through the application of different charts and graphics to represent ideas. Ability to communicate clearly and effectively to diverse audiences of technical and non-technical personnel orally and in writing. Ability to manage multiple priorities and assess and adjust quickly to changing priorities. Ability to establish and maintain effective customer focused working relationships with managers, customers, vendors, consultants and employees. Ability to prepare clear, concise and accurate documentation, reports and other written materials. Excellent analytical, research, troubleshooting, communication and mentoring skills. 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: AFSCME Grade: H FLSA Status: Exempt Safety Sensitive: No What your work environment would be: You would perform your work in a standard office setting. Work may sometimes require travel between your primary work site and 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 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 .