BI & Reports Developer - ITS3

As the BI & Reports Developer with Minnesota IT Services (MNIT) and the Office of Financial Management at the Minnesota Department of Transportation (DOT), you will provide critical report development, data analysis, programming expertise, and technical support that ensure the accuracy, reliability, and usability of the agency’s financial information systems. In this role, you will design, develop, and maintain user-friendly financial reports and data extracts using tools such as Crystal Reports, Power BI, SQL, and other prescribed technologies to support data-driven decision-making across MnDOT. You will also enhance, troubleshoot, and support financial applications and sub-systems, including those connected to SWIFT and FHWA systems, ensuring they operate efficiently and align with evolving business needs. Your work will involve gathering and documenting requirements, building and validating data structures, maintaining system documentation, and supporting ad hoc reporting for a wide variety of stakeholders. By ensuring data integrity, developing high-quality reporting solutions, and contributing to ongoing improvements in data management practices, you will play a key role in supporting accurate financial analysis, compliance, and operational effectiveness for the agency

This position requires an employee to work onsite at 395 John Ireland Blvd , Minnesota at least 50% [or more or less if space limitations remain] of the time, with limited telework available. Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) eligibility depends on residence:

• Candidates living in Minnesota or within 50 miles of the worksite in a bordering state (Iowa, North Dakota, South Dakota, and Wisconsin) may telework up to 50%.
• Minnesota residents living more than 50 miles from the worksite may be eligible to telework more than 50%.
• Candidates living 50 miles or more from the worksite in a bordering state may work onsite 100% or may be telework eligible if relocating within 50 miles., It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:
• SEMA4 Records Check (applies to current and past state employees only)
• Criminal History Check
• Reference Check
• Social Security and Address Verification
• Education Verification
• Other legally required checks

Minnesota IT Services does not participate in E-Verify. Minnesota IT Services will not sponsor applicant for work visas, including F-1 STEM OPT extensions. Minnesota IT Services is not able to complete Form I-983 or any other form that requires that the employer certifying to using E-Verify. All applicants must be legally authorized to work in the United States.

To qualify, candidates must clearly show all of the following qualifications in their resume. Resume tips available here (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) :

This position requires a minimum of three (3) years of IT related experience in the development of financial reports and dashboards., * Designing and developing user-friendly Crystal Reports and Power BI reports/dashboards, leveraging data gateways and strong UX/UI skills while following established methodologies.

• Validating and reconciling data to ensure the accuracy and reliability of reports and dashboards.
• Writing clear and concise explanations of report content, including how information was selected and summarized.
• Eliciting and documenting business and technical requirements.
• Managing multiple projects simultaneously while also providing support for existing applications.
• Demonstrated ability to communicate clearly and effectively in a manner that facilitates mutual understanding.
• Customer-focused approach grounded in active listening, empathy, and solution-oriented problem-solving to deliver positive user experiences.

Education in Information Technology (IT) or an IT related field may substitute for experience as follows: a master’s degree for eighteen (18) months of experience; a bachelor’s degree for one (1) year; and an associate’s degree for six (6) months .

Strongly Preferred Qualifications

• Background working with financial systems, data, and business logic, including platforms such as SWIFT and SEMA4PeopleSoft.
• Knowledge of the State of Minnesota budgeting process and knowledge of the legislative statues on finance and budget.

Preferred Qualifications

• Knowledge of the State of Minnesota budgeting process and knowledge of the legislative statues on finance and budget.
• Knowledge of FHWA billing rules, processes and regulations.
• Experience with Toad for Oracle.
• Experience applying Web accessibility standards and best practices, including the State of Minnesota technology accessibility standard, as well as experience with automated accessibility testing tools.
• Ability to communicate highly technical issues to a non-technical audience.

• Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes

The work you’ll do is more than just a job.

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.

Join the 2,800+ professionals of Minnesota IT Services (https://mn.gov/mnit/about-mnit/careers/) (MNIT) who connect Minnesotans to services that will improve their lives in government IT. This position serves our partners at the Minnesota Department of Transportation (MnDOT). MNIT MnDOT supports an agency with technology integrated into all areas of business. From business intelligence and solutions for critical transportation infrastructure to planning and operating a safe, efficient, and reliable multimodal transportation system, the team connects people and markets across Minnesota.