Senior Data Engineer

7 days ago


Rosemont, California, United States Diverse Lynx Full time
Sr. Data Engineer Position Overview

The ideal candidate will have a strong background in developing Batch
ETL/ELT
processes using SQL Server and
SSIS
ensuring all related data pipelines meet best-in-class standards offering high performance.

Key Responsibilities:
  • Developing and optimizing SQL
    queries and stored procedures for Data Processing and Data Analysis.
  • Designing and building complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using SQL Server Integration Services (ETL) or other related technologies.
  • Implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS, or other related technologies.
  • Developing and implementing large-scale data processing and query optimization techniques using TSQL.
  • Implementing audit, balance, and control mechanisms in data solutions.
  • Experience with source control repos like GIT, TFVC, or Azure DevOps, including branching, and merging and implementing CICD pipelines for database and ETL workloads.
  • Working with Python and Pandas libraries to process semi-structured data sets, and load them to SQL Server DB.


Requirements:
  • Bachelors with 7+ or Masters with 5+ experience in Computer Science, Engineering, Math, or other quantitative field.
  • 7+ years of experience working with developing Batch ETL/ELT processes.
  • Strong understanding of DW concepts, including 3NF and Dimensional data models.
  • 5+ years of experience with Data Modeling techniques in Data Warehousing projects using any tool like Erwin, Visio, ER studio.
  • Experience working on Banking and Financial domain is preferred.
  • Experience with mentoring team members, guiding them to follow best practices.


About Diverse Lynx LLC
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence, and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Preferred Skills:
  • ETL Design Patterns
  • Optimal Data Flow mechanisms
  • SQL development best practices


  • Rosemont, California, United States Wintrust Full time

    Job Title: Senior Data Solutions EngineerWintrust is a financial holding company with a strong presence in the Chicago area, boasting approximately $62 billion in assets. Our company operates with a unique business model that sets us apart from others in the industry. As a Senior Data Solutions Engineer, you will play a crucial role in designing, developing,...


  • Rosemont, California, United States Wintrust Financial Full time

    Job Title: Senior Software Engineering SpecialistAt Wintrust Financial, we're committed to providing sophisticated technology and resources to our customers while focusing on service-based community banking. As a Principal Software Engineer, you'll play a crucial role in designing, architecting, developing, and maintaining applications that meet the evolving...


  • Rosemont, California, United States IT Associates Full time

    About IT AssociatesIT Associates is a growing analytics department seeking a talented Data Scientist to collaborate on strategic objectives and improve business performance. The successful candidate will design, scale, and support analytical products, working alongside data scientists, engineers, QA analysts, and business leaders.Estimated Salary: $120,000 -...


  • Rosemont, California, United States Popular Full time

    About UsPopular is a leading financial institution in Puerto Rico, with a rich history spanning over a century. We have evolved from a small bank to a large corporation offering a wide range of financial solutions and services to our customers across the United States, the Caribbean, and Latin America.Job DescriptionWe are seeking an experienced Software...


  • Rosemont, California, United States Multi-Color Corporation Full time

    We are seeking a highly experienced and skilled Senior Financial Strategist to join our team at Multi-Color Corporation.About the RoleAs a Senior Financial Strategist, you will be responsible for providing financial support to Operations leadership and plant General Managers. You will manage processes for financial forecasting, cost accounting, budgets, and...


  • Rosemont, California, United States Diverse Lynx Full time

    Job Title: MuleSoft Integration EngineerJob Location: Remote or OnsiteJob Description: We are seeking a highly skilled MuleSoft Integration Engineer to join our team. The ideal candidate will have experience working with Mule 4, Anypoint Platform, and Anypoint Studio. A strong background in Java/J2EE and integration knowledge is also required. Key...


  • Rosemont, California, United States Creative Financial Staffing Full time

    Senior Accountant Position in a Thriving Manufacturing CompanyCreative Financial Staffing is seeking an experienced Senior Accountant to handle a diverse range of responsibilities and be a key player in our finance department.The ideal candidate will have strong GAAP knowledge, 3+ years accounting experience preferably with Construction, Engineering, or...


  • Rosemont, California, United States Talent Solution Partners Full time

    Job Title: Senior Commercial Construction Project DirectorSalary Range: $75,000 - $110,000 per yearAbout the RoleTalent Solution Partners is seeking a seasoned Senior Commercial Construction Project Director to join our team of professionals. The ideal candidate will have 8+ years of experience in managing commercial construction projects for federal and...


  • Rosemont, California, United States AAOS Full time

    About the Role:We are seeking a highly skilled and experienced Senior Medical Research Program Manager to lead our research initiatives and drive innovation in medical research. As a key member of our team, you will oversee the development and implementation of research projects, manage relationships with external partners, and provide strategic guidance to...


  • Rosemont, California, United States Creative Financial Staffing Full time

    Senior Accountant Role OverviewOur client, a thriving mid-size manufacturing company near O'Hare, is seeking an experienced Accounting Supervisor to handle diverse responsibilities and be a key player in their finance department.Accounting Supervisor Responsibilities:Execute month-end accrual entries to ensure accurate subledger and general ledger...


  • Rosemont, California, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job Title: Lead Java DeveloperFutran Tech Solutions Pvt. Ltd. is seeking an exceptional Lead Java Developer to join our team and contribute to the successful delivery of our projects. As a key member of our development team, you will be responsible for leading the development of complex Java applications using Ephesoft SmartCaptureTM Document Automation...


  • Rosemont, California, United States Link Logistics Real Estate Holdco Full time

    Senior Legal Counsel, Investments Job Description Company OverviewLink Logistics Real Estate is a leading operator of last-mile logistics real estate. The company connects consumption, technology, and the supply chain across its portfolio, spanning over half a billion square feet.With more than 5 percent of U.S. GDP flowing through our spaces, we leverage...


  • Rosemont, California, United States Syntricate Technologies Full time

    About the RoleWe are seeking an experienced Mule 4 developer to join our team at Syntricate Technologies. As a key member of our development team, you will be responsible for designing, developing, and maintaining APIs using Mule 4.**Job Description:**As a senior-level Mule 4 developer, you will work closely with cross-functional teams to design, develop,...


  • Rosemont, California, United States Link Logistics Corp Full time

    About Link Logistics CorpLink Logistics Corp is a leading operator of last-mile logistics real estate, established by Blackstone in 2019. Our company connects consumption, technology, and the supply chain across its portfolio, spanning over half a billion square feet. With more than 5 percent of U.S. GDP flowing through our spaces, we leverage our scale,...

  • Data Engineer

    1 week ago


    Rosemont, United States Diverse Lynx Full time

    Sr.Data Engineer Rosemont,IL (5 Days Onsite) Contract/FulltimeJob Description Senior-Level Data Engineer: Bachelors with 7+ or Masters with 5+ experience in Computer Science, Engineering, Math or other quantitative field. 7+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class...


  • Rosemont, United States Wintrust Full time

    Wintrust is a financial holding company with approximately $62 billion in assets whose common stock is traded on the NASDAQ Global Select Market. Guided by its "Different Approach, Better Results" philosophy, Wintrust offers the sophisticated resources of a large bank while providing a community banking experience to each customer. Wintrust operates more...

  • Senior MDM Engineer

    3 weeks ago


    Rosemont, United States Wintrust Full time

    Wintrust is a financial holding company with approximately $62 billion in assets whose common stock is traded on the NASDAQ Global Select Market. Guided by its "Different Approach, Better Results" philosophy, Wintrust offers the sophisticated resources of a large bank while providing a community banking experience to each customer. Wintrust operates more...

  • Data Scientist

    1 month ago


    Rosemont, United States IT Associates Full time

    Fulltime Position Hybrid position with 2 days a week onsite in Rosemont, IL Our client is seeking a Data Scientist to join their established and growing analytics department. A successful Data Scientist will collaborate on strategic objectives and improve business performance by designing, scaling, and supporting a range of analytical and modeling products....

  • Data Scientist

    2 months ago


    Rosemont, United States IT Associates Full time

    Fulltime Position Hybrid position with 2 days a week onsite in Rosemont, IL Our client is seeking a Data Scientist to join their established and growing analytics department. A successful Data Scientist will collaborate on strategic objectives and improve business performance by designing, scaling, and supporting a range of analytical and modeling products....


  • Rosemont, United States Optomi Full time

    Senior Product Owner – Adobe AEMOptomi, in partnership with an industry leading food distributor, is seeking an experienced Senior Product Owner to join our team, focusing on driving the strategy, development, and execution of our digital marketing initiatives across various platforms. This role will work at the intersection of technology, marketing, and...

  • Engineer I

    3 weeks ago


    Rosemont, United States Culligan Full time

    Responsibilities: The Engineer I - Mechanical performs functions that lead to the improvement of current products, and the development of new products and components. This individual has basic knowledge of commonly-used engineering concepts, practices, and procedures. This role reports to the Engineering Director and will receive guidance from senior level...

  • Engineer I

    1 week ago


    Rosemont, United States Culligan Full time

    Responsibilities: The Engineer I - Mechanical performs functions that lead to the improvement of current products, and the development of new products and components. This individual has basic knowledge of commonly-used engineering concepts, practices, and procedures. This role reports to the Engineering Director and will receive guidance from senior level...


  • Rosemont, United States Libra Solutions Full time

    The Data Quality Analyst is responsible for ensuring the integrity, consistency, and accuracy of data across the organization. This role will work closely with cross-functional teams, including IT, Business Intelligence, Operations, and Product, to develop and implement data quality standards, metrics, and controls. The Data Quality Analyst will play a...


  • Rosemont, United States Mackie Consultants, LLC Full time

    Mackie Consultants, LLC, a leading consultant in Civil Engineering and Land Surveying located in Rosemont, IL, has an immediate opening for a Senior Civil Design Engineer to join our growing team. Selected candidate should possess knowledge of site grading, stormwater management, sanitary sewer design, water supply systems and roadway design for private and...


  • Rosemont, Illinois, United States AAOS Full time

    About the RoleWe are seeking a highly skilled Senior Digital Marketing Strategist to join our team at AAOS. As a key member of our marketing department, you will be responsible for developing and implementing digital marketing strategies that drive engagement, conversion, and revenue growth.ResponsibilitiesDevelop and execute comprehensive digital marketing...


  • Rosemont, United States CapB InfoteK Full time

    SRE Observability Engineer Job Description Observability engineer will build and maintain solutions for getting insights on infrastructure and services supporting applications with focus on logs metrics and application traces that improve Observability engineer will think about the problem end to end automation of data collection from common data sources...


  • Rosemont, United States Popular Full time

    General Description This position is responsible for participating in all phases of the development life cycle of new and existing business applications & Salesforce Platform and data Integration. Primary focus is on analysis, architecture, design, programming, testing and implementation. Responsible in understanding IT strategy, developing solution...


  • Rosemont, United States TalentCraft Full time

    Our Client is looking for a Security Cloud Engineer with a strong background in both cloud security and Terraform development to join their dedicated security team. The individual will be responsible for implementing robust security measures within cloud environments, ensuring compliance with industry standards, and automating security controls using...


  • Rosemont, United States Feldco Full time

    Senior Marketing Manager   Please Be Advised: This role is 100% on site and is located in Rosemont, IL. It is not available on a remote/hybrid basis.   About Feldco: Established almost 50 years ago, Feldco has always aimed to provide homeowners with the best value and experience in their home improvement projects. Known for our replacement windows,...


  • rosemont, United States Creative Financial Staffing Full time

    Senior AccountantOur Client is a thriving mid-size manufacturing company in the near O'Hare! They are seeking an experienced Accounting Supervisor to handle a diverse range of responsibilities and be a key player in our finance department. Accounting Supervisor Responsibilities include:Executing month-end accrual entries, ensuring accurate subledger and...


  • rosemont, United States Creative Financial Staffing Full time

    Senior AccountantOur Client is a thriving mid-size manufacturing company in the near O'Hare! They are seeking an experienced Accounting Supervisor to handle a diverse range of responsibilities and be a key player in our finance department. Accounting Supervisor Responsibilities include: Executing month-end accrual entries, ensuring accurate subledger and...


  • rosemont, United States Creative Financial Staffing Full time

    Senior AccountantOur Client is a thriving mid-size manufacturing company in the near O'Hare! They are seeking an experienced Accounting Supervisor to handle a diverse range of responsibilities and be a key player in our finance department. Accounting Supervisor Responsibilities include: Executing month-end accrual entries, ensuring accurate subledger and...


  • rosemont, United States Creative Financial Staffing Full time

    Senior AccountantOur Client is a thriving mid-size manufacturing company in the near O'Hare! They are seeking an experienced Accounting Supervisor to handle a diverse range of responsibilities and be a key player in our finance department. Accounting Supervisor Responsibilities include: Executing month-end accrual entries, ensuring accurate subledger and...


  • Rosemont, United States Link Logistics Corp Full time

    Link Logistics Real Estate ("Link") is a leading operator of last-mile logistics real estate. Established by Blackstone in 2019, the company connects consumption, technology, and the supply chain across its portfolio, which spans more than half a billion square feet. With more than 5 percent of U.S. GDP flowing through our spaces, we leverage our scale,...