SSIS ETL Architect/Lead

  • Jacksonville, FL
  • Posted 3 hours ago | Updated 3 hours ago

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)

Skills

Extract
Transform
Load
Microsoft SSIS
Offshoring
Mentorship
Project Delivery
People Management
Management
Leadership
Data Warehouse Architecture
Documentation

Job Details

Note: Need Only , Who can work on W2 or 1099.

Position: SSIS ETL Architect/Lead Location: Jacksonville, FL - (Onsite) Duration: Long Term Contract

Job Summary:
Have 15 years of experience in design, develop SSIS packages
Have experience using AI tools
Should have experience writing stored procedures and views
Can lead offshore team
Take complete responsibility of project delivery.
Have very good understanding of data and good analytical skillset

Key Responsibilities: Architecture & Design: Design end-to-end ETL/data warehouse architecture, create data models (SQL Server/ other DBs), and define standards for data integration.
SSIS Development: Develop complex SSIS packages with error handling, logging, transformations (Derived Columns, Conditional Splits), and dynamic package execution.
Data Sourcing: Extract data from diverse sources (flat files, Oracle, legacy systems) and load into SQL Server/Data Warehouses.
Leadership: Mentor junior developers, lead technical discussions, provide single point of contact, and manage team strategy.
Performance & Optimization: Tune SQL queries, optimize indexes, manage database backups, and ensure efficient data flow.
Collaboration: Work with Business Analysts, DBAs, and stakeholders to gather requirements and explain discrepancies.
Documentation: Maintain technical specs, solution designs, and ETL process documentation.


Thanks & Regards
Mahesh

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Solios Corp