SQL/Business Intelligence Developer
CHMWarnick (“CHMW”) is the leading provider of hospitality asset management and strategic advisory services, delivering material positive impact on asset value and returns for lodging real estate owners and investors. CHMW’s services and expertise encompass all facets of hotel investment, and offer strategies proven to optimize financial performance and asset value throughout every stage of ownership.
CHMW has advised ownership groups on a combined total of more than 350 hotels, representing nearly every major brand and asset class, including destination resorts, convention center headquarter hotels, select-service hotels, urban landmarks and conference centers. Today, CHMW actively oversees hotel portfolio and single-asset investments collectively valued at more than $15 billion.
Description of Position
CHMW is an entrepreneurial and dynamic firm offering an exciting opportunity and immediate opening for a SQL/Business Intelligence Developer to support the administration and development of our internal database and business intelligence platform, ProphIT. The role will focus on CHMW’s back-end relational database but will also have exposure to all stages of the data lifecycle and thus requires an individual who is comfortable learning new technologies and broadening their skill set as needs develop.
Responsibilities
• Support the firm’s analytic needs through data sourcing, building ETL/ELT, administrating/developing relational databases, administrating/developing OLAP databases, administrating web applications, and providing user support.
• Optimize queries, jobs, SSIS packages, and Azure system architecture to improve performance and scalability.
• Help to standardize and document code, object naming conventions, and system architecture.
• Learn new technologies and programming languages independently in response to data and reporting challenges which require unique solutions.
• Take an active interest in the Asset Management process to understand business user requirements and create new ideas for system expansion.
• Help develop ProphIT as a source of competitive advantage for CHMW.
Basic Qualifications
- Bachelor’s or advanced degree from an accredited university. Position is major agnostic for an individual with the appropriate skillset but some disciplines that could be well suited for the role include: Information Science, Operations Research, Computer Science, Accounting, Business, Finance, Real Estate, Economics, Statistics, or Hospitality
- Strong quantitative ability and aptitude for quantitative learning
- Ability to effectively communicate technical concepts to business users
- Strong verbal and written communication skills
- Flexibility to work after normal business hours and on weekends as needed
- Ability to prioritize and work on multiple projects simultaneously
- Strong financial modeling, analytical, and business writing skills
- An ability to identify, collect, process, and organize large amounts of information and data, which may be limited or incomplete
- Candidates must be authorized to work in the United States
- Hospitality experience or background is a plus
Technical Qualifications
- Minimum technical qualifications include exposure to the following technologies/languages: T-SQL, SSIS, VBA, SSAS Tabular (DAX), and at least one business intelligence product
- Experience working with Azure. Preferred exposure to the following Azure resources: Virtual Machines, Azure SQL Server, Azure Analysis Services, Logic Apps, Runbooks, and Azure Automation
- Additional skills/technologies that would be attractive: MDX, SSRS, R, Python, NodeJS, JavaScript, C#, C++, Linux (RedHat Distribution), SharePoint, knowledge of networks and server administration
Base salary and incentives will be commensurate with experience, and other benefits are included in the compensation package. If you meet the above requirements and are interested in exploring a career opportunity CHMW, please submit a cover letter and resume to humanresources@CHMWarnick.com with SQL/Business Intelligence Developer in the subject line.
CHMW is an equal opportunity employer.