Description

You will design, model, and develop enterprise data warehouse solutions while managing high-volume transactional processing systems. You own the release pipeline for the Snowflake platform and sustain enhancements across Development, QA, and Production environments.

Responsibilities

• Design and perform physical modeling and metadata analysis for data structures.
• Develop and optimize SQL queries, stored procedures, and reverse engineer existing processes.
• Provide database design guidance and collaborate with DBAs to troubleshoot and optimize performance.
• Perform complex data analysis across software inventories to identify financial and operational risks.
• Sustain enhancements and release activities for the Snowflake platform.

Required Skills

• 6+ years of experience developing high-availability, high-volume transactional processing systems.
• Proficiency in SQL and SnowSQL.
• Hands-on experience with Python and SSIS.
• Expertise in Data Warehouse (DW) design and implementation.
• Ability to process large volumes of both real-time and batch transactions.
• Experience with Snowflake, Redshift, Vertica, or Greenplum.
• Bachelor's Degree.

Preferred Skills

• Azure Cloud platform experience, including Azure Data Factory and Azure Databricks.
• SQL Server development experience.
• Capital markets industry knowledge.

Key Skills

Education

Bachelor's Degree