John Stone work email
- Valid
- Valid
- Valid
John Stone personal email
As a results-driven Data Engineer with a passion for data innovation, I bring a wealth of experience in data engineering within the tech industry. My career has been marked by a relentless pursuit of excellence, demonstrated through my pioneering data quality assessment techniques and automation of complex processes. My expertise extends to large-scale project management and continuous process improvement in the fast-paced landscape of data engineering.At the forefront of data engineering, I have played a pivotal role in enhancing data infrastructure and streamlining database operations. Recognized for my innovative approach, I have been a driving force in the data engineering space, showcasing a commitment to technical excellence. My track record reflects an ability to deliver multiple large-scale projects simultaneously and meet tight deadlines, ensuring operational efficiencies.Beyond technical prowess, my leadership style is characterized by compassion and motivation. I excel in cultivating robust relationships with cross-functional teams, leading high-performing teams, and fostering an environment of continuous improvement. As a data engineer, I am dedicated to not only delivering results but also fostering an environment of innovation and technical excellence in the fast-paced data engineering landscape.A few of my career highlights include:- Provided software solutions using experience across 12+ programming languages, including designing and delivering a cloud data warehouse in just 3 months as a solo developer at a hospitality tech startup. This project utilized dbt, Redshift, S3, and Looker, and included creating a comprehensive Sales and Marketing data model for consumption in Looker.- Spearheaded the restructuring and migration of hundreds of Spark and Redshift ETL jobs at Amazon, optimizing 50K lines of Spark code, migrating schema, and fine-tuning Redshift datasets. This initiative significantly enhanced performance, improved reliability, and cleared backlog items that were stalled for 2 years.- Delivered comprehensive onboarding and mentorship for Amazon engineers, covering Linux development environment setup, installation of build tools and dev tools, and the process for creating pull requests.
-
Data EngineerMercy ShipsSeattle, Wa, Us
-
Data EngineerResortpass Feb 2023 - Nov 2023New York City , Ny, Us• Architected and implemented a data lakehouse using Redshift, S3, dbt, and Airflow• Implemented Looker as the company’s primary analytics tool, with dbt models as the source• Migrated core datasets and KPIs from Metabase to the data lakehouse and Looker• Designed and implemented data pipelines to ingest and integrate external data sources for ad performance, clickstream data, and geodata using S3, Glue, Redshift Spectrum, dbt, and Airflow• Identified data quality issues and collaborated with data owners to improve data management and collection practices, including a 46% increase in customer location data quality• Created over 1,800 automated tests for data quality, key integrity, data types, and freshness -
Data EngineerWorkstep Sep 2022 - Jan 2023San Francisco, Ca, Us• Designed and developed data models for workforce analytics in a cloud data warehouse using SQL, Python, BigQuery, dbt, Looker, and Fivetran• Implemented key metrics using BigQuery and dbt for modeling and Looker as the business intelligence tool• Assessed and mitigated data quality issues using pandas-profiling, Jupyter, and BigQuery to profile the data and dbt transformations to implement data cleaning logic• Improved the scalability, observability, and performance of data ingestion pipelines by migrating a legacy solution to Google Cloud Storage, BigQuery, and Python• Drafted design documentation and contributed to data engineering project planning -
Data EngineerAvalara Jun 2021 - Jan 2022Durham, Nc, Us• Developed a cloud data warehouse using SQL, Python, Snowflake, and AWS (Airflow, S3) with data sourced from Snowflake, Salesforce, and REST APIs• Increased the performance of data transfer operations by over 1,200% by refactoring Python code used in Airflow to use parallel processing during S3 operations• Led implementation of Git version control, automated unit testing, and CI/CD in the cloud data engineering space for a large team• Refined and extended the team's approach to developing cloud data pipelines: data quality assessment, data architecture review, design, validation, change management, and documentation• Researched issues related to incorrect and missing Salesforce data in collaboration with stakeholders and delivered fixes to Snowflake views -
Data EngineerMercy Ships Apr 2018 - Apr 2021Lindale, Us• Developed data warehouse modules, data extract and load systems, dimensional data models, dashboards, and reports using SQL, Qlik Sense, Salesforce, and REST APIs• Implemented Git version control and a formal software release process for ETL and BI application development• Integrated data from Salesforce, JIRA, Microsoft SQL Server, MySQL, PostgreSQL, Microsoft SharePoint, REST APIs, and flat files• Developed new data models for measuring IT ticket response time, service availability, employment history, employee satisfaction, tenure, retention, global recruitment, and maritime legal compliance auditing
-
Business Intelligence DeveloperStemco Lp Apr 2016 - Aug 2017Longview, Tx, Us• Developed and maintained dashboards, reports, and a dimensional data warehouse using SQL and QlikView• Enhanced the sales and marketing data model to include cost of goods sold• Integrated data from STEMCO’s international locations and acquisitions• Wrote SQL queries to ingest data from multiple relational databases, including Microsoft SQL Server and Oracle• Created source-to-target maps to document data lineage
John Stone Skills
John Stone Education Details
-
University Of Texas At TylerComputer Information Systems
Frequently Asked Questions about John Stone
What company does John Stone work for?
John Stone works for Mercy Ships
What is John Stone's role at the current company?
John Stone's current role is Data Engineer.
What is John Stone's email address?
John Stone's email address is jo****@****ips.org
What schools did John Stone attend?
John Stone attended University Of Texas At Tyler.
What skills is John Stone known for?
John Stone has skills like Programming, Business Analytics, Business Intelligence, Databases, Sql, Data Analysis, Mysql, Analytics, Qlikview, Oracle Sql, Search Engine Optimization, Software Development.
Who are John Stone's colleagues?
John Stone's colleagues are Janet Butler, Christoph Nerz, Amara Lebbie, Onyedikachukwu Ibedu, Tamara Burnett, Omari Mwamtityo, Micah Coltman.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial