Summary
Overview
Work History
Education
Skills
Certification
Technical Skills
Timeline
Generic

Mark Williams

Tampa

Summary

SQL Developer with over 3 years of experience designing data models, ETL pipelines, and BI dashboards. Proficient in SQL (SQL Server, PostgreSQL) and data modeling with exposure to dbt and Snowflake; experienced in normalizing data into relational databases, building KPIs and metrics, and automating reporting workflows. Demonstrated ability to collaborate with stakeholders to design data products, deliver actionable insights, and drive adoption of self-service analytics. Passionate about leveraging modern data tools and AI-driven analytics to empower teams in dynamic, high-growth environments.

Overview

6
6
years of professional experience
1
1
Certification

Work History

SQL Developer

Exzeo USA
11.2022 - Current
  • Developed and implemented data models and normalized relational tables across policy, claims, rating, and customer service data to support unified metrics and analytics.
  • Designed and built KPI frameworks, metric definitions, and dashboards using SQL, Power BI, and SSRS; automated data transformations with SSIS and ZappySys.
  • Collaborated with cross-functional teams (Underwriting, Claims, Finance, Compliance, Data Engineering) to identify business problems, gather requirements, and deliver actionable reporting solutions.
  • Improved data quality and system performance by optimizing queries, indexing, and refactoring legacy code, reducing report run times and increasing reliability.
  • Built and documented self-service reporting frameworks that empowered stakeholders to explore data independently and made knowledge transfer easier.
  • Mentored junior analysts on SQL best practices, data modeling, and BI tools; proactively explored new analytics tools, including AI-driven insights, to drive innovation.

Frontline Underwriter

USAA
05.2019 - 06.2021
  • Provided frontline underwriting support, advising clients on policy selection and compliance, communicating complex coverage information to diverse audiences, and leveraging customer insights to inform data-driven improvements in later analytics roles.

Education

Bachelor of Science - Finance

University of South Florida
Tampa, FL
12.2018

Skills

  • SQL Server
  • PostgreSQL
  • Snowflake
  • Data warehousing
  • Normalization
  • ETL
  • SSIS
  • ZappySys
  • Data modeling
  • Power BI
  • SSRS
  • DAX
  • KPI design
  • Dashboarding
  • Tableau
  • Looker
  • Sigma
  • T-SQL
  • GitHub
  • REST API integration
  • AI-driven analytics
  • Stakeholder engagement
  • Requirements gathering
  • KPI definition
  • Data quality control
  • Documentation
  • Mentoring
  • Continuous improvement

Certification

  • CompTIA Project+
  • CIW Data Analyst

Technical Skills

SQL Server, PostgreSQL, Snowflake (learning), data warehousing, normalization, ETL (SSIS, ZappySys), data modeling (exposure to dbt), Power BI, SSRS, DAX, KPI design, dashboarding, transferable to Tableau, Looker, Sigma, SQL, T-SQL, DAX, Python (pandas, matplotlib, openpyxl), GitHub, REST API integration, AI-driven analytics (exposure to GPT predictive modeling), Stakeholder engagement, requirements gathering, KPI definition, data quality control, documentation, mentoring, continuous improvement

Timeline

SQL Developer

Exzeo USA
11.2022 - Current

Frontline Underwriter

USAA
05.2019 - 06.2021

Bachelor of Science - Finance

University of South Florida
Mark Williams