Demo

Software Engineer - ETL SSIS

Neptune
Duluth, GA Full Time
POSTED ON 2/17/2025
AVAILABLE BEFORE 4/28/2025

Position Summary

As an ETL SSIS Software Engineer, you will be responsible for designing, developing, and maintaining ETL

processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various

sources into our data warehouse or data lake. This role requires expertise in data integration, SQL, SSIS

development, and database concepts. The candidate will work closely with Product Owners to

understand business requirements, design efficient ETL solutions, and ensure the reliability and

performance of data pipelines.

Responsibilities

Delivery of Enterprise Applications :

  • Understand business requirements and perform technical implementations by leveraging

knowledge of enterprise applications and technical expertise.

  • Strong understanding of data warehouse / data lake implementation methodologies / concepts
  • Ralph Kimball, Bill Inmon, Dimension modelling, etc.).

  • Understand master data management concepts.
  • Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for onpremises and hybrid environments.
  • Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) from
  • various sources to target databases.

  • Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS
  • packages for data quality and integrity.

  • Design and implement data integration and orchestration workflows using SSIS.
  • Collaborate with business stakeholders to understand data requirements and translate them
  • into ETL workflows and data mappings.

  • Perform performance tuning and optimization of ETL processes to meet scalability and
  • performance requirements.

  • Document ETL processes, data mappings, technical specifications, and best practices for
  • reference and future maintenance.

  • Stay updated on industry best practices, tools, and technologies related to ETL, data integration,
  • and cloud-based data solutions.

    Support of Enterprise Applications :

  • Provide end user support, system maintenance / security and incident resolution to ensure stable
  • and resilient business operations of enterprise applications.

  • Ensure enhancements, changes and systems configurations are appropriately documented.
  • Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog
  • grooming, and retrospectives.

  • Maintain professional and technical knowledge by attending educational workshops, reviewing
  • professional publications; develop personal networks, and participate in professional groups.

    Requirements

    Education :

  • Bachelor's degree in business, computer science, or a related field of study, or equivalent experience
  • SQL Server Certification
  • Any Cloud DB Certification
  • Experience :

  • 5 years of relevant experience.
  • People Skills :

  • Strong problem-solving and analytical skills.
  • Comfortable as both a team member and individual contributor / independent thinker.
  • Pragmatic problem-solving and decision-making skills with excellent written and verbal
  • communication.

  • Excellent diligence.
  • Relentless passion and commitment to operational excellence, delivering within scope, on time, and
  • within budget to exceed internal customer expectations.

    Technical Skills :

  • Design, develop, and maintain relational databases and data integration solutions.
  • Optimize data systems and build them from the ground up.
  • Manipulate XML / JSON data and implement REST / SOAP web services and APIs.
  • Write and optimize complex SQL queries for data analysis and reporting.
  • Implement data security measures to protect sensitive information.
  • Design and test data warehouse solutions and ETL / ELT processes.
  • Implement effective metrics and monitoring processes to track data quality and performance.
  • Use code and project management tools for version control, issue tracking, and collaboration.
  • Document technical and functional aspects of software components for reference and future
  • maintenance.

  • Provide troubleshooting and support for all environments, including development, testing, and
  • production.

    Preferred Qualifications :

  • Experience with QAD or SAP ERP
  • Location : Duluth, Georgia

    Physical Requirements : Sedentary Work - Exerting up to 10 pounds of force occasionally and / or a

    negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects.

    Working Conditions : Generally agreeable working conditions such as those found inside offices or

    equivalent work areas for more than 70% of the time.

    Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities

    The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Software Engineer - ETL SSIS?

    Sign up to receive alerts about other jobs on the Software Engineer - ETL SSIS career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $97,257 - $120,701
    Income Estimation: 
    $123,167 - $152,295
    Income Estimation: 
    $97,257 - $120,701
    Income Estimation: 
    $123,167 - $152,295
    Income Estimation: 
    $146,673 - $180,130
    Income Estimation: 
    $176,149 - $220,529
    Income Estimation: 
    $77,657 - $95,021
    Income Estimation: 
    $97,257 - $120,701
    Income Estimation: 
    $123,167 - $152,295
    Income Estimation: 
    $146,673 - $180,130
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Neptune

    Neptune
    Hired Organization Address Tallassee, AL Full Time
    Position Summary: As a member of the Data Governance and Analytics team, the Lead Data Steward will be responsible for m...
    Neptune
    Hired Organization Address Seattle, WA Full Time|Part Time|Intern
    Be part of a team passionate about building a great auto-remediation platform About Us : We are a startup founded by ex-...
    Neptune
    Hired Organization Address Tallassee, AL Full Time
    Position Summary The Test Engineering Manager is responsible for leading the development, implementation, and support of...

    Not the job you're looking for? Here are some other Software Engineer - ETL SSIS jobs in the Duluth, GA area that may be a better fit.

    Software Engineer – ETL SSIS

    Neptune, Duluth, GA

    AI Assistant is available now!

    Feel free to start your new journey!