SonSoft Inc. Logo

SonSoft Inc.

Lead ETL Architect (No H1B)

Posted 3 Days Ago
Be an Early Applicant
In-Office
Deerfield, IL, USA
Senior level
In-Office
Deerfield, IL, USA
Senior level
Lead the intake and management of ETL/integration demand, define and document solution architectures, perform gap analysis, guide platform build-out and run support, liaise with business and architects, and influence technical and financial decisions across enterprise integration technologies.
The summary above was generated by AI
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

As background, this client has been working with us and internal recruiting to fill this role for a LONG time. Previously, the client was looking for someone who could both technically lead the team specific to SAG technologies and also work with the business.

Two things have changed: 1) the span of control of the team increased from SAG to include the other technologies listed in the job description, and 2) he has been unsuccessful in finding someone who was both the best technical architect on the team and also had manager qualities. He is now open to lesser capabilities on the technical, as long as they have the manager.

I WOULD TARGET CURRENT/ FORMER SR. MANAGERS/ DIRECTORS OF INTEGRATION/ SOA. PREFERABLY, WERE TECHNICAL AT SOME POINT IN THEIR CAREER, BUT MOVED INTO MANAGEMENT. WITH THIS TARGET, YOU SHOULD BE ABLE TO ACCESS THE APPROPRIATE TALENT AT THIS PAY RATE.

Lead ETL Architect

Client's is seeking a Lead ETL Architect as a key member of their Center of Expertise for Integration Technologies. This consultant will be primarily responsible for leading the demand intake/ management process with the business leaders and other IT groups related to managing the demand for the design, build and ongoing support of new ETL architectures. They also will interact extensively with the team of architects supporting these technologies. Expertise in one of more of the following integration technology areas is required:

-- ETL - Datastage, AnInito, Talend (client is moving from AbInitio to Talend as their primary ETL tool)

The overall team is responsible for addressing any architecture impacts and defining technology solution architectures focusing on infrastructure, logical and physical layout of the systems and technologies not limited to hardware, distributed and virtual systems, software, security, data management, storage, backup/recovery, appliances, messaging, networking, work flow, interoperability, flexibility, scalability, monitoring and reliability including fault tolerance and disaster recovery in collaboration with Enterprise Architect(s). Additionally, responsible for the build-out and ongoing run support of these integration platforms.

Skills Set

· Possession of fundamental skills of a solution architect with ability to inquire and resolve vague requirements

· Ability to analyze existing systems through an interview process with technology SMEs. Does not need to be the SME.

· Takes a holistic view and communicate to others to be able to understand the enterprise view to ensure coherence of all aspects of the project as an integrated system

· Perform gap analysis between current state and the future state architecture to identify single points of failure, capabilities, capacity, fault tolerance, hours of operation (SLA), change windows,

· Strong verbal and written communication with proven skills in facilitating the design sessions.

· Able to influence, conceptualize, visualize and communicate the target architecture.

· Able to communicate complex technical or architecture concepts in a simple manner and can adapt to different audiences

· Ability to work independently and market architecture best practices, guidelines, standards, principles, and patterns while working with infrastructure and technology project teams.

· Ability to document end-to-end application transaction flows through the enterprise

· Ability to document the technology architecture decision process, and if required develop relevant templates

· Resolve conflicts within infrastructure and application teams, business units and other architects

· Identify opportunities to cut cost without sacrificing the overall business goals.

· Ability to estimate the financial impact of solution architecture alternatives / options

· Knowledge of all components of an enterprise technical architecture.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Contract job opportunity for you.
  2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, OPT-EAD & TN-Visa can apply.
  3. No H1B candidates, please.
  4. Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.

Similar Jobs

2 Hours Ago
Hybrid
Chicago, IL, USA
99K-232K Annually
Mid level
99K-232K Annually
Mid level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead client engagements to optimize supply chain planning using Kinaxis and analytics. Manage projects, mentor staff, design inventory and distribution strategies, implement SCM technology, and ensure performance and compliance.
Top Skills: Data AnalyticsKinaxisSupply Chain Management Software
2 Hours Ago
Hybrid
Chicago, IL, USA
99K-232K Annually
Mid level
99K-232K Annually
Mid level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead strategy engagements for asset and wealth management clients: analyze market trends, develop and implement growth and operational strategies, manage client accounts, lead and mentor teams, conduct competitive research, and drive business transformation while promoting innovation and maintaining professional standards.
2 Hours Ago
Hybrid
Chicago, IL, USA
77K-202K Annually
Senior level
77K-202K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead supply chain planning and Kinaxis-focused optimization efforts: analyze processes, recommend technology and analytics-driven improvements, manage client relationships, lead teams, and drive cost, responsiveness, and operational excellence.
Top Skills: Data AnalyticsKinaxisSupply Chain Management Software

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account