Business Intelligence Analyst

Rhythm is in search of a Business Intelligence Analyst to join our team in Irvine, CA. Rhythm is an alternative Australian surf lifestyle brand specializing in the design, sale and marketing of authentic, on trend surf lifestyle products. Rhythm creates inspirational Men's and Women's apparel, as well as swimwear and accessory products. With our brand ethos being, "The Sound of Change" we are looking for a like-minded individual to join our growing team that is helping pave new ways to operate within our distribution channel. Job Summary:We are seeking a talented Business Intelligence (BI) Analyst with expertise in Power BI, Excel, and ETL processes. This role will be pivotal in supporting key business decisions by designing, developing, and maintaining BI solutions that drive insights into sales, inventory, supply chain, and customer behavior. You'll play an integral role in transforming raw data into actionable intelligence that improves operational efficiency and supports our business goals.Key Responsibilities:Power BI and Excel Development:Design, develop, and maintain interactive Power BI dashboards for sales, inventory, merchandising, and supply chain analytics.Create data visualizations to track key metrics such as sell-through rates, stock levels, revenue, and customer behavior.Optimize Power BI and Excel reports for performance and a seamless user experience.ETL & Data Integration:Develop and manage ETL processes to extract, transform, and load data from various systems, including ERP platforms (e.g., Cin7, Xero), POS systems, eCommerce (Shopify), and supplier databases.Automate data pipelines to ensure smooth integration and data flow across multiple platforms.Maintain data accuracy and consistency across different business functions.Data Analysis & Reporting:Analyze sales trends, customer purchasing behavior, and demand forecasting to support merchandising and inventory planning.Provide insights into product performance, regional sales trends, and markdown strategies.Collaborate with teams in buying, planning, marketing, finance, and operations to understand and fulfil reporting needs.Develop predictive models to optimize stock levels and reduce overstocks or stock outs.Database & Data Warehousing:Manage and organize data sources, including SQL databases, cloud storage, and APIs.Design and maintain data models, including star and snowflake schemas.Work with data engineers to ensure efficient database performance and easy data accessibility.Required Skills:Expertise in Power BI and Excel (DAX, Power Query, custom visuals, and report optimization).Experience with data modelling (star schema, snowflake schema, normalization, and denormalization).Strong knowledge of ETL processes and data integration.Proficiency in managing SQL databases, cloud storage, and APIs.Ability to communicate and collaborate effectively with teams across various business functions.

Created: 2025-03-03