Description

Position Summary

As an ETL SSIS Software Engineer, you will be responsible for designing, developing, and maintaining ETLprocesses using SQL Server Integration Services (SSIS) to extract, transform, and load data from varioussources into our data warehouse or data lake. This role requires expertise in data integration, SQL, SSISdevelopment, and database concepts. The candidate will work closely with Product Owners tounderstand business requirements, design efficient ETL solutions, and ensure the reliability andperformance of data pipelines.

Responsibilities

Delivery of Enterprise Applications:

• Understand business requirements and perform technical implementations by leveragingknowledge 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) fromvarious sources to target databases.

• Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSISpackages 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 theminto ETL workflows and data mappings.

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

• Document ETL processes, data mappings, technical specifications, and best practices forreference 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 stableand 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, backloggrooming, and retrospectives.

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

RequirementsEducation:

• 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 verbalcommunication.

• Excellent diligence.

• Relentless passion and commitment to operational excellence, delivering within scope, on time, andwithin 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 futuremaintenance.

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

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 anegligible 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 orequivalent work areas for more than 70% of the time.

#HP1

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)