Job Description :
ESSENTIAL DUTIES
Work closely with the Business Intelligence Manager to create, maintain, and administer data best practices in support of the firm’s operations
Support SQL Database and SSIS/ETL development, quality control, and reporting efforts
Provide input into overall development/implementation plan and document database builds and changes, perform SQL designs, table designs, and stored procedures work
Ability to help architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions
Assist in the translation of logical to physical design, develop comprehensive database architecture, implementation and upgrade plans and assist in definition of database standards, policies, and procedures
Lead data requirements, architecture review, and modeling sessions
Serve as contact for projects within the team, interfacing with data providers, application development staff, and Executive Management
Assist in data loading, security, capacity planning and backup and recovery
Optimizing database performance, queries, and stored procedures
Production patch/upgrade management
Research, plan, design, and develop new solutions for the firm
Develop new enhancements, reports, and features for new and/or existing data products
Research problems associated with existing products as necessary, recommend appropriate solutions, and resolve issues
Work directly with department managers to develop ad hoc reports, models, and tools used to manage the portfolio
Perform other duties as requested by Supervisor