Josh Kester
West Des Moines
Summary
Business intelligence professional with strong track record in delivering data-driven insights to support business strategies. Proven ability to design and implement data models and reporting solutions that align with organizational goals. Known for collaborative approach and adaptability, with proficiency in SQL.
Overview
9
9
years of professional experience
Work History
Business Intelligence Developer
Standard Heating and Air Conditioning
09.2022 - 05.2025
- Developed and maintained interactive web-based dashboards using C# and SQL Server to support real-time decision-making across operations and finance.
- Built complex SQL queries for data extraction, transformation, and reporting across multiple departments.
- Collaborated closely with stakeholders to identify key metrics, streamline reporting, and ensure data integrity.
- Built advanced Excel reports to administrate 12,000+ members.
- Provided ad-hoc reports and insights to executives, enabling faster responses to business changes.
Smart Club Administrator
Standard Heating and Air Conditioning
11.2018 - 09.2022
- Built advanced Excel-based tools to manage member data, process payments, and track plan details.
- Automated membership workflows, improving efficiency and reducing manual errors.
- Managed customer communication, including renewal reminders and personalized outreach.
- Ensured membership plans aligned with individual customer needs, improving satisfaction and retention.
- Processed and managed payments for 12,000 members.
- Automated processes using Excel and Access queries
- Provided month-end reporting to accounting
- Served as the go-to Excel expert for all departments
Assistant Business Manager
Coaching Actuaries
09.2016 - 07.2017
- Facilitated customer success through support services.
- Provided strengths-based development through individualized coaching sessions.
- Improved business systems and processes to increase efficiency and effectiveness.
- Assisted other areas of the business as needed.
Education
Master of Science - Industrial And Organizational Psychology
Capella University
Minneapolis, MN04-2022
Bachelor of Arts - Business Administration
Northwestern College
Orange City05-2016
Skills
- SQL programming
- C#
- Data dashboard design
- Performance metrics
- SQL Server Management Studio
- Visual Studio
- MS Excel, Access, PowerPoint, Word
- Power BI (Limited)
Timeline
Business Intelligence Developer
Standard Heating and Air Conditioning
09.2022 - 05.2025
Smart Club Administrator
Standard Heating and Air Conditioning
11.2018 - 09.2022
Assistant Business Manager
Coaching Actuaries
09.2016 - 07.2017
Master of Science - Industrial And Organizational Psychology
Capella University
Bachelor of Arts - Business Administration
Northwestern College
Similar Profiles
Bradley (Brad) LinkBradley (Brad) Link
Comfort Advisor at Northern One Hour Heating and Air ConditioningComfort Advisor at Northern One Hour Heating and Air Conditioning
Adam MarthalerAdam Marthaler
Assistant Installation Manager at Standard Heating & Air ConditioningAssistant Installation Manager at Standard Heating & Air Conditioning
Avonpreet SinghAvonpreet Singh
HVAC Installer at Perfect Air Heating & Air ConditioningHVAC Installer at Perfect Air Heating & Air Conditioning
Brent BartschtBrent Bartscht
26' Box Truck Delivery Driver at ( Team ) Kline Electric26' Box Truck Delivery Driver at ( Team ) Kline Electric
Cain HansenCain Hansen
Security Supervisor at Allied Universal Security ServicesSecurity Supervisor at Allied Universal Security Services