Personal details
Joshua M.
Based in: 🇺🇸 United States
Timezone: Eastern Time (US & Canada) (UTC-4)
About
Experienced data engineer with extensive healthcare experience able to bridge the divide between IT and business operations to implement cutting edge solutions that deliver real value
Work Experience
Chief Data Officer
Catalyst IQ | Jan 2020 - Present
Python
SQL
Salesforce
Amazon Redshift
AWS Lambda
Power BI
Snowflake
Salesforce Marketing Cloud
Databricks
AWS
- Ideated, designed, and built an advanced customer analytics dashboard and data warehouse spanning 15 internal and external datasets using Amazon Web Services Lambda, Databricks, Amazon Web Services Athena, and Power BI that reduced marketing spend by 15%.
- Spearheaded AI strategy and implementation within content creation, customer segmentation, and engagement analytics for multiple pharmaceutical companies.
- Built end to end automated data pipelines to transfer data from Salesforce and Salesforce Marketing Cloud into Snowflake for analytics engagement monitoring reducing data latency from monthly to daily while keeping processing costs flat.
- Architected and built a custom SQL schema that allows for precise and flexible querying and analysis of omnichannel customer interactions and implemented in Databricks, Redshift, and Snowflake.
- Developed Python code to configure and launch GPT assistants to automatically segment customers based on multivariate statistical analyses.
- Trained models using custom datasets built in Snowflake to improve tagging accuracy by 80%.
- Mentored multiple junior data engineers providing training, career advice, and direct instruction.
Senior Managing Consultant
Catalyst IQ | Jul 2016 - Jan 2020
Google Analytics
Google BigQuery
Amazon Redshift
Qlik Sense
- Developed a data cube for tracking digital consumer engagement and ROI for digital ad campaigns across multiple client brands integrating over a dozen upstream data sources into a single joined cube allowing for easy querying and analysis.
- Implemented JSON based data layer for improving metadata tracking across client owned web properties.
- Built end to end data pipelines ingesting custom actions and dimensions from web properties through Google Analytics, Google Big Query, Amazon Web Services Redshift, and Qlik Sense dashboarding.
- Led data standardization and quality assurance efforts to provide client with maximum value from datasets they purchased.
Education
PENNSYLVANIA STATE UNIVERSITY
Bachelor's degree・MANAGEMENT INFORMATION SYSTEMS
Aug 2008 - May 2012