Job Description
The Investment Decision Support team is seeking an experienced SQL Developer / Tester with strong database, programming, and analytical skills to actively participate in the following scope of work :
Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed. Activities may include :
- Development - SQL Development support to include creation of stored procedures or underlying queries.
- Provide support in the design, development, and implementation of ETL packages with SQL Server Integration Services (SSIS).
- Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine performance enhancements for long running queries.
- Data Manipulation - Provide alternative options to existing data manipulation techniques.
- Examples would be converting Excel manipulation activities into SSIS packages that reduce process / cycle time of data preparation.
- SQL Development Processes - Review existing development processes and provide recommendations on how to enhance core development activities (i.e., Code Promotion, Code Reviews).
Testing – Develop test plans and cases and thoroughly test reports and workflows.
Required Skills
5+ years of experience in SQL database development and programming3+ years in a QA / testing roleExperience with SQL Server Integration ServicesExperience writing technical documentation (requirements, process maps, etc.)Excellent communicator and ability to produce clear and concise documentationDemonstrated experience working in a team environmentDemonstrated experience working independently with only high-level guidanceAdditional Preferred SkillsExperience with automation tools such as Power AutomateExperience with data governance best practices / proceduresInvestment / financial market industry experienceMust have :
5 years of experience with SQL database development and programming3 years of experience with QA / testing3 years of experience with SSIS3 years of experience with writing technical documentation1 years experience with automation tools such as Power Automate