Josh Fernandez

Senior Business Intelligence Analyst

Las Vegas, NV

7+ Years Experience
20+ Dashboards Built
5M+ Rows Processed
98% Completion Target

About Me

Josh Fernandez

I'm a Senior Business Intelligence Analyst with 7+ years of experience transforming complex data into actionable insights across healthcare, construction, and utility industries.


My expertise lies in developing sophisticated Power BI dashboards, implementing predictive models with Python, and creating automated reporting solutions that drive strategic business decisions.


I've successfully delivered solutions processing millions of data rows, improved operational efficiency by 50%+ through data-driven insights, and consistently exceeded 98% completion targets across multiple enterprise projects.

Power BI SQL Python DAX Snowflake Azure

Technical Skills

Data & Analytics

  • SQL & Database Management
  • Data Modeling & Warehousing
  • ETL/ELT Processes
  • Statistical Analysis
  • Predictive Modeling
  • Data Visualization

Business Intelligence

  • Power BI Development
  • DAX Measures & Calculations
  • Dashboard Design & UX
  • Report Automation
  • Performance Optimization
  • Self-Service Analytics

Programming

  • Python for Data Analysis
  • Prophet Forecasting
  • Jupyter Notebooks
  • PowerQuery M Language
  • Git Version Control
  • AI Prompt Engineering

Platforms & Tools

  • Microsoft Power Platform
  • Snowflake Data Cloud
  • Azure Data Services
  • SharePoint Integration
  • SSMS & Database Tools
  • Anaconda Distribution

Professional Experience

Apr 2024 - Present

Senior Business Intelligence Analyst

AMN Healthcare, Inc. | San Diego, CA

Leading BI initiatives for healthcare staffing solutions with focus on client reporting and predictive analytics.

  • Delivered quarterly Business Review reports for 2 key clients, informing contract renewal decisions
  • Engineered 5+ complex Power BI dashboards integrating millions of rows from Snowflake, SQL Server, SharePoint
  • Implemented Python Prophet forecasting models to predict Traveler headcount and improve assignment rates
  • Facilitated weekly stakeholder calls across 4+ internal teams, delivering custom reporting solutions
Nov 2022 - Feb 2024

Project Execution Specialist

The Select Group (PG&E, FP&L) | San Diego, CA

Accelerated dashboard development and maintenance for utility company project execution teams.

  • Maintained and developed 5+ complex Power BI dashboards with multiple data sources
  • Successfully transitioned One Pager report supporting 26 programs to reach 98% completion target
  • Created data models from Excel, SQL stored procedures, and automated sources
  • Prioritized refresh and maintenance of 4-5 dashboards with unitized tracking
May 2021 - Nov 2022

Senior Business Intelligence Analyst

Aya Healthcare | San Diego, CA

Developed BI solutions for healthcare staffing with focus on headcount forecasting and recruiter performance.

  • Refined business intelligence data to support actionable recommendations via Power BI
  • Adapted complex DAX measures to meet specific business logic requirements
  • Developed improved "Headcount Forecast" dashboard helping recruiters improve 13-week rolling averages by 50%+
  • Provided technical support for existing reports, dashboards, and tools
Jan 2018 - May 2021

Data Analyst

DPR Construction | San Diego, CA

Built comprehensive BI solutions for construction project management and cross-functional business units.

  • Managed databases across SharePoint, Denodo, SQL DB, Azure Data Warehouses, and Power BI Dataflows
  • Developed 4+ large-scale Power BI dashboards for business intelligence
  • Serviced leaders from 4+ business functions: Sales, Marketing, Operations, Finance
  • Created 10+ smaller analytical dashboards for ad-hoc purposes including safety equipment tracking

Dashboard Portfolio

Healthcare Analytics Dashboard

Multi-source Power BI dashboard integrating Snowflake, SQL Server, and SharePoint data to track traveler headcount and assignment rates with predictive forecasting.

Project Execution Dashboard

Comprehensive utility project tracking system monitoring 26+ programs with 98% completion rate targeting, financial tracking, and milestone management.

Headcount Forecasting Model

Python Prophet-based predictive model improving recruiter 13-week rolling averages by 50%+ through advanced forecasting and trend analysis.

Construction Safety Analytics

Safety equipment and PPE tracking dashboard for construction sites with automated reporting and compliance monitoring across multiple job sites.

Let's Connect

Ready to transform your data into actionable insights? Let's discuss how I can help drive your business forward.

Josh.fernandez11@gmail.com
(619) 455-8494
Las Vegas, NV