Description

You will own the design, development, and maintenance of data warehouse extraction, transformation, and load functions for credit risk management systems.

Responsibilities

• Design and create data warehouse structures and related ETL functions.
• Maintain and resolve ETL and database-related issues.
• Troubleshoot production issues and perform root cause analysis to implement technical resolutions.
• Build scaffolding and frameworks for staging and transforming datasets.
• Collaborate with senior integration staff to define design, priority, and builds.

Required Skills

• 10+ years of professional experience in data integration and development.
• Expert-level MS SQL Server development and strong T-SQL knowledge.
• Minimum 5 years of experience writing DDL/DML SQL scripts, stored procedures, and functions.
• Hands-on experience with SSIS for supporting and developing SQL projects.
• Experience writing SQL queries against Snowflake.
• Proven data modeling experience.
• Ability to work independently to drive assigned tasks to completion.
• Strong troubleshooting skills to identify and resolve production issues.

Preferred Skills

• Experience building data pipelines using Azure Data Factory and Databricks.
• Proficiency with Python and Python application frameworks such as Django, Flask, Pyramid, or Tornado.
• Experience with Python testing and code analysis tools like Pytest or Pylint.

Key Skills

Education

Any Graduate