Snowflake Developer with Finance/Banking

AOA Software Solutions, LLC - Jersey City, NJ

Full-time - Senior

Jersey City, NJ

About the position

The Sr. Snowflake Developer will be responsible for leveraging Snowflake, a cloud-based data warehousing platform, to manage and analyze financial data. This role is crucial in providing architecture, design, implementation, and operational support for large-scale data and analytics solutions within the finance and banking sector.

Responsibilities

• Provide architecture, design, implementation, and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
• Provide production support for Data Warehouse issues such as data load problems and transformation translation problems.
• Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
• Work on data pipelines and modern ways of automating data pipeline using cloud-based testing and document implementations clearly.
• Perform code reviews to ensure fit to requirements, optimal execution patterns, and adherence to established standards.
• Develop EL pipelines in and out of the data warehouse using a combination of Databricks, Python, and SnowSQL.
• Provide data ingestion and processing pipelines using Python, Databricks, and SnowSQL.
• Establish and monitor Operational Level Agreements for the health and performance/cost of the warehouse environment.

Requirements

• Overall 10+ years of experience is required.
• Minimum 5 years of experience in design and implementation of large-scale data solutions on Azure Snowflake Data Warehouse.
• Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
• Good experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Good knowledge of MS Azure configuration items with respect to Snowflake.
• Experience in writing scripts (UNIX, Python).
• Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies.