Deliverables
New SnapLogic pipeline and Snowflake views for:
• External Data Insights
• SnapLogic ETL processes for all Finance dimensions and facts
• Finance Data Warehouse in Snowflake
• Dimensions and Fact views in Snowflake
• Performance enhancements and tuning on the SnapLogic ETL processes

Responsibilities
• Understand the client’s current HANA ETL processes defined by the client’s Finance Performance Management team
• Develop and architect new SnapLogic pipelines in SnapLogic Web IDE to perform ETL from HANA to Snowflake database.
• Build data warehouse in Snowflake with dimensions, fact and underlying calculation views and ensure standards and best practices are used.
• Perform internal Quality Assurance and testing and will document the technical details of the model and knowledge transfer to the client.
• Consultant will deliver the SnapLogic pipeline and Snowflake views to the client team in a Non-Prod environment for review and approval.
• Document the technical details of the new SnapLogic pipeline and Snowflake views.
• Ability to work San Diego, CA Hours
• Provide weekly status report and hours consumed.
• Required to use own laptop and connect to the client via Amazon Workspaces.

Skills
• Extensive Snowflake development skillset
• Strong analytical knowledge
• Team player
• Proficiency in the English language for both written and verbal