BI & Reports Developer - ITS3

Minnesota Direct Care and Treatment; Saint-Paul; On-site; CAD 98,000 - 162,000; Full time

Job summary

Minnesota IT Services (MNIT) and the MnDOT Office of Financial Management seek a BI & Reports Developer to design, develop, and maintain user-friendly financial reports and data extracts using Crystal Reports, Power BI, SQL, and related tools.

You will gather requirements, validate data, support ad hoc reporting, and collaborate with stakeholders to enable data-driven decisions while ensuring data integrity and compliance.

Qualifications

• Three years IT experience developing financial reports and dashboards.
• Design and develop Crystal Reports and Power BI reports/dashboards with UX/UI focus.
• Validating and reconciling data for report accuracy.
• Eliciting and documenting business and technical requirements.
• Managing multiple projects while supporting existing applications.
• Clear communication and customer-focused problem solving.

Responsibilities

• Design and maintain financial reports and data extracts using Crystal Reports and Power BI.
• Develop data structures, document requirements, and ensure data integrity.
• Troubleshoot and support financial applications and SWIFT/FHWA subsystems.
• Collaborate with stakeholders to enable data-driven decision making.
• Provide ad hoc reporting and maintain system documentation.

Skills

Crystal Reports

Power BI

UX UI

Data validation

Requirements gathering

Project management

Communication

Customer focus

Tools

SWIFT

SEMA4 PeopleSoft

Toad for Oracle

Job description

Working Title: BI & Reports Developer

• Job ID: 95336
• Location: St. Paul
• Full/Part Time: Full-Time
• Regular/Temporary: Unlimited
• Who May Apply: Open to all qualified job seekers
• Date Posted: 09/04/2026
• Closing Date: 09/10/2026
• Hiring Agency/Seniority Unit: Minnesota IT Services
• Division/Unit: Department of Transportation (DOT)
• Work Shift/Work Hours: Day Shift
• Days of Work: Monday - Friday
• Travel Required: No
• Salary Range: $33.96 - $55.83 / hourly; $70,908 - $116,573 / annually
• Job Class Option: Application
• Classified Status: Classified
• Bargaining Unit/Union: 214 - MN Assoc of Professional Employees (MAPE)
• FLSA Status: Nonexempt
• Designated in Connect 700 Program for Applicants with Disabilities: Yes

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

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

Minimum Qualifications

To qualify, candidates must clearly show all of the following qualifications in their resume. 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.

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.

Additional Requirements

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

Contact

If you have questions about this position, contact Human Resources at [e-mail].

Veterans

To be considered for any Veteran's Status, you MUST indicate this on your application.

RECENTLY SEPARATED VETERANS (RSV): Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview. You must:

• Meet all Minimum Qualifications identified in this posting.
• Meet all of the RSV criteria.
• Submit a copy of your DD-214 form by the closing date to: [e-mail]

CERTAIN DISABLED VETERANS: Effective August 1, 2012, legislation provides state agencies with the option to appoint certain disabled veterans on a noncompetitive basis if you:

• Meet service requirements and have a verified service-connected disability rating of at least 30%.
• Provide qualifying documentation verifying the disability.
• Meet all Minimum Qualifications identified in this posting.
• You must submit all documentation by the closing date to: [e-mail]

Current State Employees

Bidders: This vacancy is open for bids and all qualified applicants simultaneously. This vacancy will be filled in accordance with applicable union contract provisions. Current employees of Minnesota IT Services who are currently in an Information Technology Specialist 3/Application position and who are eligible to bid and apply within the seven (7) day bidding period will be considered prior to filling the position via other means.

Current State Employees: Please note that employment provisions (including but not limited to seniority and leave accrual) vary among the three branches of Minnesota State government. When considering a job with another branch of state government, you are highly encouraged to explore these differences. For assistance, please direct questions to your current or anticipated Human Resources office.

About Minnesota IT Services

Minnesota IT Services is the information technology agency for the State of Minnesota. MNIT partners with agencies, boards, councils, and commissions to deliver secure, reliable technology solutions as we set IT strategy, direction, policies, and standards statewide. Work for MNIT and be part of a nation-leading IT organization that helps to create an innovative government that works for everyone. Our culture promotes collaboration, demands agility, and encourages us to embrace change. Be a part of something bigger than yourself, something to be inspired by; come to work for MNIT.

Working together to improve the state we love.

• A sense of purpose in their work
• Connection with their coworkers and communities
• Opportunities for personal and professional growth

Benefits

As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your Benefits May Include

• Paid vacation and sick leave
• 12 paid holidays each year
• Low-cost medical, dental, vision, and prescription drug plans
  • Fertility care, including IVF
  • Diabetes care
  • Dental and orthodontic care for adults and children
• 6 weeks paid leave for parents of newborn or newly adopted children
• Pension plan that provides income when you retire (after working at least three years)
• Employer paid life insurance to provide support for your family in the event of death
• Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
• Tax-free expense accounts for health, dental, and dependent care
• Resources that provide support and promote physical, emotional, social, and financial well-being

Support To Help You Reach Your Career Goals

• Training, classes, and professional development
• Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)

Employee Assistance Program (EAP) For Work/life Support

• A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.

EQUAL OPPORTUNITY EMPLOYERS

Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourage persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans.

All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.

Applicants With Disabilities

Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email [e-mail] and let us know the support you need.