Talent.com
SSIS Developer
SSIS DeveloperPurple Drive • Raleigh, NC, United States
SSIS Developer

SSIS Developer

Purple Drive • Raleigh, NC, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Microsoft SSIS / SQL ETL Developer

Job Description

We are seeking an experienced Microsoft SSIS & SQL ETL Developer responsible for designing, developing, and maintaining enterprise ETL workflows. The ideal candidate will have strong hands-on experience with Microsoft SQL Server , SSIS , and end-to-end ETL pipeline development , ensuring high-quality data integration and processing across systems.

Key Responsibilities

1. Microsoft SSIS Development

  • Design, develop, and maintain ETL solutions using Microsoft SSIS .
  • Create complex data workflows using Control Flow, Data Flow, Script Tasks, Parameters, and Expressions.
  • Develop reusable SSIS templates and components to standardize ETL processes.
  • Build and automate incremental and full-load data pipelines.

2. SQL ETL Development

  • Develop SQL-based ETL processes using stored procedures, functions, views, and T-SQL scripts.
  • Optimize SQL ETL workflows for large datasets and high-performance execution.
  • Implement data transformations, validations, cleansing, and business rules within SQL and SSIS.
  • Work with relational databases, staging layers, and data warehouse structures.
  • 3. Data Integration & Management

  • Integrate data from SQL Server, flat files, APIs, Excel, XML / JSON, and cloud-based sources.
  • Ensure data integrity, quality, and accuracy across all ETL pipelines.
  • Conduct data profiling, validation, and reconciliation between systems.
  • 4. Deployment, Scheduling & Monitoring

  • Deploy SSIS packages to different environments and schedule jobs via SQL Server Agent .
  • Monitor ETL executions and troubleshoot failures, data issues, or performance bottlenecks.
  • Implement logging, auditing, and error-handling frameworks for reliable ETL solutions.
  • 5. Collaboration & Documentation

  • Work with data analysts, developers, and business stakeholders to gather and understand mapping requirements.
  • Translate business rules into technical ETL specifications.
  • Document ETL workflows, mapping documents, data lineage, and operational procedures.
  • Participate in code reviews and follow version-control best practices (Git / DevOps).
  • Required Skills & Qualifications

  • 3-8+ years of hands-on experience with Microsoft SSIS and SQL Server ETL development .
  • Advanced T-SQL programming skills (queries, joins, indexing, performance tuning).
  • Strong understanding of ETL architecture, data flow optimization, and best practices.
  • Experience working with data warehouses, star / snowflake schemas, and dimensional modeling.
  • Ability to handle large datasets and optimize ETL performance.
  • Strong analytical, debugging, and problem-solving skills.
  • Preferred Qualifications

  • Experience with the Microsoft BI stack (SSRS, SSAS).
  • Exposure to Azure SQL , Azure Data Factory (ADF) , or cloud-based ETL solutions.
  • Knowledge of CI / CD pipelines for database / ETL deployments.
  • Experience in domain-specific data pipelines (banking / financial, retail, healthcare, etc.).
  • [job_alerts.create_a_job]

    Developer • Raleigh, NC, United States

    [internal_linking.similar_jobs]
    Travel Nurse RN - ED - Emergency Department

    Travel Nurse RN - ED - Emergency Department

    Trustaff • Lillington, NC, US
    [job_card.full_time]
    Trustaff is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Lillington, North Carolina.Job Description & Requirements. As an Emergency Room RN, you'll provide...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Compliance Specialist

    Sr. Compliance Specialist

    Indivior • Raleigh, NC, United States
    [job_card.full_time]
    Compliance Specialist Title : Sr.Compliance Specialist Reports To : Head, Site Quality Location : Raleigh, NC Indivior is a global pharmaceutical company working to help change patients' lives by ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Travel Nurse RN - ED - Emergency Department

    Travel Nurse RN - ED - Emergency Department

    ALOIS Healthcare • Lillington, NC, US
    [job_card.full_time]
    ALOIS Healthcare is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Lillington, North Carolina. Job Description & Requirements.An Emergency Room Nurse is primaril...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Registered Nurse - Med / Surg Telemetry

    Travel Registered Nurse - Med / Surg Telemetry

    Premier Medical Staffing Services • Lillington, NC, US
    [job_card.permanent]
    Premier Medical Staffing Services is seeking a travel nurse RN Med Surg / Telemetry for a travel nursing job in Lillington, North Carolina. Job Description & Requirements.Premier Medical Staffin...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Technical Trainer

    Sr. Technical Trainer

    Qualys • Raleigh, NC, United States
    [job_card.full_time]
    Come work at a place where innovation and teamwork come together to support the most exciting missions in the world!.Our Training Team delivers world-class technical training for Qualys IT security...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Summer 2026 Engineer Intern

    Summer 2026 Engineer Intern

    Altec Industries, Inc. • Creedmoor, NC, US
    [job_card.full_time]
    Develop the next generation of equipment in a company that is a leader in the utility equipment industry.Altec's next world-class product. Altec specializes in the design, manufacture, sale, and ser...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SSIS Developer

    SSIS Developer

    Jconnect Inc • Raleigh, NC, United States
    [job_card.full_time]
    Below is the requirement with my client.Please let me know if you are available for this role.Proficient with ETL tools such as Microsoft SSIS. Analyze and develop strategies and approaches to impor...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Applications Systems Analyst Sr - Epic Cheers - Analytics

    Applications Systems Analyst Sr - Epic Cheers - Analytics

    UNC Health Care • Morrisville, NC, United States
    [job_card.full_time]
    Become part of an inclusive organization with over 40,000 teammates, whose mission is to improve the health and well-being of the unique communities we serve. UNC Health's Digital Health & Innovatio...[show_more]
    [last_updated.last_updated_30] • [promoted]
    CDL-A Drivers : Top Pay, Consistent Routes, Elite Fleet

    CDL-A Drivers : Top Pay, Consistent Routes, Elite Fleet

    Marten Transport • Wake Forest, NC, US
    [job_card.full_time]
    Earn Top Pay and Choose Your Home Time!.Apply Now or Call to Speak to a Recruiter!.We re proud to be recognized as an Elite Fleet by the Truckload Carriers Association for offering a best-in-class ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    SSIS developer

    SSIS developer

    CData Software • Raleigh, NC, United States
    [job_card.full_time]
    Proficient with ETL tools such as Microsoft SSIS.Analyze and develop strategies and approaches to import and transfer data between source, staging, and. ODS / Data Warehouse destinations.Designing and...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Nurse RN - Med Surg

    Travel Nurse RN - Med Surg

    HonorVet Technologies • Butner, NC, US
    [job_card.full_time]
    HonorVet Technologies is seeking a travel nurse RN Med Surg for a travel nursing job in Butner, North Carolina.Job Description & Requirements. We have nursing needs in a few locations, with spec...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Survey Field Intern

    Survey Field Intern

    Bolton & Menk, Inc. • Wake Forest, NC, United States
    [job_card.full_time]
    Bolton & Menk is now accepting applications for our 2026 summer internship season.As a Top Workplace, this is a fantastic chance to work with a talented team of professionals and make a lasting imp...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Quality Assurance Engineer

    Quality Assurance Engineer

    Ultra Maritime, LLC • Wake Forest, NC, United States
    [job_card.full_time]
    Unleash the Power of Multi-Mission Excellence : Safeguarding the Seas for the World's Navies.Step into a world where cutting-edge technology meets unparalleled expertise. Ultra Maritime pioneers deli...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Workday Security Administrator (Senior HRIS Analyst)

    Workday Security Administrator (Senior HRIS Analyst)

    Twenty80 LLC • Raleigh, NC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Workday Security Administrator (Senior HRIS Analyst).The administrator will build and manage security roles and permissions, safeguard data accuracy, and partner with HR, IT, and leadership to refi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SSIS Developer

    SSIS Developer

    Diverse Lynx • Raleigh, NC, United States
    [job_card.full_time]
    Location : Raleigh, NC(Onsite).Must Have Technical / Functional Skills.Proficient with ETL tools such as Microsoft SSIS.ODS / Data Warehouse destinations. Designing and developing SSIS / SQL ETL solutio...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel CT Tech - $2,653 to $2,948 per week in Glenwood Springs, CT

    Travel CT Tech - $2,653 to $2,948 per week in Glenwood Springs, CT

    AlliedTravelCareers • Glenwood Springs, CT, US
    [job_card.full_time]
    AlliedTravelCareers is working with Prime Time Healthcare to find a qualified CT Tech in Glenwood Springs, Connecticut!.Now Hiring : Allied Healthcare CT - Glenwood Springs, CO.Contact us for Pay In...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    GIS Manager

    GIS Manager

    Chesapeake Utilities Corporation • Dunn, NC, United States
    [job_card.full_time]
    Hybrid - must reside in or be willing to relocate to one of our service territories (DE, MD, PA, OH, VA, NC, GA, FL).The Manager, GIS oversees the team responsible for all GIS related functions acr...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Bid Management Specialist

    Bid Management Specialist

    A-Line Staffing Solutions LLC • Raleigh, NC, US
    [job_card.full_time]
    Location : Raleigh, NC or Orlando, FL (Hybrid).Note : This is a W2 contract role; C2C, 1099, & 3 rd party candidates WILL NOT be considered. We are looking for a strategic and process-driven Bid Manag...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]