SonSoft Inc. Logo

SonSoft Inc.

Lead ETL Architect (No H1B)

Reposted One Month 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

32 Minutes Ago
Remote or Hybrid
USA
Senior level
Senior level
Machine Learning • Payments • Security • Software • Financial Services
Owns the vision, customer focus, and product backlog for a near-real-time data product. Prioritizes work based on business value, leads backlog grooming, communicates product direction, and partners with Scrum Masters and development teams to ensure delivery aligns with client requirements and business objectives.
Top Skills: Agile DevelopmentData VisualizationScrumUx Design
2 Hours Ago
Remote or Hybrid
Chicago, IL, USA
88K-118K Annually
Senior level
88K-118K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Senior Account Executive drives new client acquisition and revenue growth within designated markets and client segments. Responsibilities include managing prospective and existing client relationships, identifying opportunities, delivering consultative sales presentations, advancing leads through close, expanding existing accounts, coordinating team-selling efforts, supporting strategic pursuits, and sharing market intelligence. The role also contributes to marketing and business development activities while maintaining professional and industry knowledge.
2 Hours Ago
Remote or Hybrid
Chicago, IL, USA
66K-89K Annually
Mid level
66K-89K Annually
Mid level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Provides technical consulting and solution implementation for client IT environments. Handles complex escalations, assesses Microsoft and cloud infrastructures, develops technology roadmaps and security improvement plans, leads maintenance reviews, identifies modernization opportunities, and manages project scope, budgets, timelines, and risks. The role requires regular client communication, occasional on-site travel, and collaboration with internal technical teams to deliver practical technology solutions.
Top Skills: Active DirectoryAntivirusAzure Active DirectoryEndpoint DevicesFirewallsLocal NetworksMicrosoft 365AzureServersSharepointSwitchesVirtualized Environments

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