BI Reporting Analyst, TPO Data & Insights

The BI Reporting Analyst will be responsible for developing and fulfilling reporting needs for Technology Strategic Enablement’s (TSE) products and services. The Analyst will collaborate with Product owners and teams to understand requirements for information, and then create new or modify existing BI reports to deliver against those needs. Candidates must have strong data visualization skills, experience developing complex reports based on data from multiple sources and have a passion for telling stories with data. Expertise in report development using Power BI and SQL queries is required. Experience working with Tableau, Jira, Microsoft Azure or Fabric, Snowflake data warehousing is preferred. CANDIDATE PROFILE, * Collaborate with TSE Product Owners and Product Managers to address reporting and analytics requirements

• Elicit and document business requirements for metrics, report design, and dashboards
• Translate business requirements into technical reporting specifications and develop wireframes
• Use expertise to help define metrics with stakeholders to ensure best practices are followed
• Maintain backlog stories to reflect work progress
• Analyze large datasets to see relationships, patterns, trends and provide actionable insights
• Design, develop and maintain pipelines, data models, reports and dashboards primarily in PowerBI. Reports will have multiple data sources, complex queries, views, stored procedures, and automation features
• Lead reporting demos and design reviews (minimum viable product) to stakeholders to validate requirements
• Develop, execute, and document test plans for Power BI reports and dashboards
• Perform ongoing monitoring and refinement of reports
• Performance tune BI reports and dashboards, recommend and implement tuning techniques
• Provide technical support for existing reports, dashboards, or other tools
• Troubleshoot data quality issues and defects to determine root cause
• Seek opportunities to standardize and automate data calculations to enable efficient and consistent reporting.
• Complete special projects, as assigned

• Undergraduate degree or equivalent experience/certifications
• 5+ years overall experience in data analytics or related field
• 3+ years’ experience in development, testing and implementation of sophisticated reports, and dashboards using Power BI
• 3+ years’ experience querying and manipulating large quantities of data using SQL
• 3+ years’ experience storytelling with data to provide effective visualizations of information and actionable insights for decision-making, * Experience responding to user requests and formulating responses using both business and technical knowledge
• Comfortable with concepts around extract transform and load (ETL) of data into standard aggregated manner for reporting
• Experience developing reports and dashboards using Tableau
• Experience programming in DAX or Python
• Experience with Microsoft Azure or Fabric
• Experience working with Snowflake data warehouse
• Experience working with JIRA data
• Ability to independently manage small projects while also contributing to larger initiatives
• Strong interpersonal, written, and oral communication skills
• Agile experience is a plus

All positions offer a 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. Click to learn more. Full-time positions also 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 and educational assistance. Washington Applicants Only: Employees will accrue paid sick leave, 0.077 PTO balance for every hour worked and be eligible to receive a minimum of 9 holidays annually. Marriott HQ is committed to a hybrid work environment that enables associates to Be connected. Headquarters-based positions are considered hybrid, for candidates within a commuting distance to Bethesda, MD; candidates outside of commuting distance to Bethesda, MD will be considered for Remote positions. About the Team: Marriott International is the world’s largest hotel company, with more brands, more hotels and more opportunities for associates to grow and succeed. Be where you can do your best work, begin your purpose, belong to an amazing global team, and become the best version of you.

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Te…