To submit your resume, please send to
Please note job title in subject line.


Business Intelligence Developer Manager

Position Description

Title: Business Intelligence Developer Manager

Department: Finance

ReportsĀ To: Treasurer/Corporate Vice President, Finance

Function: The Business Intelligence Developer/Manager is responsible for overseeing the business intelligence platform for a publicly-traded real estate investment trust investing in hotels. This new position will be responsible for working with various business units to identify, design and implement solutions for extraction and integration of data from various sources for the purposes of reporting, decision support and analysis. The successful candidate shall possess extensive experience in data management and analytics platforms. The successful candidate will also demonstrate strong experience with data modeling (Conceptual, Relational and Dimensional) and possess experience that demonstrates a strong understanding of the data warehouse lifecycle, star schema, multi-dimensional models, and BI reporting. This position will work with all levels of the organization to help them with their information needs.


  • Source and transform data from internal and external data sources through tools and programming methods.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Troubleshoot and resolve data quality issues and maintain high level of data accuracy in the data being reported.
  • Use data to tell a story that is useful to support operational and financial departments.
  • Identify actionable insights, suggest recommendations by effectively communicating findings to cross functional groups
  • Design, develop, and deploy reports using Cognos
  • Create and publish Cognos Framework Manager Models to meet business requirements and preparation of business view.
  • Create advance reports using COGNOS Query Studio and Report studio,
  • Manage security of reports and models based on role
  • Design, develop and deploy prompted reports and dashboards in a Cognos and environment
  • Implement error handling, auditing and reconciliation and balancing mechanisms in ETL processes
  • Assist in the data and analytics strategy for the company and work with the senior management team to set the strategic objectives for the company and measurement through KPIs
  • Distill information in an easy to present and digestible manner to non-technical personnel
  • Scheduled monthly/weekly/daily reports to run automatically onto the Dashboar


  • Understanding of Dimensions, Cubes, Rules, Processes and Chores
  • Understanding of TM1 User Interface Templates (Perspectives Forms)
  • Strong problem solving and project management skills
  • Excellent communication and interpersonal skills


  • Degree in Mathematics, Statistics, or related field (Econometrics, Computer Science
  • TM1 Certified Developer or Administrator


  • Five (5+) years experience in Business Intelligence Tools including Microsoft SQL Server Analysis Services (MSAS), SSIS, Cognos Tools such as Query Studio, Metric Studio, Analysis Studio, Cognos Connection, Framework Manager
  • Experience with Cognos and SQL Skills including advanced query techniques
  • Experience with at least one programming language such as Python, Perl, Java.
  • Progressive experience in Design, Architecture and Development of IT Applications specializing in Data warehousing and Business Intelligence Tools in Production and Non-Production Environments.
  • Experience with ETL tools like Microsoft SQL Server Analysis Services
  • Experience in in OLTP/OLAP system study, analysis and E-R modelling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
  • Design of TI Load processes
  • TM1 Security and Admin Tasks
  • Hospitality experience desired but not required


This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbentĀ in this position. Employee(s) will be required to follow any other job related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments.

A review of this position has excluded the marginal functions of the position that are incidental to the performance of fundamental job duties. All duties and responsibilities are essential job functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbent(s) will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities.

This document does not create an employment contract, implied or otherwise, other than an "at will" relationship.


Site Designed by DC Web Designers, a Washington DC web design company