7 days old

SSIS - ETL - Techno/Functional Developer

Chicago, IL 60606
  • Job Code

This position is for a data analyst / engineer involved in the development, maintenance and documentation of the data infrastructure used for Capital Stress Testing, Model Validation and Market Risk reporting. The position will be uniquely positioned to partner with IT, Treasury, FP&A and Risk to centralize data processing for ALM processes and Capital Stress Testing.

Key Responsibilities Include:

- Support the current risk data infrastructure to consolidate multiple data sources into a single source using ETL

- Responsible for documenting business logic and maintaining procedures

- Develop complex SQL queries for small to large sets of data and lead query optimization efforts

- Understand process inputs and create solutions to automate data sources and apply data governance standards

- Support daily/monthly operations and troubleshoot issues

- Design and architect artifacts using Data Modeling concepts

- Develop and maintain the database infrastructure for Capital Stress Testing & Data Governance around the ALM process

This will be an individual contributor role.

The following qualifications are required:

- Bachelor's Degree in a concentration with an analytical focus

- 3-5 years of experience.

- Experience in one or more ETL Tools: SSIS, Informatica, Alteryx or other tool with understanding of best practices for building and designing ETL code

- Database development/engineering experience in one or both of the following databases: SQL Server, Oracle, Teradata

- Experience using Database Modeling Tools: Erwin or other tool

- Passion for data with a data warehousing or business intelligence background

- Strong data management, analytical, communication, and technical writing skills

- Individual must be self-motivated and able to bring projects to their conclusion

- Ability to communicate technical terms into business terms and establish productive relationships with internal business partners

The following qualifications are not required, but highly desired:

- Sufficient understanding of the General Ledger (ex. Balance Sheet and Income Statement)

- Hands on experience with .NET/Python/Scala

- Familiarity with the Hadoop framework (NoSQL, Hive, Kafka) and/or other Big Data tools


  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

SSIS - ETL - Techno/Functional Developer

Randstad Technologies
Chicago, IL 60606

Share this job

SSIS - ETL - Techno/Functional Developer

Randstad Technologies
Chicago, IL

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast