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 position is 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.Responsibilities:Source and transform data from internal and external data sources through tools and programming methodsUse ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouseTroubleshoot and resolve data quality issues and maintain high level of data accuracy in the data being reportedUse data to tell a story that is useful to support operational and financial departmentsIdentify actionable insights, suggest recommendations by effectively communicating findings to cross functional groupsDesign, develop, and deploy reports using CognosCreate and publish Cognos Framework Manager Models to meet business requirements and preparation of business viewCreate advance reports using COGNOS Query Studio and Report studioManage security of reports and models based on roleDesign, develop and deploy prompted reports and dashboards in a Cognos environmentImplement error handling, auditing and reconciliation and balancing mechanisms in ETL processesAssist 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 KPIsDistill information in an easy to present and digestible manner to non-technical personnelSchedule monthly/weekly/daily reports to run automatically onto the DashboardSkills:Understanding of Dimensions, Cubes, Rules, Processes and ChoresUnderstanding of TM1 User Interface Templates (Perspectives Forms)Strong problem solving and project management skillsExcellent communication and interpersonal skillsEducation/Training:Degree in Mathematics, Statistics, or related field (Econometrics, Computer Science)TM1 Certified Developer or AdministratorExperience: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 ManagerExperience with Cognos and SQL Skills including advanced query techniquesExperience with at least one programming language such as Python, Perl, JavaProgressive experience in Design, Architecture and Development of IT Applications specializing in Data warehousing and Business Intelligence Tools in production and non-production environmentsExperience with ETL tools like Microsoft SQL Server Analysis ServicesExperience 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 modellingDesign of TI Load processesTM1 Security and Admin TasksHospitality experience desired but not requiredThis 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.by Jobble