Business Process & Data Analyst

DES MOINES AREA REGIONAL TRANSIT AUTHORITY; Des Moines (IA); On-site; USD 65,000 - 85,000; Full time

Job summary

DES MOINES AREA REGIONAL TRANSIT AUTHORITY (DART) is seeking a Business Process & Data Analyst for a 12-month temporary full-time contract onsite in Des Moines, IA. You will connect enterprise process mapping with practical data analysis and help teams document cross-department workflows.

You’ll run discovery workshops, maintain SOP inventories, improve reporting workflows using Excel, Power BI, SQL, Python, Power Automate, and ensure data quality for operational reporting.

Qualifications

• Proven experience in business analysis and process mapping.
• Ability to lead interviews/workshops and translate ambiguity into documentation.
• Strong Excel skills and data-oriented thinking.
• Experience with Power BI, SQL, Python, and automation/visualization tools.

Responsibilities

• Run discovery workshops to document current-state processes and cross-department workflows.
• Document responsibilities, system touchpoints, data flows, and downstream consumers.
• Maintain SOP inventories and a SharePoint documentation repository.
• Improve recurring reporting workflows and dashboards to support operational reporting.

Skills

Business analysis

Process mapping

Data documentation

Stakeholder facilitation

Education

Bachelor's degree or equivalent training

Tools

Excel

Power BI

SQL

Python

Power Automate

Visio

Lucidchart

BPMN

SharePoint

Job description

DES MOINES AREA REGIONAL TRANSIT AUTHORITY (DART) is seeking a Business Process & Data Analyst to support a 12-month temporary full-time contract onsite in Des Moines, IA. In this role, you will connect enterprise process mapping with practical data analysis, helping teams document cross-department workflows and strengthen the accuracy and reliability of operational reporting.

What you’ll do

• Run discovery workshops with subject-matter experts to produce current-state process maps and cross-department workflow documentation.
• Document responsibilities and exceptions, including system touchpoints, data flows, manual transfers, and downstream consumers.
• Inventory and consolidate existing SOPs, flagging duplicates, gaps, outdated references, and unclear ownership.
• Maintain process trackers, issue logs, and a structured SharePoint documentation repository.
• Deliver complete, validated documentation packages with clear milestone updates.
• Investigate data anomalies and inconsistencies, and define validation checks and data definitions.
• Clean, reconcile, and document high-priority datasets used for operational and performance reporting.
• Improve recurring reporting workflows using tools aligned to your strengths: Excel, Power Automate, SQL, or Python.
• Enhance reporting datasets and Power BI dashboards, ensuring KPI measures are understood and consistent.
• Support operational reporting requirements (APC, farebox, GPS, etc.) and create sustainable handoff workflows.

What you’ll need

• Proven experience in business analysis, process mapping, operational documentation, and hands-on data work.
• Ability to lead interviews and workshops, then translate ambiguity into clear documentation.
• Strong Excel skills, analytic thinking, attention to detail, and clear writing.
• Comfort explaining technical or data topics to nontechnical users.
• Experience with Power BI, SQL, Python, Power Automate, and/or process-mapping tools such as Visio, Lucidchart, or BPMN.
• Familiarity with SharePoint document management, SOP inventories, data-flow documentation, and/or KPI reporting.
• Background in public transit, government, regulated environments, or complex service organizations.
• Relevant degree or equivalent training and applied experience.

Tools and technologies

• Excel, Power Automate, SQL, Python, Power BI, Visio, Lucidchart, BPMN, SharePoint

How success is measured

• Validated current-state maps and documented data flows for priority workstreams.
• A searchable SharePoint inventory linking processes, SOPs, identified gaps, and owners.
• Clear handoff materials that allow departments to maintain and improve documentation after the contract ends.
• A prioritized register of data-quality issues with defined checks and status.
• Reporting or automation improvements that reduce manual work or improve accuracy.

Why this role

This is a high-impact, project-focused opportunity with visibility across DART departments. You will have the chance to shape documentation and data practices that can continue to support the organization beyond the contract term, while working in a structured, collaborative environment where clarity matters.