Senior SQL Developer

SEI Investments SQL Server Developer

SEI 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 speed

Job Description:

• 8 or more years of related experience; or equivalent combination of education and experience
• Experience 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 procedures
• Performance tune complex queries and query optimization
• Developing Dynamic SQL and stored procedures
• Using indexes to speed up the SQL queries
• Experience in creating database schemas that represent and support business processes
• Extensive knowledge and hands on experience designing and developing objects and components of relational and non-relational database
• Experience with SSRS report development
• Full Text Searching
• Developing ERD – both physical and logical
• Strong experience with Agile methodologies
• Knowledge and understanding of SDLC, with a strong preference for Agile experience
• Skill for writing reusable functions, views and database objects
• Excellent written/verbal communication, presentation, and listening skills
• Excellent collaboration/teamwork skills
• Understanding of fundamental design principles for building a scalable application
• Familiar with various design and architectural patterns