Data & Analytics Professional

Turning Data Into
Tools That Help
People

Now seeking mission-driven work

I've spent 15+ years building analytics systems that help people do their jobs better — dashboards used by thousands, automation that eliminated hours of manual work, and metrics that gave field teams real clarity on their performance.

I'm now looking to take that same work somewhere the mission itself matters to me. Whether that's mental health, clean energy, environmental advocacy, or social impact — I want to build tools that help people, not just optimize revenue.

If your organization is drowning in data it can't yet use, that's exactly the problem I've spent my career solving.

5K+
Field employees served daily
10K+
Weekly dashboard interactions
What I'm Looking For

"I want to apply senior-level analytics craft toward organizations where the mission drives me as much as the work does."

Mental Health Clean Energy Sustainability Nonprofits Social Impact

What I Bring
Technical Expertise
📊
Tableau
  • LOD Calculations
  • Row-Level Security
  • Dashboard Optimization
  • Data Storytelling
🗄️
SQL
  • Complex Query Design
  • Data Modeling
  • Performance Tuning
  • ETL Processes
🐍
Python
  • Pandas / NumPy
  • Data Automation
  • Scripting & APIs
  • pyodbc / SQLAlchemy

Career History
Professional Experience
2020 – Present
Comcast
Plymouth, MI (Remote)
Engineering Operations Analyst III – Enterprise Business Intelligence
  • Built Tableau dashboards with LOD calculations and Row-Level Security, supporting over 5,000 users with more than 10,000 weekly interactions
  • Transformed manual spreadsheet reporting into automated, database-connected dashboards — giving field teams real-time clarity on their own performance
  • Automated ad hoc reporting through Python scripting (Pandas, NumPy, pyodbc, SQLAlchemy), eliminating hours of manual weekly work
  • Managed user data collection pipelines via MS Forms, MS Power Automate, and Python
  • Supported senior leadership with scripted data analysis for company-wide resource planning
  • Led cross-functional team to develop new metrics, managing rollout to over 400 employees
2007 – 2020
Comcast
Sterling Heights, MI
Technical Operations Supervisor – Commercial Services
  • Led a specialized field team of 10–15 employees — consistently ranked in the top 5% regionally on core performance metrics
  • Managed onboarding, performance reviews, one-on-ones, and in-field coaching
  • Built and maintained distributable accountability reports used across multiple technical operations locations
  • Oversaw region reporting for tool/ladder budgets, inspection compliance, and payroll accuracy
2005 – 2007
Blue Sphere, Inc.
Ada, MI
Web Programmer / System Administrator
  • Managed server infrastructure upgrade across 4 development servers (file, web, email, virtual)
  • Supervised customer relations for designated accounts to drive satisfaction and retention
2003 – 2005
Harris Corp / Encoda Systems
Grand Rapids, MI
Software Support Engineer
  • Oversaw launch of new revenue unit for a proprietary web portal reporting product
  • Led onsite customer training across the country — 50% travel
Selected Work
Featured Projects
01
Engineering Operations Dashboard

Built a suite of Tableau dashboards that gave 5,000+ field employees real-time visibility into their own performance — replacing a patchwork of manual spreadsheets with tools people actually relied on. At peak usage, these dashboards were being accessed over 10,000 times per week, becoming a daily part of how teams understood and improved their work.

Tableau LOD Calculations Row-Level Security
10K+
Weekly interactions
5K+
Active users
02
Data Automation Pipeline

Identified reporting processes that were consuming hours of human time every week and automated them end-to-end using Python. The result was an 80% reduction in manual effort — time that teams got back to focus on actual work rather than data wrangling. Fresher data also meant faster, better decisions at every level.

Python Pandas SQLAlchemy pyodbc
80%
Reduction in manual work
03
Cross-Functional Metric Development

Led a cross-functional team to design performance metrics from scratch — then managed the rollout to over 400 employees. The goal wasn't just better numbers on a report; it was giving people a fair, transparent way to understand how they were being measured and where they could grow. Metric adoption hit 92%, which means people trusted what they were seeing.

Project Management Data Analysis Stakeholder Engagement
92%
Metric adoption rate
400+
Employees impacted
04
Technical Operations Reporting

Designed reporting tools used across multiple field operations locations to track compliance and resource allocation — the kind of unglamorous infrastructure work that keeps teams organized and accountable. 95%+ compliance scores across tool audits, inspections, and payroll accuracy weren't just metrics; they reflected teams that had clear, reliable information to work from.

Excel VBA Data Visualization
95%+
Compliance scores
100%
Payroll accuracy
Academic Background
Education
Bachelor of Business Administration
Grand Valley State University
Management · Emphasis in Organizational Information Systems · December 2002
Open to Pro-Bono Work

I'm genuinely open to taking on pro-bono analytics projects for mission-aligned organizations — nonprofits, advocacy groups, or early-stage social ventures that need help making sense of their data.


Let's Talk
Get in Touch

I'm actively exploring opportunities with organizations working in mental health, clean energy, sustainability, and social impact. If your mission resonates, I'd love to have a conversation about how I might contribute — whether that's a full-time role or a short-term project to start.

📍
Location
Saint Clair Shores, MI
✉️
Email
john@johnroyston.com
Please enter your name
Please enter a valid email
Please enter a subject
Please enter a message
Message sent successfully!