Available for opportunities — Nampa, ID

Matthew
Collard

Business Intelligence Analyst

Results-driven analyst with 4+ years of experience in healthcare and financial services. I specialize in data quality, pipeline automation, and turning messy enterprise data into trusted, consistent solutions.

4+ Years Experience
100+ FTE Hours Automated / Month
Black Belt Certified
700+ Combat Missions Led

01 Areas of Expertise

Data Engineering

Python-driven pipeline development, automated validation, source-to-target mapping, ETL workflows, and SQL-based reconciliation across systems with differing primary keys.

  • Python
  • SQL
  • ETL
  • Data Quality

Business Analysis

Requirements elicitation, gap analysis, current/future-state process mapping, UAT coordination, and stakeholder sign-off for enterprise-level implementations.

  • Requirements Docs
  • UAT
  • Gap Analysis
  • Agile

Business Intelligence

Building dashboards and reports in Tableau and Power BI; advanced Excel automation (VBA, Power Query, Pivot Tables) to surface insights for decision-makers.

  • Tableau
  • Power BI
  • Excel / VBA
  • Reporting

Process Optimisation

Six Sigma Black Belt methodology applied to continuous improvement initiatives — root cause analysis, lean waste elimination, and capacity planning.

  • Six Sigma
  • Root Cause Analysis
  • Lean
  • Capacity Planning

02 Professional Experience

Nov 2024 — Present Nampa, ID

Business Analyst

ICCU

Led end-to-end evaluation and implementation planning for the NICE/Actimize Xceed fraud prevention platform, producing business requirements that enabled real-time fraud detection across ACH, wires, checks, and RTP payment channels. Defined source-to-target data mapping and SFTP ingestion specs for auditable cross-system data transfer.

  • Elicited and documented functional & technical requirements from multiple frontline business units
  • Conducted gap analysis and process mapping for STIP reconciliation workflows
  • Identified automation opportunities reducing manual processing time
May 2022 — Nov 2024 Meridian, ID

Business Analyst

Blue Cross of Idaho

Built automated data ingestion and reporting pipelines in Python to standardise non-uniform membership data, enforce quality rules, and surface discrepancies across 76 sub-groups — eliminating 100+ hours/month of FTE manual effort.

  • Automated validation pipeline for 76-sub-group enrollment dataset — eliminated 100+ FTE hours/month
  • SQL monitoring of enrollment workflows across systems with differing primary keys
  • Led team of 6 analysts in organisation-wide capacity analysis delivering year-long improvement roadmap
  • Reduced full-time processing hours by 2% monthly through targeted workflow improvements
Apr 2021 — Mar 2022 Nampa, ID

Area Manager

Amazon Fulfillment Center

Coordinated shift planning for daily production goals exceeding 300,000 units. Applied advanced Excel analysis of associate production data to develop coaching strategies for 80+ hourly associates.

  • Set building and regional shift records of 475,000 units via cross-department labor coordination
  • Increased process headcount by 80% through strategic staffing
Jul 2006 — May 2015 Joint Base Lewis-McChord, WA

Assistant Operations NCO

United States Army

Nine years of progressively responsible leadership — supervising soldiers, managing high-value equipment, and leading small teams through 700+ combat missions. Conducted high-level command briefings and collaborated on long-term unit strategy.

  • Led 700+ combat missions across multiple deployments
  • Earned Drivers Badge for sustained accident-free record

03 Technical Competencies

Languages

Python SQL VBA

BI & Visualisation

Tableau Power BI Advanced Excel Power Query

Cloud & Platforms

AWS Fundamentals SFTP / ETL Jira GIS

Methodologies

Lean Six Sigma Agile / Scrum MDM 834 EDI

Certifications

Six Sigma Black Belt CompTIA Data+ AWS Fundamentals MOS Excel 2016

04 Education

2020

B.S. Business — Operations Management

University of Idaho, Moscow ID

2019

A.A. Business

College of Western Idaho, Nampa ID

Selected Work

See What I've Built

A collection of data projects, automation pipelines, and analytics work.

Browse Projects →