Senior Business Analyst in Counterparty 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. 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. #J-18808-Ljbffr DENTSU SOKEN USA, INC.