SEI Investments SQL Server DeveloperSEI Investments is looking to backfill a SQL Server Developer position. The team requires very strong SQL querying skills, advanced skills, and the ability to create complex SQL queries from scratch for an internal, custom-built reporting system. They do not use an enterprise reporting tool like PowerBI or Tableau or similar.
This role is for a very experienced person with SQL querying (complex/advanced) and T-SQL.What we are not looking for:People too ETL heavy (they do no ETL in this role).Someone who is too strong a developer with lots of.Net and doing some SQL.Data Engineers who are moving data only.Location: Oaks, PA (they will accept remote living in EST or CST but there will be a preference for candidates within a 2 hour drive for occasional on-site meeting) Duration: SOW is already approved for entire 2023 – extendable from there Start Date: 1/16 or 1/23 – pending interview process speedJob Description:8 or more years of related experience; or equivalent combination of education and experienceExperience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)Advance SQL development skills like:Creating complex queries and stored proceduresPerformance tune complex queries and query optimizationDeveloping Dynamic SQL and stored proceduresUsing indexes to speed up the SQL queriesExperience in creating database schemas that represent and support business processesExtensive knowledge and hands on experience designing and developing objects and components of relational and non-relational databaseExperience with SSRS report developmentFull Text SearchingDeveloping ERD – both physical and logicalStrong experience with Agile methodologiesKnowledge and understanding of SDLC, with a strong preference for Agile experienceSkill for writing reusable functions, views and database objectsExcellent written/verbal communication, presentation, and listening skillsExcellent collaboration/teamwork skillsUnderstanding of fundamental design principles for building a scalable applicationFamiliar with various design and architectural patterns