- Be a subject matter expert and provide consultation to business partners such as analysts, management, end users, and developers to clarify requirements, determine scope / estimates, drive design discussions, code reviews, and performance tuning.
- Design and lead the development for data warehouse solutions, including design, development, and implementation of the data integration / ETL processes to enable Marketing, Sales, Services and Support Metrics.
- Design and build facts, dimensions, snapshots, SCDs in Redshift using SnapLogic
- Architect data models and perform performance tuning
- Develop ETL to move data from salesforce.com and cornerstone into Enterprise Analytics Data Warehouse and implement best practices for ETL development
- Create ETL pipelines that are highly optimized with very large data sets
- Work effectively using scrum with multiple team members to deliver analytical solutions to the business functions.
- Solve issues with data models and come up with solutions