Description

The consultant will be instrumental in supporting a multi-million-dollar infrastructure initiative spanning multiple global regions (NY, London, Asia). The role involves enhancing data warehouse and reporting systems built on Snowflake, Python, and SQL/Oracle technologies. The ideal candidate will work closely with development teams and business stakeholders, particularly in regulatory reporting and financial data environments.

 

Key Responsibilities:

  • Develop and maintain data pipelines and warehouse solutions using Snowflake and Python.
  • Collaborate with cross-functional teams to understand data requirements.
  • Optimize and manage large-scale data structures supporting regulatory and financial reporting.
  • Schedule and monitor data jobs using Control-M.
  • Implement CI/CD processes using tools like GitHub Actions, TeamCity, and SDA.
  • Conduct code scans and ensure security compliance using tools like Veracode.

 

Required Skills & Experience:

  • 6+ years of hands-on experience in Snowflake Development.
  • 6+ years of Python development experience.
  • Strong background in Data Warehousing Design and Kimball Methodologies.
  • Experience with Oracle or MS SQL Server databases.
  • Proficiency in CI/CD pipelines, especially GitHub, TeamCity, SDA.
  • Experience with Control-M for batch processing.
  • Familiarity with Veracode or similar security scanning tools.
  • Background in large-scale database projects

Education

Bachelor's degree