Data Analyst

12 Nov 2024

Vacancy expired!

Our direct client in downtown Chicago is looking for

Data Analysts to help with Data warehouse project- should be familiar with Oracle and SQL. Snowflake environment experience is a plus.

Financial domain experience required

Experience - 9+ years

Location - Chicago, Local candidates or willing to relocate to Chicago on short notice

Contractor’s Role:• The candidate will be involved in the design, architecture and development of Corporate Data Warehouse utilizing Oracle SQL and PL/SQL, data warehouse / ETL tools and Unix Scripts.• You will leverage past experience with business application development to analyze data and create mapping documents that can capture data warehouse needs and be handed over to the team for processing. Respond to the ETL queries, ensuring a robust application delivery.• In addition to design and development, this individual will help set standards and practices for production support and maintenance of technical disciplines that are new to this department.

Qualifications:• Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area.• Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area.• Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications.• Ability to interact and communicate effectively with senior level business teams to ensure optimal results.• Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle.- Financial background (have a higher level knowledge of invoice statements and balance sheets)- Basic EFT tool development experience

Tasks & responsibilities:• Project and related application development are part the bank's providing management and regulatory reporting functionality in the areas of risk and compliance.• Operational Risk Reporting application is beginning development and two Credit Risk application projects are nearing design phase.• This data architect position will work closely with these projects and follow-on risk application development participating in full project life cycle.• The candidate would have the opportunity to be involved in the design, architecture and development of many aspects of the Corporate Risk Data Warehouse utilizing Oracle sql and pl/sql, data warehouse / ETL tools and Unix Scripts.• In addition to design and development, this candidate is expected to be a lead technical resource for this division helping to set standards and practices for production support and maintenance of technical disciplines such as these that are new to this department.• Ideally this candidate will also have previous well rounded experience with business application development as well as recent solid concentration on data warehouses, ETL processing and business intelligence tools.• The data warehouse ETL processes will interface with numerous corporate transaction systems to gather information for the warehouse.

Please forward your resume to

  • ID: #22600302
  • State: Illinois Chicago 60290 Chicago USA
  • City: Chicago
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-11-12
  • Deadline: 2021-12-20
  • Category: Et cetera