BI Reporting Analyst, TPO Data & Insights

Marriott•Bethesda, MD

21h•$87,300 - $150,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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