Snowflake Developer

Deliverables
New SnapLogic pipeline and Snowflake views for:

1. External Data Insights
2. SnapLogic ETL processes for all Finance dimensions and facts
3. Finance Data Warehouse in Snowflake
4. Dimensions and Fact views in Snowflake
5. Performance enhancements and tuning on the SnapLogic ETL processes

Responsibilities

1. Understand the client’s current HANA ETL processes defined by the client’s Finance Performance Management team.
2. Develop and architect new SnapLogic pipelines in SnapLogic Web IDE to perform ETL from HANA to Snowflake database.
3. Build data warehouse in Snowflake with dimensions, fact, and underlying calculation views and ensure standards and best practices are used.
4. Perform internal Quality Assurance and testing and document the technical details of the model and knowledge transfer to the client.
5. Deliver the SnapLogic pipeline and Snowflake views to the client team in a Non-Prod environment for review and approval.
6. Document the technical details of the new SnapLogic pipeline and Snowflake views.
7. Work in San Diego, CA hours.
8. Provide weekly status reports and hours consumed.
9. Use own laptop and connect to the client via Amazon Workspaces.

Skills

1. Extensive Snowflake development skillset
2. Strong analytical knowledge
3. Team player
4. Proficiency in the English language for both written and verbal communication