What are the responsibilities and job description for the Temporary Business Process and Data Analyst position at DES MOINES AREA REGIONAL TRANSIT AUTHORITY?
Business Process & Data Analyst (12-Month Temporary FT Role)
Make an impact in a high-visibility, cross-department role.
DART is seeking a highly skilled Business Process & Data Analyst for a one-year contract who can blend enterprise process mapping with hands-on data analysis. This role is perfect for someone who enjoys tackling operational complexity, clarifying workflows, improving data quality, and supporting teams through structured, meaningful change.
What You’ll DoEnterprise
Process Mapping & Documentation (Approx. 60%)
• Lead discovery workshops with subject-matter experts to build current-state process maps and cross-department workflow documentation.
• Capture responsibilities, exceptions, system touchpoints, data flows, manual transfers, and downstream consumers.
• Inventory and consolidate existing SOPs; identify duplicates, gaps, outdated references, and unclear ownership.
• Maintain process trackers, issue logs, and a well-organized SharePoint documentation repository.
• Deliver complete, validated documentation packages and provide clear milestone updates.Data Quality, Reporting & Automation (Approx. 40%)
• Investigate data anomalies and inconsistencies; define validation checks and data definitions.
• Clean, reconcile and document high-priority datasets used for operational and performance reporting.
• Improve recurring reporting workflows using Excel, Power Automate, SQL, or Python (based on your strengths).
• Enhance reporting datasets and Power BI dashboards; ensure KPI measures are understood and consistent.
• Support operational reporting needs (APC, farebox, GPS, etc.) and hand off sustainable workflows.
• Capture responsibilities, exceptions, system touchpoints, data flows, manual transfers, and downstream consumers.
• Inventory and consolidate existing SOPs; identify duplicates, gaps, outdated references, and unclear ownership.
• Maintain process trackers, issue logs, and a well-organized SharePoint documentation repository.
• Deliver complete, validated documentation packages and provide clear milestone updates.Data Quality, Reporting & Automation (Approx. 40%)
• Investigate data anomalies and inconsistencies; define validation checks and data definitions.
• Clean, reconcile and document high-priority datasets used for operational and performance reporting.
• Improve recurring reporting workflows using Excel, Power Automate, SQL, or Python (based on your strengths).
• Enhance reporting datasets and Power BI dashboards; ensure KPI measures are understood and consistent.
• Support operational reporting needs (APC, farebox, GPS, etc.) and hand off sustainable workflows.
Success Looks LikeProcess Mapping Outcomes
• 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 enabling departments to maintain and improve documentation after the contract ends.Data Analyst Outcomes
• A prioritized register of data-quality issues with defined checks and status.
• Reporting or automation improvements that measurably reduce manual work or improve accuracy.
• 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 enabling departments to maintain and improve documentation after the contract ends.Data Analyst Outcomes
• A prioritized register of data-quality issues with defined checks and status.
• Reporting or automation improvements that measurably reduce manual work or improve accuracy.
What You BringRequired / Strongly Preferred
• Proven experience in business analysis, process mapping, operational documentation, and hands-on data work.
• Ability to lead interviews and workshops and translate ambiguity into clear documentation.
• Strong Excel skills, analytic thinking, attention to detail, and clear writing.
• Comfortable explaining technical/data topics to nontechnical users.Preferred / Differentiating
• Experience with Power BI, SQL, Python, Power Automate, or process-mapping tools (Visio, Lucidchart, BPMN).
• SharePoint document management, SOP inventories, data-flow documentation, or KPI reporting.
• Background in public transit, government, regulated environments, or complex service organizations.
• Relevant degree or equivalent training and applied experience.
• Proven experience in business analysis, process mapping, operational documentation, and hands-on data work.
• Ability to lead interviews and workshops and translate ambiguity into clear documentation.
• Strong Excel skills, analytic thinking, attention to detail, and clear writing.
• Comfortable explaining technical/data topics to nontechnical users.Preferred / Differentiating
• Experience with Power BI, SQL, Python, Power Automate, or process-mapping tools (Visio, Lucidchart, BPMN).
• SharePoint document management, SOP inventories, data-flow documentation, or KPI reporting.
• Background in public transit, government, regulated environments, or complex service organizations.
• Relevant degree or equivalent training and applied experience.
Why This Role?
• High-impact, project-focused work with visibility across DART departments.
• Opportunity to shape documentation and data practices that will serve the organization long after the contract.
• Ideal for a skilled analyst who enjoys structure, collaboration, and bringing clarity to complex environments.
• Opportunity to shape documentation and data practices that will serve the organization long after the contract.
• Ideal for a skilled analyst who enjoys structure, collaboration, and bringing clarity to complex environments.