Burleson, Texas, United States
Data professional combining data modeling, ETL pipelines, data warehousing and solutions architecture to provide optimized data assets
Collaborated with clients to understand business needs and design and build cloud data solutions on AWS, Azure and GCP Managed a team of 6 data engineers, helping set development milestones and holding regular meetings to track their progress and provide guidance as necessary to help them reach those milestones Wrote custom pipelines in Python and Go to ingest, validate, parse and transform healthcare data and load it into the GCP Healthcare FHIR store for consumption by end users Designed and built ETL pipelines using AWS Lambda, AWS Cloudwatch and AWS Glue to ingest ServiceNow and Amazon Connect data and populate Redshift data lake and SQL Server RDS reporting tables for PowerBI Developed an OMOP data model for a pharmaceutical client to track user behavior across various healthcare applications Lead data design sessions to coordinate both internal and external resources to ensure the on time and quality development of robust data pipelines
Managed a team of 4-6 data and analytics engineers developing data solutions across multiple environments including GCP, SQL Server, Vertica and Hive to power the analytics of the global customer service organization and the tools used by the call center agents Worked closely with business and engineering stakeholders to understand current and future high level business goals and development objectives, to provide ongoing data engineering and data governance support, as well as built multi-quarter development pipeline to continue to engineer scalable and performant data tools Designed and implemented an end to end streaming cloud data pipeline reading messages from Google PubSub using Dataflow (Apache Beam) and writing simultaneously to Google Big Query for analysis and to Cloud Storage to ensure properly maintained data lake Developed a normalized data model which enabled both the expedited creation of denormalized tables for consumption in SQL Server, SSAS and Tableau based on business needs and empowered business analysts to more easily perform ad hoc data exploration. Scoped and oversaw the build and maintenance of dashboards which provided up to the day performance metrics for all 3K+ global call center agents Worked with direct reports to set technical and professional development goals and held regular 1-1's with them to help reach those goals
Developed ETL pipelines using Python, Presto and Oracle SQL landing data in Hive and Presto, pulling position and worker data from source systems, providing the company with a more accurate picture of both individual changes and larger scale reorganizations, enabling more thorough and efficient workforce planning Developed a series of dimensions which tracked hires, transfers and terminations by department that were used in waterfall dashboards to provide a high level view of employee movement to department leadership Aided in a migration of from legacy ETL tools and databases to Dataswarm pipelines landing data in Hive and Presto Developed and implemented Data Quality process to ensure usability of new data model before publishing to production tables to help maintain end user confidence in data warehouse