Software Engineer – ETL SSIS

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.

#HP1