Data Analyst Power Bi

Cole B. Hamilton ****.*.********@*****.***

Data Analyst www.linkedin.com/in/hamiltoncole/ Operations & Workforce Analytics Leader 910-***-****

Analytical and strategic data leader with over 20 years of experience using workforce and operations data to reduce risk, improve efficiency, and support executive decision-making. Proven ability to lead cross-functional analytics teams, develop intake and reporting processes, and deliver insights that optimize performance across business units. Deep expertise in SQL, Excel, and Power BI for KPI development, data visualization, and organizational storytelling. Skilled in stakeholder alignment, agile collaboration, and translating complex questions into actionable outcomes.

Skills

Operations Analytics & Risk Reduction – Building frameworks that answer high-level business questions and mitigate organizational exposure

Intake Process Development – Designing data intake pipelines for project tracking and decision support

Data Reporting & Visualization – Power BI, Excel (Power Query, Pivot Tables), SQL, HRIS platforms

Workforce & Performance Analytics – Attrition modeling, engagement tracking, productivity metrics

Team Leadership & Coaching – Mentoring analysts and supporting professional growth across analytics functions

Stakeholder Collaboration – Aligning cross-department efforts with analytics roadmaps and strategic goals

Agile & Cross-Functional Environments – Operating in fast-paced, data-focused teams to support enterprise priorities

Professional Experience

Senior Program Manager Talent & Workforce Strategy Fort Knox, KY Oct 2004 – Jul 2025

United States Army Recruiting Command

Over two decades of leadership delivering enterprise-scale workforce analytics, strategic planning, and program execution across multiple brigades. Led transformation efforts that impacted over 50,000 personnel accessions, centralizing project tracking, improving hiring efficiency, and delivering insights that shaped national recruiting strategy. Known for bridging data and operations to drive performance, reduce risk, and align cross-functional teams in high-impact environments.

Built and managed enterprise-wide analytics workflows to centralize project intake, improve workforce planning, and align reporting across HR, operations, and leadership teams

Developed executive dashboards and predictive models using Power BI, Excel, and SQL to track KPIs, performance outcomes, cost trends, and risk indicators

Delivered high-level briefings and strategic insights to senior stakeholders, influencing program decisions, workforce adjustments, and retention strategies

Implemented Lean Six Sigma process improvements that improved operational efficiency by 130% and eliminated critical workflow bottlenecks

Led multi-region recruitment operations, contributing to over 50,000 accessions by optimizing resource allocation, streamlining hiring pipelines, and forecasting personnel gaps

Mentored cross-functional analytics and recruiting teams, building capacity in data storytelling, dashboard development, and performance tracking

Fostered a culture of data-driven decision-making, integrating analytics into project management, HR policy, and strategic planning

Key Tools & Technologies: Power BI, SQL, Excel (Power Query & PivotTables), HRIS platforms, JIRA, Asana, Tableau

Key Skills: Workforce Analytics Intake Workflow Design Strategic Planning Project Reporting Performance Optimization Risk Mitigation Cross-Functional Leadership

Project Management Instructor Remote August 2023 - Present

Cornell University

Develop and lead HR and project management courses, specializing in talent strategy, workforce development, and leadership best practices. Coach professionals on implementing HR analytics, program management methodologies, and change management frameworks.

Designed HR-focused curriculum integrating workforce planning and organizational development principles.

Mentored HR professionals, improving competency in talent analytics and workforce optimization.

Provided industry insights, aligning educational content with current market trends and best practices.

Education

Doctor of Philosophy, Human Resource Management

●Northcentral University, La Jolla, CA

Master of Arts, Leadership and Management

●Liberty University, Lynchburg, VA

Master of Business Administration in Finance

●Post University, Waterbury, CT

Bachelor of Business Administration in Management

●Post University, Waterbury, CT

Associate of Science in Computer Information Systems

●Trident Technical College, Charleston, SC

Certifications

SHRM-SCP (Senior Certified Professional) (2022 – 2028)

Society for Human Resource Management ID# 182267

Project Management Professional (PMP) (2022 – 2028)

Project Management Institute PMP# 3357894

Lean Six Sigma Master Black Belt (2021)

Six Sigma Global Institute ID# 39527269

Microsoft Power Bi Data Analyst (PL-300) (2021)

oMicrosoft ID# H990-2060

Microsoft Certified Trainer (MCT) (2021)

oMicrosoft ID# H990-2060

Project+ (2022)

oCompTIA ID# COMP001022108805

Security+ (2022 – 2028)

oCompTIA ID# COMP001022108805

Security Clearance- Secret (2009 – 2029)

oDepartment of Defense

Contact this candidate