ETL Developer (SSIS) - Remote at Beacon Hill Staffing Group, LLC in Salem, Oregon

Job Description:

Position Overview: We are looking for an experienced ETL Developer to build out and optimize specific components of our new hire automation process using SQL Server Integration Services (SSIS). This role involves integrating web services and REST APIs, handling error management and logging, understanding database architecture, and performing DB object creation and maintenance. Additionally, experience with PowerShell to manage Active Directory changes within SSIS packages is essential.



Key Responsibilities:

1. 
   SSIS Development:
   

• Design, develop, and implement SSIS packages to automate and streamline the new hire process.


• Integrate web services and REST APIs into SSIS packages to facilitate data exchange and process automation.

Error Handling and Logging:

• Implement robust error handling and trapping mechanisms within SSIS packages to ensure reliability and data integrity.


• Set up detailed logging to monitor package execution and troubleshoot issues effectively.

Database Architecture:

• Develop an understanding of the existing database architecture to ensure seamless integration and data flow within the SSIS packages.


• Perform DB object creation and maintenance, including writing and executing DDL scripts as needed.

PowerShell Integration:

• Utilize PowerShell within SSIS packages to automate changes in Active Directory as part of the new hire process.


• Develop and maintain PowerShell scripts to support and enhance automation workflows.

Collaboration and Documentation:

• Work closely with stakeholders to gather requirements and understand the automation needs.


• Document SSIS package designs, configurations, and troubleshooting steps to ensure clarity and knowledge sharing.

Qualifications:

• Proven experience with SQL Server Integration Services (SSIS) and developing complex ETL solutions.


• Strong understanding of web services and REST APIs, with hands-on experience integrating these into SSIS packages.


• Proficiency in error handling, trapping, and logging within SSIS.


• Experience with database architecture and DB object creation/maintenance (DDL scripting).


• Practical experience using PowerShell, especially for automation tasks related to Active Directory.

Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.


If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/


Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.


Company Profile:


Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.


Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.


Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com .


We look forward to working with you.


Beacon Hill. Employing the Future™
Apply Now