Sr. ETL/Data Engineer Job at Saxon Global, Chicago, IL

OWlYcEhlWldjSkozTkYveUFtMXFqRXB0d0E9PQ==
  • Saxon Global
  • Chicago, IL

Job Description

CIBC Bank

Chicago IL (hybrid onsite, 2-days per week)

Sr ETL/Data Engineer (Talend/SQL)

What You'll Be Doing

By joining company's Capital Markets Enterprise Solutions Group, you'll be at the heart of a team bringing innovative technology to life as part of our digital transformation. As a Senior Data Engineer/ETL Developer, you'll contribute to the technical design, development and integration of cross-functional, multi-platform application systems. You'll build easy, flexible, and personalized banking solutions that enhance client experience and help build the bank of the future.

We have worked with our client here in Chicago and Canada the last 7 years helping them build out their agile development teams in support of their digital transformation to . Azure Cloud, Azure SQL, Databricks, and ADF

The core of the current work on their CECEL (Anti-Money Laundering) systems. Doing ETL work out of their data in AML/Loan Origination applications using Talend, AzureSQL, Query development/optimizations, EDW Development
  • Experience in ETL/ELT specifically on data heavy applications like Enterprise Data warehouses
  • Have good knowledge of Kimball Imnon models - SCD, Dimensions, Facts, Data modeling - Star, snowflake
  • SSIS is good, but if they also have experience with tools like Informatica, Datastage, Talend, Pyspark, Databricks - that is great. We will be working heavily in Talend as of now (can teach if experienced in Informatica or Datastage)
How You'll Succeed

Business Systems Expertise - Be the subject matter expert in business systems. Use your knowledge to define and document requirements for data, workflow, processes, systems, internal and external checks, controls and outputs to ensure the application exceeds expectations.

Programming Knowledge - Design and development of specifications and perform code reviews. Test, debug, document, and manage changes to ensure the successful implementation and maintenance of programs.

Leadership Skills - Regularly offer guidance and support to fellow developers. Provide strategic, informed recommendations to senior management, and keep up to date on current technology trends.

Who You Are

You can demonstrate experience in SQL, EDW Concepts, Kimball Methodology, Azure SQL or similar cloud db experience, Talend or similar ELT/ETL tools (Informatica, or Datastage) ETL testing, and working in both business facing and scrum team facing role with strong communication and collaboration capabilities. Databricks, Spark are a plus

You have a degree/diploma in Computer Science, SW Engineering/or related programming degree/diploma.

You embrace and champion change. You'll continuously evolve your thinking and the way you work in order to deliver your best.

You're digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.

You give meaning to data. You enjoy investigating complex problems, and making sense of information. You're confident in your ability to communicate detailed information in an impactful way.

Values matter to you. You bring your real self to work and you live our values - trust, teamwork, and accountability.

As Part Of Our Team, You Will

You'll become part of a diverse community that acknowledges everyone's unique talents, and empowers teams to do what's right for the client, and to do it well. What our company knows - our people are our greatest asset.

Thrive : Benefit from an open and approachable culture that provides the flexibility and support you need to integrate your life at work and at home

Connect : Work in a place where the right technology and infrastructure fosters innovation, collaboration and creativity

Develop : Grow your skills and career through our best-in-class onboarding experience, ongoing learning opportunities, and individual development planning.

Prosper : Share in our collective success with a competitive salary, incentive pay, banking benefits, health benefits program, and employee share purchase plan

Required Skills : - 10+ years overall experience in ETL/Data Engineering -Talend ETL Development Experience (hands-on experience). -Informatica or Datastage Experience is also suitable -Strong Skills in Star Schema, Data modeling, SQL, Kimball Methodologies, Div/Fact Tables, and Data Warehousing - Experience working in Data Lake environments - Azure SQL, Azure Devops -Superb communication skills
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Dev: .NET
Branch Code :Chicago

Job Tags

Local area, Work from home, Flexible hours, 2 days per week,

Similar Jobs

Legato, LLC

Software Engineer with C (RC-2-CO) Job at Legato, LLC

 ...Legato, LLC recruiters (****@*****.***) would love to speak with you regarding the following position: Software Engineer with C in Aurora, CO. Security Clearance Required : TS/SCI w/ Polygraph Salary Range: $180,000-$225,000, depending on experience.... 

HCA HealthONE Aurora

Registered Nurse Wound Care PRN Job at HCA HealthONE Aurora

 ...you looking for a work environment where diversity and inclusion thrive? Submit your application for our Registered Nurse Ostomy Wound Care opening with The Medical Center of Aurora today and find out what it truly means to be a part of the HCA Healthcare team. Benefits... 

JD Service Now

HVAC Installer Job at JD Service Now

 ...and opportunities to excel. Why we need you Because we offer top of the line products and services, we need a top of the line HVAC Installer who genuinely care about the customer and look at this opportunity as not just a job but a career. The big task... 

Wegman

IP/Litigation Legal Secretary Job at Wegman

 ...Job Description Job Description Our clients seeks a Legal Secretary to support attorneys in the Intellectual Property (IP) and...  ...declarations of incontestability and renewal applications. Download foreign patents and publications as needed to prepare Information... 

Manpower

Production Worker Job at Manpower

Job Description Job Description Our client, a leading manufacturing company, is seeking Seated Production Workers to join their team. The ideal candidate will have attention to detail and good manual dexterity. Job Title: Production Worker Location: Clear Lake...