Ben Fox
Verified Expert in Engineering
Database Engineer and Tableau Developer
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.
Portfolio
Experience
- SQL - 9 years
- Tableau - 7 years
- Data Engineering - 6 years
- ETL - 6 years
- Python - 3 years
- GitHub - 2 years
- Snowflake - 1 year
Availability
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
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.
Senior Data Engineer
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.
MySQL Database Administrator
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.
Business Intelligence Developer
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.
Data Engineer
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.
Experience
End-to-end Data Engineer
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/ISUCapstoneTableau Public Profile
https://public.tableau.com/app/profile/benfoxEducation
Master's Degree in Information Systems
University of Utah - Salt Lake City, Utah, USA
Bachelor of Science Degree in Economics
Brigham Young University - Provo, Utah, USA
Certifications
Tableau Server Associate
Tableau
Skills
Tools
Tableau, DataGrip, Terminal, MySQL Workbench, GitHub
Languages
SQL, Python 2, Python, R, Snowflake, Python 3, Bash Script
Storage
MySQL, SQL Server 2012, SQL Server Integration Services (SSIS), PostgreSQL
Paradigms
ETL, Six Sigma
Platforms
Windows, Linux CentOS 7, CentOS, Amazon Web Services (AWS), Salesforce, Airbyte, AWS Lambda
Other
Tableau Server, Data Engineering, ETL Tools, Data Visualization, Google Data Studio, MicroStrategy, Data Build Tool (dbt), Dagster
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring