Sr. SQL Developer

Sr. SQL Developer

Duration: 6 Months + Location: Doylestown, PA - (Remote is fine, but will need to travel few times to Office)

This contract position will play a critical role supporting. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions SSIS and SSRS.

As a SQL Developer, you will:

• Design, code and test programs using the Microsoft SQL Server platform.
• Create business logic, reports, exports and other data related output.
• Learn continuously, manage your work independently and seek guidance from senior developers when needed.
• Use best practice coding standards in a fast-paced and agile environment.
• Work in a team environment that includes collaborating with Product Owners, Stakeholders, and Software Developers.

Qualifications

• Bachelor's degree or higher in technology field or related field preferred
• 3-5 years of practical experience with SSIS, SQL, SSRS
• Practical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggers
• Experience with SSIS development and SSRS reports (preferred)
• Interest in working with complex data sets and analytic technologies such as Power BI
• Ability to create Functions/Views/Stored Procs
• Experience with complex queries including use of CTEs, table variables, merge and dynamic SQL
• Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion
• Experience executing SSIS packages via SQL Server Job Agent
• Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables, parameters, package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks.