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.
