Senior Data Engineer in Atlassian's Customer Support Services (CSS) organization working directly with stakeholders to design and implement data solutions to improve the overall measurement of support staff efficiency and customer friction.
Architected and led the successful implementation of a new data ingestion framework for RDS-backed sources leveraging AWS' DMS, Airflow, and Databricks for exposing current and historical views of application data in the data lake.
Led a soup-to-nuts multi-quarter initiative to rebuild CSS' data warehouse as a dimensional model leveraging Spark and Airflow over Postgres, Hive, and homegrown ETL orchestration tools.
Created feature roadmaps and prioritized Data Engineering initiatives for a cross-functional team of program managers and business analysts.
Helped drive the adoption of new and improved integration services for onboarding data sources into Atlassian's Data Lake housed in S3.
Collaborated with new team members on defining, tracking, and upholding data quality measures and SLOs for CSS' core data models and critical ETL pipelines.
Mentored new Data Engineers in different offices through onboarding projects thereby ensuring new hires feel like welcomed members of an awesome super team.
Data Architect
4SIGHT BUSINESSS INTELLIGENCE, INC
03.2016 - 10.2016
Designed and built automated ETL extensions to replicate and manage Data Warehouse environments on Amazon Redshift and HP Vertica.
Deployed five custom Web Servers for new clients to programmatically generate XML files used in data migration projects from historical applications to new Policy Administration systems.
Maintained and enhanced ROLAP cubes, measure, and hierarchy definitions in Mondrian Schema using Pentaho Schema Workbench.
ETL Developer
SIMPLY WELL (formerly VIVERAE, INC)
06.2015 - 03.2016
Designed and developed end-to-end ETL framework to automate validation of third party client data integrations; successful replacement of manual process with automated ETL review resulting in reduction of one FTE per year in the IT organization.
Migrated mission critical Data Processing Hubs from legacy ETL tools to Pentaho Data Integration.
Managed dashboard suite using Qlikview for Exec Ops team.
Data Integration Engineer
SIMPLYWELL (formerly VIVERAE, INC.)
12.2013 - 06.2015
Created ETL transformation pre-processes to transform non-compliant (fixed-width, HL7, and XML data formats) into Viverae's standardly accepted file layout.
Maintained health informatics database used in validating reduction of client's population health risk through Wellness Programs.
Business Data Analyst
SIMPLYWELL (formerly VIVERAE, INC.)
02.2013 - 12.2013
Liaised with internal stakeholders and external parties to define both business requirements and technical design specifications for all client-requested, custom Data Feeds.
Conducted quality control review of ETL Developer's deliverables using both complex SQL and source system validations.
Defined project specifications, timelines, and scope to ensure all projects were completed in an organized fashion.
Senior Healthcare Data Analyst
EQUIAN (formerly THE ASSIST GROUP)
07.2011 - 02.2013
Authored SQL queries for ad-hoc reporting and in-house healthcare industry analytics.
Implemented automated jobs and transformations using Pentaho Data Integration, which evaluate hospital bill data for inconsistencies and potential savings opportunities.
Optimized department efficiency by analyzing procedures and data regarding charting and patient flows.
Education
Bachelor of Science - Business Administration – Operations and Information Management
University Of Colorado At Boulder
Boulder, CO
05.2011
Bachelor of Arts - History
University Of Colorado At Boulder
Boulder, CO
05.2011
Skills
Code: Python, SQL, Bash
Frameworks: Spark, Flask, Airflow
Databases : Hive, Presto/Athena, Redshift, Vertica, Postgres, MySQL
Streaming: AWS Kinesis
DevOps: Docker
Data Modeling: Dimensional Modeling, Data Vault
Personal Interests
Mentoring disadvantaged youth in leadership through outdoor adventures with Explore Austin
Cooking
Dog training
Oil painting
Yoga
Timeline
Senior Data Engineer
ATLASSIAN
10.2016 - Current
Data Architect
4SIGHT BUSINESSS INTELLIGENCE, INC
03.2016 - 10.2016
ETL Developer
SIMPLY WELL (formerly VIVERAE, INC)
06.2015 - 03.2016
Data Integration Engineer
SIMPLYWELL (formerly VIVERAE, INC.)
12.2013 - 06.2015
Business Data Analyst
SIMPLYWELL (formerly VIVERAE, INC.)
02.2013 - 12.2013
Senior Healthcare Data Analyst
EQUIAN (formerly THE ASSIST GROUP)
07.2011 - 02.2013
Bachelor of Science - Business Administration – Operations and Information Management