BI Report Developer

The purpose of the Reporting Analyst role is the design, development, and maintenance of Reports and dashboards sourced from Cloud data warehouse. The position is responsible for working to maintain the current data warehouse dashboards and reports. This role will interface with TI support teams and provide direct business user support.

Job Responsibilities

• Translate business needs into high-level technical designs for BI solutions. Apply rapid prototyping and iterative development methodologies as appropriate to ensure the solution keeps pace with business needs. Design and implement new features and enhancements to the existing Cloud Datawarehouse. Develop and manage BI report scheduling and monitoring (40%)
• Manage performance on the dashboards. Design and develop QuickSight dashboards to meet business needs. Design and support Analysis Services OLAP cubes. Design and implement new features and enhancements to the existing dimensional OLAP data warehouse data model (30%)
• Participate in near and long-term capacity planning for BI. Participate in the implementation and maintenance of hosting hardware and software, including virtual technologies. Research and resolve data integrity and performance needs (30%)

Critical Skills & Experience Requirements

• Bachelor’s Degree in Computer Science (or related field) or equivalent experience (Required)
• 2+ years of experience in Cloud Data Warehouse (Required)
• 2+ years of designing and coding ETL/Dashboard experience (Required)
• 2+ years of experience working with Cloud platforms such as AWS, Azure (Required)
• 1+ years of experience in building entity relationship diagrams and Dimensional modeling (Preferred)
• 2+ years of experience creating documentation, data dictionaries, and diagrams that communicate overall architecture and detailed design to varied audiences (Preferred)
• 2+ years of experience in Dashboards and Scorecards building using tools such as AWS QuickSight, Tableau, and/or PowerBI. Design and development of KPIs. Familiarity with BI Architecture data modeling of dimensional OLAP cube solutions in SQL Server Analysis Services, including querying multi-dimensional data with MDX (Preferred)
• 2+ years of familiarity in designing and implementing dimensional Star Schemas with multiple fact groups in multi-dimensional OLAP databases and Columnar Databases (Preferred)
• Experience in AWS Cloud Services (Required)
• Experience working with dashboard tools such as Tableau/Power BI/Amazon QuickSight (Required)
• Successful track record in designing and developing solutions using BI theories & best practices (Required)
• Knowledge of using AWS services such as AWS Redshift, S3 in building BI solutions (Required)
• Knowledge of prototyping & proof of concept mechanisms (Required)
• Effectively communicate with stakeholders, team members, and across other technology teams.
• Read and understand software requirements. Ability to adapt and adjust to quickly changing priorities to fulfill the needs of a rapidly growing organization
• Ability to be a self-starter and dig in and learn new systems.

BENEFITS

Free Play & 1/2 price food! Health, dental, vision, 401(k) team member match, free mental well-being platform – and that’s just for starters for those who qualify. View team member benefits here.

ADAThe above statements cover what are generally believed to be principal and essential functions of the job. Specific circumstances may allow or require some incumbents assigned to the job to perform a different combination of duties.EEO StatementTopgolf is a global sports and entertainment community and is committed to equal opportunity and is firmly committed to preventing discrimination and harassment, including sexual misconduct, based on legally protected diversity characteristics (such as race, color, religion, national origin, sex, age, disability, sexual orientation, gender identity or expression, family status, citizenship, genetic information and veteran status) in its application and hiring processes and in its employment decisions.  As an affirmative action employer, Topgolf also takes steps to prevent retaliation and to create a respectful, equitable and inclusive environment for our Guests, Associates, business partners, vendors, and the communities we serve.Topgolf is an equal opportunity affirmative action employer and administers all personnel practices without regard to race, color, religion, sex, age, national origin, disability, sexual orientation, gender identity or expression, marital status, veteran status, genetics or any other category protected under applicable law.Topgolf Entertainment Group does not accept unsolicited agency resumes. Please do not forward unsolicited agency resumes to our website, employees or Human Resources. Topgolf will not pay fees for unsolicited agency resumes and will not be responsible for any agency fees associated with unsolicited resumes. Unsolicited resumes received will be considered property of Topgolf Entertainment Group and will be processed accordingly without fee.Topgolf participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.