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.