JOB SUMMARY

Reporting Services team will build and maintain CEC & other company reporting. This role will include design, build, and maintaining of the reporting pipeline and platform. The CEC Reporting Analyst will work directly with the CEC stakeholders to determine reporting requirements to support business operations and performance management. The CEC Reporting Analyst will work with stakeholders to gather requirements and build visualizations to help the business identify, diagnose, and action the performance information. The CEC Reporting Analyst will work with data engineers, business analysts and other operational stakeholders.

CANDIDATE PROFILE

Required Education and Experience

• Bachelor’s degree required, preferably in Computer Science, Information Systems or related major.

• 2 years of continuous professional experience in analytical/reporting role and/or comparable continuous experience working with Marriott business analytics data

• 2 years of continuous use and experience with Intermediate to Advanced level SQL Query Skills in at least one tool: SQL Server, DB2, Oracle, MySQL, SOQL, T-SQL,Apex , NoSQL, Postgre SQL
• 2 years of continuous use and experience with SQL Server Reporting Services (SSRS)
• 2 years consistent use and experience with Microsoft Office in a professional role: Excel, PowerPoint, Word
• 2 years consistent use and experience with SQL for data gathering, analysis and presentations
• Experience in visualizations and reporting techniques
• Ability to identify appropriate analytical approaches depending on business needs

Preferred Experience

• Knowledge of Marriott and the hospitality industry
• 2 years’ experience in finance, lodging and/or consulting related discipline
• 2 years’ experience in a multi-call center operations environment
• Consulting and project management skills highly valued
• Marriott sales, finance and/or operations analysis experience
• Experience with Marriott’s business applications including Productivity Systems (e.g., telephony systems, IEX, MARSHA ) and Technical Systems (e.g., CTI, IVR)
• 2 years’ experience with business intelligence platforms for data reporting and analysis (e.g., PowerBI, Tableau)
• Experience with general-purpose programming languages (e.g., Python, R)

CORE WORK ACTIVITIES

• Communicate with CEC stakeholders and BA leadership to gather requirements and timeline for reporting requests
• Conduct routine reviews of existing reporting to standardize and optimize speed/functionality
• Ensure reports are accessible by appropriate user groups, and in a structure that is easily accessible
• Partner with Data Services team to construct ETLs to bring in data
• Prepare the detailed systems specifications for translations into structured applications with the necessary interfaces into other systems or across platforms
• Build SQL code to collect relevant and reliable data
• Use Alteryx to automate workflows and generate audits
• Build Visual Studio layout to align with stakeholders’ functional and aesthetic needs
• Create Stored Procedures to enable modular, efficient reporting data-flow
• Update and rebuild existing reporting, as business needs change
• Organize, coordinate and conduct system integration testing
• Work with leadership and stakeholders to identify and resolve report inconsistencies and errors
• Identify any underlying, fundamental gaps or design flaws and escalate to leadership
• Create documentation to help facilitate future research
• Develop datasets and reports to meet business unit reporting and data needs

MANAGEMENT COMPETENCIES

Leadership

• Adaptability - Maintains performance level under pressure or when experiencing changes or challenges in the workplace.
• Communication - Conveys information and ideas to others in a convincing and engaging manner through a variety of methods.
• Problem Solving and Decision Making - Identifies and understands issues, problems, and opportunities; obtains and compares information from different sources to draw conclusions, develops and evaluates alternatives and solutions, solves problems, and chooses a course of action.
• Professional Demeanor - Exhibits behavioral styles that convey confidence and command respect from others; makes a good first impression and represents the company in alignment with its values.

Managing Execution

• Building and Contributing to Teams - Participates as a member of a team to move toward the completion of common goals while fostering cohesion and collaboration among team members.
• Driving for Results - Sets high standards of performance for self and/or others; assumes responsibility for work objectives; initiates, focuses, and monitors the efforts of self and/or others toward the accomplishment goals; proactively takes action and goes beyond what is required.
• Planning and Organizing - Gathers information and resources required to set a plan of action for self and/or others; prioritizes and arranges work requirements to accomplish goals and ensure work is completed.

Building Relationships

• Coworker Relationships - Interacts with others in a way that builds openness, trust, and confidence in the pursuit of organizational goals and lasting relationships.
• Customer Relationships - Develops and sustains relationships based on an understanding of customer/stakeholder needs and actions consistent with the company’s service standards.
• Global Mindset - Supports employees and business partners with diverse styles, abilities, motivations, and/or cultural perspectives; utilizes differences to drive innovation, engagement and enhance business results; and ensures employees are given the opportunity to contribute to their full potential.

Generating Talent and Organizational Capability

• Talent Management - Provides support and feedback to help individuals develop and strengthen skills and abilities needed to accomplish work objectives.

Learning and Applying Professional Expertise

• Applied Learning - Seeks and makes the most of learning opportunities to improve performance of self and/or others.
• Business Acumen - Understands and utilizes business information to manage everyday operations and generate innovative solutions to approach business and administrative challenges.
• Technical Acumen - Understands and utilizes professional skills and knowledge in a specific functional area to conduct and manage everyday business operations and generate innovative solutions to approach function-specific work challenges.
• Basic Competencies - Fundamental competencies required for accomplishing basic work activities.
  • Basic Computer Skills - Uses basic computer hardware and software (e.g., personal computers, word processing software, Internet browsers, etc.).
  • Mathematical Reasoning - Adds, subtracts, multiplies, or divides quickly, correctly, and in a way that allows one to solve work-related issues.
  • Oral Comprehension - Listens to and understands information and ideas presented through spoken words and sentences.
  • Reading Comprehension – Understands written sentences and paragraphs in work related documents.
  • Writing - Communicates effectively in writing as appropriate for the needs of the audience.

California Applicants Only: The salary range for this position is $64,480.00 to $131,705.00 annually.

Colorado Applicants Only: The salary range for this position is $61,613.00 to $119,734.00 annually.

New York City & Westchester County, NY Applicants Only: The salary range for this position is $74,550.00 to $131,705.00 annually.

Washington Applicants Only: The salary range for this position is $65,478.40 to $131,705.00 annually. In addition to the annual salary, the position will be eligible to receive an annual bonus. Employees will accrue 0.4616 PTO balance for every hour worked and eligible to receive minimum of 7 holidays annually. 

All locations offer coverage for medical, dental, vision, health care flexible spending account, dependent care flexible spending account, life insurance, disability insurance, accident insurance, adoption expense reimbursements, paid parental leave, educational assistance, 401(k) plan, stock purchase plan, discounts at Marriott properties, commuter benefits, employee assistance plan, and childcare discounts. Benefits are subject to terms and conditions, which may include rules regarding eligibility, enrollment, waiting period, contribution, benefit limits, election changes, benefit exclusions, and others.