Sr. SQL Developer

Sr. SQL DeveloperDuration: 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.QualificationsBachelor's degree or higher in technology field or related field preferred3-5 years of practical experience with SSIS, SQL, SSRSPractical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggersExperience with SSIS development and SSRS reports (preferred)Interest in working with complex data sets and analytic technologies such as Power BIAbility to create Functions/Views/Stored ProcsExperience with complex queries including use of CTEs, table variables, merge and dynamic SQLExperience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversionExperience executing SSIS packages via SQL Server Job AgentExperience 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.