BI Report Developer

About the role

The Reporting Analyst designs, develops, and maintains reports and dashboards sourced from a cloud data warehouse. The position maintains current data‑warehouse dashboards and reports, interfaces with TI support teams, and provides direct business‑user support.

Responsibilities

• Translate business needs into high‑level technical designs for BI solutions.
• Apply rapid prototyping and iterative development methodologies to keep solutions aligned with business needs.
• Design and implement new features and enhancements to the existing Cloud Data Warehouse.
• 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 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 issues (30%).

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 solutions (required).
• 2+ years of experience with cloud platforms such as AWS or Azure (required).
• 1+ year of experience building entity‑relationship diagrams and dimensional modeling (preferred).
• 2+ years of experience creating documentation, data dictionaries, and diagrams that communicate architecture and detailed design to varied audiences (preferred).
• 2+ years of experience building dashboards and scorecards using AWS QuickSight, Tableau, and/or Power BI; design and development of KPIs (required).
• Familiarity with BI architecture and data modeling of dimensional OLAP cube solutions in SQL Server Analysis Services, including MDX (preferred).
• 2+ years of experience designing and implementing dimensional star schemas with multiple fact groups in multi‑dimensional OLAP databases and columnar databases (preferred).
• Experience with AWS cloud services (required).
• Experience with dashboard tools such as Tableau, Power BI, or Amazon QuickSight (required).
• Successful track record designing and developing solutions using BI theories and best practices (required).
• Knowledge of AWS services such as Redshift and S3 for building BI solutions (required).
• Knowledge of prototyping and proof‑of‑concept mechanisms (required).
• Effective communication with stakeholders, team members, and other technology teams.
• Ability to read and understand software requirements.
• Ability to adapt quickly to changing priorities in a rapidly growing organization.
• Self‑starter attitude with a willingness to learn new systems.

Benefits

• Free Play & half‑price food.
• Health, dental, and vision insurance.
• 401(k) with team‑member match.
• Free mental‑well‑being platform for qualifying members.