Job Description

LOCATION: Remote, preferably on the East Coast as we'd like to meet in person for social events.

SUMMARY: InvestEdge is seeking a database specialist with expert knowledge in relational data modeling, querying, and data analysis. This role requires expert knowledge of working with MSSQL and Postgres databases, and can write complex queries, stored procedures, and views.

OUR IDEAL CANDIDATE:

• Has likely worked as a senior data developer or data architect role, and also understands database administration concepts such as indexing strategies, backup and fault-tolerance strategies, and how to organize and secure data at rest.
• Has a background in financial services and understand how financial markets and investing work.
• Has a CPA/CFA (or similar background) with the ability to write advanced SQL should be a shoe-in.
  
  

This role will work with InvestEdge's senior data architect to implement new solutions as well as improve existing ones. Also, the role will be working with large data sets and large database footprints and should understand concepts such as performance tuning, SQL Injection, and data security best practices.

In addition to an emphasis on data manipulation and storage, the candidate will also work on other aspects of the application including UX and middle-tier concerns relating to the presentation, use, and manipulation of data. The ideal candidate is a well-rounded developer that is comfortable in any layer of the application, even as their focus is data and the persistence of that data.

ROLES AND RESPONSIBILITIES:

• Work with the senior data architect to implement data routines in a financial services environment.
• Create new queries, views, and stored procedures for a large existing relational data set.
• Debug and troubleshoot logical issues in database code.
• Debug and troubleshoot performance issues in database code.
• Serve as a subject matter expert on a large in-house enterprise database model.
• Understand the business domain of the application.
• Work in an Agile environment on a cross-functional team.
  
  

Required Skills:

• T-SQL (DDL, Stored Process, Views, CTEs, etc)
• VCS (Git, SVN, etc)
  
  

Bonus Skills:

• Candidates with a CPA/CFA or other financial services background are preferred.
• Candidates who understand web technologies and can program in other languages in addition to SQL will be preferred. JavaScript/ES6/NodeJS preferred.
• VS Code, SSMS, and other IDEs.
• CI/CD experience with integrating database changes into deployment models.