Jobs

Job Description

Title: Senior SQL SSIS Developer

Location: Philadelphia, PA
Duration: 6-12 Months project with a probable extension

Job Description:

Looking for a Senior SQL SSIS Developer to help drive continue integration between various data management program. Current Business Growth brings more data, more extracts, more transformations, more loads, and more puzzles that we get to solve. The individual has to be a hands-on developer with 8+ years of experience with delivering enterprise-level systems.

Responsibilities:

Understand business requirements and translate them into specific software requirements
Create and maintain high functioning ETL projects for inbound, outbound, and internal datasets.
Design and develop SQL queries, stored procedures, functions, and scheduled tasks to manipulate data in a repeatable and automated manner.
Ready to take ad-hoc request from business for data extracts and various reports.
Design and execute test scripts and test scenarios
Perform all data handling in accordance with enterprise guidelines, and with security and privacy requirements in mind.
Support your team and peers through collaborative coding, design sessions, and peer code review

Requirements:

8+ years experience in ETL development
Experience should include working with business team as well as technical resources
Demonstrated experience in developing creative solutions to technology challenges
Solid technical background with hands-on experience in ETL and/or software development, SQL queries, and database technologies
Experience with Microsoft data technologies, including SQL Server, Visual Studio, SSIS, and SSRS
Strong documentation skills (e.g. requirements, test scripts, project status, management presentations, etc.)
Data analysis experience using Excel and relational databases
Experience with the software development life cycle
Independent worker who takes the initiative to identify and react to new opportunities and projects
Excellent written and oral communication skills.

Preferred:

Experience working with Azure Data Factory a plus!
Programming and scripting experience in C# and/or VB
Experience with Postgres a plus
Working within healthcare or other regulated industry
Microsoft Visio, Microsoft Project, Microsoft Access experience

Please note: Not accepting candidates submitted by other staffing firms or agencies at this time.

Applicants must have an unrestricted right to work in the United States. Applicants must be authorized to work for ANY employer in the US. We are unable to sponsor or take over sponsorship of employment Visa at this time.