Ben Fox, Developer in Brentwood, CA, United States
Ben is available for hire
Hire Ben

Ben Fox

Verified Expert  in Engineering

Database Engineer and Tableau Developer

Location
Brentwood, CA, United States
Toptal Member Since
September 2, 2020

Ben excels at managing and wrangling disparate data. He is an experienced database Engineer with end-to-end knowledge of data systems, from flat files and APIs to visualizations. Ben has learned the value of being a team player, managing expectations, or assisting coworkers with varying degrees of technical understanding. He has a decade of expertise working with ETL and visualizing disparate data sources. Some of his favorite tools to use are DBT, GitHub, and Tableau.

Data EngineeringSQLTableauMySQLData VisualizationETLWindowsLinux CentOS 7SQL Server 2012SQL Server Integration Services (SSIS)MicroStrategyPythonMySQL WorkbenchPython 2Python 3

Portfolio

Toptal
Data Build Tool (dbt), Tableau, PostgreSQL, Bash Script
Rad Power Bikes
Python, Dagster, Tableau, GitHub, Data Build Tool (dbt), AWS Lambda
Compliance and Risks
Amazon Web Services (AWS), Google Data Studio, Terminal, CentOS, R, Python...

Experience

SQL - 9 yearsTableau - 7 yearsData Engineering - 6 yearsETL - 6 yearsPython - 3 yearsGitHub - 2 yearsSnowflake - 1 year

Availability

Part-time

Preferred Environment

Tableau Server, Tableau, Linux CentOS 7, Windows, Data Build Tool (dbt), PostgreSQL, Airbyte, Python 3

The most amazing...

...thing I've created is an end-to-end data process from raw files to a data warehouse, APIs, and visualizations.

Work Experience

Data Engineer and Data Analyst

2020 - PRESENT
Toptal
  • Gathered requirements from stakeholders and translated them into data and visualization needs. Continued through the iterative process to create valuable unique reports.
  • Visualized the data in a series of Tableau reports with daily updates.
  • Integrated reports and data with an NCOA platform and Salesforce.
  • Created a logging process to keep the data and reporting up to date.
  • Built a data warehouse from flat files using DBT and daily Bash scripts.
Technologies: Data Build Tool (dbt), Tableau, PostgreSQL, Bash Script

Senior Data Engineer

2022 - 2022
Rad Power Bikes
  • Developed a Python connector to an automated API via AWS Lambdas and Dagster that connected with the Google Calendar to find the average amount of time between service requests and their resolution.
  • Upgraded and maintained DBT code via GitHub. Implemented the SQL fluff pre-commit hook to ensure the code was lined correctly.
  • Increased utilization of Airbyte and Fivetran connectors to various data sources.
  • Worked within a team of data engineers as we spoke with non-data people to evaluate their needs and build pipelines to fit their non-technical requests.
Technologies: Python, Dagster, Tableau, GitHub, Data Build Tool (dbt), AWS Lambda

MySQL Database Administrator

2018 - 2021
Compliance and Risks
  • Migrated multiple production MySQL databases into an InnoDB cluster on AWS and on-premises data with less than a minute of downtime.
  • Created an automatic Python process to build and update a data warehouse to give insight into customer actions and relations.
  • Built visualization reports using tools such as Tableau, Logi Analytics, and Google Data Studio tools.
  • Scripted an automatic process to send out emails inquiring about specific problems with the database.
Technologies: Amazon Web Services (AWS), Google Data Studio, Terminal, CentOS, R, Python, MySQL

Business Intelligence Developer

2015 - 2018
Health Catalyst
  • Created data models around healthcare from disparate data sources.
  • Converted complex QlikView applications to work fluidly in Tableau.
  • Consulted internally and with external clients on the features and limitations of Tableau.
Technologies: SQL Server 2012, Tableau

Data Engineer

2011 - 2014
Ancestry.com
  • Migrated key reports from both a data warehouse change to Columnar storage (SQL to Matrix) and a visualization change (Excel and micro-strategy to Tableau).
  • Built a micro-strategy mobile app from Star Schema to Snowflake using views and all objects and reports within the micro-strategy.
  • Administrated a large Tableau server implementation of 1,400.
Technologies: SQL Server Integration Services (SSIS), MicroStrategy, Tableau Server, Tableau

End-to-end Data Engineer

I began data engineering with CSVs. I created a data warehouse and model around a star schema and automated the daily database update using DBT and Ubuntu.
I pulled data into tables for reporting and pushed it to APIs and Salesforce for marketing.
I also created many visualizations inside Tableau for the business to evaluate progress and goals that were updated with the database.

Speed Skating Python Web Scraper

https://github.com/theyoungfox/ISUCapstone
A Python-based application that hits a Norwegian speed skating website to pull data. This script creates a list of websites from which to request data. It creates a sort of API via the internet. US Speed Skating requested this to help them analyze their times.

Tableau Public Profile

https://public.tableau.com/app/profile/benfox
I created some visualizations to illustrate my Tableau skills. They are primarily for demonstration and educational purposes. I entered a few into the Tableau public contest and have some client-based dashboards I can provide on request.

Languages

SQL, Python 2, Python, R, Snowflake, Python 3, Bash Script

Tools

Tableau, DataGrip, Terminal, MySQL Workbench, GitHub

Storage

MySQL, SQL Server 2012, SQL Server Integration Services (SSIS), PostgreSQL

Other

Tableau Server, Data Engineering, ETL Tools, Data Visualization, Google Data Studio, MicroStrategy, Data Build Tool (dbt), Dagster

Paradigms

ETL, Six Sigma

Platforms

Windows, Linux CentOS 7, CentOS, Amazon Web Services (AWS), Salesforce, Airbyte, AWS Lambda

2015 - 2016

Master's Degree in Information Systems

University of Utah - Salt Lake City, Utah, USA

2008 - 2011

Bachelor of Science Degree in Economics

Brigham Young University - Provo, Utah, USA

SEPTEMBER 2014 - PRESENT

Tableau Server Associate

Tableau

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring