Will work closely with our BI team and IT Management to help derive internal business intelligence reporting & development to create, improve and maintain ad hoc & automated reporting and dashboards.
Help teams on the technical design and implementation of applications using existing and emerging technology platforms
Help align with firm data management standards and ensure applications within the portfolio are in line with those standards
Write SQL queries, stored procedures and utilize SQL Server to generate reports and respond to requests from users for data
Work closely with other technology members to ensure quality of monitoring
Clearly communicate problem/resolution process to users or management
Contribute technical documentation and application procedures
Assure compliance to change management and security policies
Requirements
Bachelor’s degree in Computer Science, Information systems or equivalent
Working knowledge of ETL using SSIS or comparable tool
Knowledge of MS Access, MS Visual Studio, Crystal Reports or Datawatch Monarch is a plus.
7+ years of experience Database Analysis and/or Development experience with SQL Server, writing SQL statements and generating reports
3-5 years of experience in financial/banking industry a plus
Tech Stack
ETL
SQL
SSIS
Benefits
Must work well in a team environment
Must be able to interface with users and vendors
Must have sense of urgency and ownership to support financial applications, with architectural and system component knowledge preferred
Proficiency in interpersonal communication, presentation, problem solving and analytical skills