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