• Provide first hand support to business units with respect to their adhoc data and reporting requests • Works with internal and external customers and suppliers to understand the business requirements behind requested computing initiatives • Develops and deploys reports and dashboards in SSRS and Power BI • Provide inputs on data sources and quality into high-level data flow architecture • Design and develop ETL and integration solutions • Implement design patterns and industry best-practices to develop secure robust integration applications • Actively collaborate with developers and other project resources • Questions existing processes and procedures (both administrative and technical), and offers suggestions and opinions for continuous improvement. • Communicates technical ideas and concepts in non-technical language to the business. • Takes directions from and works with senior members of the development team on projects and tasks • Adheres to and promotes the environmental, health & safety policies of AFL. • Ability to effectively communicate with and educate business users and mid/senior management about data warehousing/business intelligence technology in business terms.

• Responsible for the building, implementation, and ongoing delivery of SitusAMC’s enterprise business intelligence strategy • Manage the processes involved in business intelligence and may manage staff • Oversee the approach and technology to disperse critical information and insights to the organization and clients • Partner with business and technology team members to expand the business intelligence infrastructure of operational systems, data lakes and data warehouses • Manage the software development lifecycle of the business intelligence platform • Advocate the usage of data and business intelligence across the organization • Create complex t-SQL statements and stored procedures and queries to extract data • Build dashboards, data extracts, and visualizations

• Provide day-to-day administrative support for the benefits programs across all Pyramid Global Hospitality locations. • Completion and maintenance of ongoing benefits-related tasks and assisting with ongoing training to support the property HR Partners and associates. • Excellent customer service to all property HR teams, property associates, and Home Office staff related to all benefits questions, enrollment issues, member doctor/facility situations, etc. • Acts as first-level support / triage for complex benefits issues. • Assist with and occasionally lead specific training and education sessions related to the company’s benefit offerings. • Liaises with all benefit carriers, insurance brokers, and properties to ensure Benefit Programs function properly. • Perform day-to-day benefits administration tasks, including, but not limited to, dependent verification, evidence of insurability, data issues, Affordable Care Act (ACA) compliance, cobra administration etc. • Collaborate with Total Rewards Analysts in tracking and processing all benefit invoices. • Works with Corporate Accounting to ensure Hotels are billed appropriately. • Assists in education of benefit offerings for all new Home Office staff. • Assists with Hotel Due Diligence and Acquisitions. • Other duties and responsibilities as assigned.

• Implement enterprise storage architecture for Power BI data, reports and dashboards. • Design and implement security structure for Power BI data, reports and dashboards. • Work independently with end users to design and build Power BI dashboards and reports. • Create change deployment strategy for Power BI reports that incorporates source control. • Train existing report developers to build reports and dashboards. • Suggest best practices for storage and security of reports and dashboards. • Suggest best practices for design of reports and dashboards.