Sr. ETL/Data Engineer

2 months ago

Chicago, United States Saxon Global Full time
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

  • Sr. ETL/Data Engineer

    2 weeks ago

    Chicago, United States Saxon Global Full time

    CIBC BankChicago 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...

  • Sr. Data Engineer Integrations

    4 weeks ago

    Chicago, United States fairlife, LLC Full time

    fairlife, LLC is a Chicago-based nutrition company that creates great-tasting, nutrition-rich and dairy products to nourish consumers.With nearly $2B in annual retail sales, fairlife s portfolio of delicious, lactose-free, real dairy products includes: fairlife ultra-filtered milk; Core Power High Protein Shakes, a sports nutrition drink to support...

  • Sr Data Modeler

    3 days ago

    Chicago, United States DATAECONOMY Full time

    Sr. Data ModelerChicago ILFulltimeKey Skills Required:Data Modelling: Extensive experience in data modelling including conceptual logical and physical data models.DRB (Data Resource Book): Strong experience with DRB methodologies and tools.Database Design: Proficiency in database design and development including normalization indexing and partitioning.SQL:...

  • Sr. Data Engineer

    3 months ago

    Chicago, United States fairlife Full time

    Job DescriptionJob Descriptionfairlife, LLC is a Chicago-based nutrition company that creates great-tasting, nutrition-rich and dairy products to nourish consumers.With nearly $2B in annual retail sales, fairlife's portfolio of delicious, lactose-free, real dairy products includes: fairlife® ultra-filtered milk; Core Power® High Protein Shakes, a...

  • Azure Sr. Data Engineer

    2 months ago

    Chicago, United States Cyclotron, Inc. Full time

    Job DescriptionJob DescriptionSr. Data EngineerLevel: SeniorDepartment: AzureLocation: Anywhere in US (fully remote)Type: FTE  GENERAL DESCRIPTION & RESPONSIBILITIES The Sr. Azure Data Engineer will lead the creation of high-value data driven solutions leveraging Cyclotron’s proven implementation methodology and solutions for enterprise projects, as...

  • Azure Sr. Data Engineer

    7 days ago

    Chicago, United States Cyclotron, Inc. Full time

    Job DescriptionJob DescriptionSr. Data EngineerLevel: SeniorDepartment: AzureLocation: Anywhere in US or Canada (fully remote)Type: FTE  GENERAL DESCRIPTION & RESPONSIBILITIES The Sr. Azure Data Engineer will lead the creation of high-value data driven solutions leveraging Cyclotron’s proven implementation methodology and solutions for enterprise...

  • Sr. Data Engineer

    3 months ago

    Chicago, United States Ampcus Full time

    Position: Sr. Data Engineer Location: Chicago, IL. (Hybrid) Duration: + Months Contract Summary: We are seeking an experienced data engineer to contribute to a high data volume Electronic Medical Records (EMR) application. This critical system not only requires ongoing production maintenance but also demands enhancements through integration with...

  • Data Engineer

    2 weeks ago

    Chicago, United States Motion Recruitment Full time

    Data Engineer Are you passionate about transforming data into actionable insights? This company, a global leader in knowledge sharing and business connections, is seeking a skilled and dedicated full-time, hybrid Data Engineer to be in office Tuesdays and Thursdays. In this role, you will be responsible for developing and maintaining database scripts, ETL,...

  • Head of Data Platform Engineering

    3 months ago

    Chicago, United States CPC Marketing Full time

    About The RoleAs a Lead Data Operations Engineer you will work on supporting the data engineering and BI teams ensuring pipelines are working correctly, the platforms are up and healthy, and our systems are operating at their optimal efficiency. What You’ll DoHelp to ensure the regular sharing of data within and outside the companyAssess the ongoing...

  • Head of Data Platform Engineering

    3 months ago

    Chicago, United States CPC Marketing Full time

    About The RoleAs a Lead Data Operations Engineer you will work on supporting the data engineering and BI teams ensuring pipelines are working correctly, the platforms are up and healthy, and our systems are operating at their optimal efficiency. What You’ll DoHelp to ensure the regular sharing of data within and outside the companyAssess the ongoing...

  • Sr Data Engineer

    2 weeks ago

    Chicago, United States Abbott Laboratories Full time

    At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You’ll also have access to:Career development with an international company where you can grow the career you dream of .Free medical coverage for employees* via the Health Investment Plan (HIP) PPOAn excellent retirement...

  • ETL SSIS Developer

    3 days ago

    Chicago, United States Smartwork IT Services Full time

    Job Title: ETL SSIS Developer Location: ChicagoIL (Onsite) Job Type: Contract (Long term) Job Description: Primary Skills: Data warehousing ETL SSIS Data model MSBI and Python. Responsibilities: Bachelors with 7 or Masters with 5 experience in Computer Science Engineering Math or other quantitative field. 7 Experience with developing Batch ETL/ELT...

  • Senior Data Engineer

    2 months ago

    Chicago, United States Top Prospect Group Full time

    Are you a seasoned data engineering professional with a passion for driving innovation in data solutions? If you have a proven track record in designing and implementing robust data architectures on the Azure platform, we want to hear from you!Direct hire- FT$150-160KONSITE- one of 2 locations-Candidate choice- CT or ILSkills: SQL, Azure, Azure Data Bricks,...

  • Data Engineer

    2 weeks ago

    Chicago, United States MyCareersFuture Full time

    Roles & Responsibilities Role: Data Engineer Experience: 6+ Years Key Skills: Hadoop, ETL Informatica, Shell Scripting, Data warehousing Minimum 4 years or above with the relevant experience Proficiency in Informatica PowerCenter 10.x or higher preferably in a Unix (Linux/AIX) environment with AS400/Oracle sources and targets. Must have experience in...

  • Data Pipeline Engineer

    12 hours ago

    Chicago, Illinois, United States Jobot Full time

    About the RoleWe are seeking a highly skilled Data Pipeline Engineer to join our team at Jobot. As a key member of our data infrastructure team, you will be responsible for designing, building, and deploying ETL and ELT flows for consuming data from disparate sources.Key ResponsibilitiesCreate and deploy ETL and ELT flows for consuming data from various...

  • Senior Data Engineer

    5 days ago

    Chicago, Illinois, United States Tiger Analytics Full time

    About Tiger AnalyticsTiger Analytics is a leading advanced analytics consulting firm that helps Fortune 500 companies generate business value from data. Our team of experts brings deep expertise in Data Science, Machine Learning, and AI, and we are recognized by market research firms such as Forrester and Gartner for our business value and leadership.Job...

  • Senior Data Engineer

    2 months ago

    Chicago, United States Top Prospect Group, Inc. Full time

    Job DescriptionJob DescriptionReady to take your expertise in Azure data engineering to the next level? Join our team as a Senior Azure Data Engineer ! Are you a seasoned data engineering professional with a passion for driving innovation in data solutions? If you have a proven track record in designing and implementing robust data architectures on the...

  • Senior Data Engineer Position

    5 days ago

    Chicago, Illinois, United States Motion Recruitment Full time

    About the RoleWe are seeking a highly skilled Mid-Level Data Engineer to join our team at Motion Recruitment. This is a full-time direct-hire opportunity that offers a chance to work with a leading industry player in data, technology, and finance.Key ResponsibilitiesDesign and implement efficient ETL processes to streamline data processingCollaborate with...

  • Data Engineering Expert Wanted

    5 days ago

    Chicago, Illinois, United States Motion Recruitment Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Motion Recruitment. As a Data Engineer, you will play a crucial role in designing, building, and maintaining large-scale data systems.Key ResponsibilitiesDesign and implement data pipelines using ETL tools and technologies such as Python, C#, AWS, Hadoop, PySpark Hive, and...

  • Data Engineer

    1 day ago

    Chicago, United States Selby Jennings Full time

    We are seeking a Data Engineer to join the commodities team at a leading trading firm, where you'll be responsible for building and maintaining data pipelines for the ingestion, management, and analysis of datasets used by traders. Key Responsibilities:Develop and maintain reliable ETL pipelines using Python.Collaborate within a small, experienced...