Information Technology Senior Business Intelligence Developer

Download Job Description

DESCRIPTION:

The successful candidate will have a minimum of 7-10 years hands-on experience with database programming, development and administration, and 3-5 years practical experience with relational and dimensional database design and architecture.  The candidate will actively participate in all phases of the database application and reporting life-cycle.  They will create and maintain advanced SQL stored procedures, design and manage complex ETL processes, multi-dimensional cubes and create tabular models for analytical reporting.  Additional responsibilities will include supporting and troubleshooting an existing SQL Server environment including query optimization, performing capacity planning, and SSAS cube maintenance.

 RESPONSIBILITIES:

  • Understand the analytical and reporting requirements of portfolio accounting and investment teams
  • Design data models for efficient data access, reporting, and data validation during application design and construction phases
  • Produce high-quality analytics products
  • Develop advanced SQL Queries for implementing application business logic using MS best practices
  • Design and manage ETLs and jobs
  • Query performance monitoring and tuning of databases and database server environments
  • Adherence to source control, version management, product release best practices
  • Serve as subject matter expert for self-service products and provide training and assistance to product end users
  • Development and administration of job history, trending and error notification alerts and information to users

 REQUIRED QUALIFICATIONS:

  • Foundational understanding of portfolio accounting and finance
  • MS-SQL Server 2012-2016 SQL programming (5-7 years) and strong proficiency with T-SQL
  • Robust knowledge and experience with relational and dimensional data modeling
  • Experience with SQL Server Analysis Services with proficiency in DAX and MDX a must
  • Experience building and maintaining a SQL Integration Services environment
  • Exposure to SQL Server Reporting Services report writing and instance maintenance
  • Demonstrated experience and problem-solving skills to troubleshoot and resolve technical problems

 DESIRED QUALIFICATIONS:

  • Experience in financial services ideal
  • Exposure to Azure Data Warehouse, Azure Analysis Services, Azure SQL Database, and Azure Data Lake
  • Capacity planning and management of SQL server security

EDUCATION & CERTIFICATION:

  • B.S. degree in an information systems discipline or comparable work experience
  • Microsoft MCTS Certification highly desirable

AEW Capital Management is an affirmative action-equal opportunity employer.

Email Resume