Ben Fox, Database Engineer and Tableau Developer in Brentwood, CA, United States
Ben Fox

Database Engineer and Tableau Developer in Brentwood, CA, United States

Member since August 27, 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.
Ben is now available for hire

Portfolio

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

Experience

Location

Brentwood, CA, United States

Availability

Part-time

Preferred Environment

Tableau Server, Tableau, Linux CentOS 7, Windows, Data Building 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.

Employment

  • 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 Building 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, 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), 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: Qlik Sense, QlikView, 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), Matrix 9 Pro, Apache Pig, MicroStrategy, Tableau Server, Tableau

Experience

  • 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.

Skills

  • 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, DBT, Google Data Studio, AWS, MicroStrategy, Data Building Tool (DBT), Airbyte, Dagster
  • Paradigms

    ETL, Six Sigma
  • Platforms

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

Education

  • Master's Degree in Information Systems
    2015 - 2016
    University of Utah - Salt Lake City, Utah, USA
  • Bachelor of Science Degree in Economics
    2008 - 2011
    Brigham Young University - Provo, Utah, USA

Certifications

  • Tableau Server Associate
    SEPTEMBER 2014 - PRESENT
    Tableau

To view more profiles

Join Toptal
Share it with others