ETL/Python Developer in Credit Risk

New York City Metropolitan Area (Hybrid)

Job Overview:

This role is based in New York, requiring the successful candidate to be on-site (NY and/or NJ office) a couple of times a week (up to 5 times a week if it’s needed). US. Visa/Work Permit could be offered to the eligible candidate. We are also open to a contract-based assignment such as C2C.

Dentsu and GE. The unmatched combination of two world-class companies and ISID's daring spirit to explore new business areas is the DNA that fuels our success. Leveraging our four strengths –

• Fusion of business expertise and IT implementation power

• Global network for worldwide collaboration

• Research and development excellence

• Unmatched synergies as part of the Dentsu Group

We provide valuable solutions to our clients.

Responsibilities:

• Support and enhance existing SSIS SQL Projects.

• Migrate existing SSIS ETL scripts to Python.

• ETL pipelines in and out of data warehouse using combination of SSIS, Python and Snowflakes SnowSQL.

• Writing SQL queries against Snowflake.

• Developing scripts Python etc. to do Extract, Load and Transform data.

• Understanding data pipelines and modern ways of automating data pipeline using cloud-based.

• Work closely with existing senior integration staff to flush out design, priority and build.

• Scaffolding and framework will be needed for staging and transforming datasets.

• Use existing DevOps pipeline for Python and enhance if necessary.

• Automate Python scripts on our enterprise scheduler.

• Strong troubleshooting skills to identify root cause and resolve production issues.

Required Qualifications:

• 8 years of development experience using Python.

• Designing and implementing highly performant data ingestion pipelines from multiple sources.

• Direct experience of building data pipelines using Azure Data Factory and (preferably Databricks).

• Extensive experience in software development and the entire SDLC.

• Solid understanding of a variety of programming tools and development platforms.

• Experience in creating high-level product specifications and design documents.

• Experience in writing Python applications with the benefit of frameworks like Django, Flask, Pyramid, or Tornado.

• Experience in Python testing and code analysis tools like Pytest and Pylint.

• Integration experience (ETL, ELT) with Python.

• Strong SQL skills.

• Strong understanding and proficent experience of using SSIS as ETL developer.

• General development expertise, use of version control, ticketing, and continuous integration systems.

• Experience in using an Enterprise Scheduler (Tidal).

• Experience in an Agile Development environment.

• On-point communication skills to concisely report status of work/issues and next action, and articulate technical complexity to Business analysts, Project manager and Business users.

• Experience of using Azure Databricks is a plus.

Work Style:

This role is based in New York, requiring the successful candidate to be on-site (NY office) a couple of times a week.

Contract:

Full Time Employee or C2C(negotiable)

Compensation:

The expected daily rate ranges from $480-640. Daily rate offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications and licenses obtained. Market and organizational factors are also considered.