Business Analyst Job at 24 Seven Talent, Irvine, CA

ZEduUS9MLzhwdXB4SjdtWFp3K0dSWmFZM3c9PQ==
  • 24 Seven Talent
  • Irvine, CA

Job Description

We’re looking for an experienced Business Intelligence (BI) Analyst with deep expertise in Power BI , Excel , and ETL processes to support data-driven decision-making across the organization. This role will focus on designing and maintaining BI solutions that deliver clear, actionable insights across key functions such as sales, inventory, supply chain, and customer analytics. The ideal candidate will transform complex data sets into intuitive dashboards and strategic reporting tools that drive profitability and operational efficiency.

Key Responsibilities:

Power BI & Excel Reporting:

  • Develop and maintain interactive Power BI dashboards for sales, inventory, merchandising, and supply chain performance.
  • Build data visualizations and tools to monitor key metrics, including sell-through, stock levels, revenue, and customer behavior.
  • Optimize Power BI and Excel reports for scalability, performance, and user experience.

ETL & Data Integration:

  • Design and manage robust ETL processes to extract, transform, and load data from various platforms including ERP (Cin7, Xero), POS, Shopify, and supplier databases.
  • Automate data pipelines to ensure seamless, real-time integration across systems.
  • Ensure data integrity, consistency, and reliability across all business functions.

Analytics & Strategic Insights:

  • Analyze sales trends, customer behavior, and product performance to support buying, planning, and inventory decisions.
  • Deliver insights into markdown strategies, demand forecasting, and regional sales patterns.
  • Collaborate cross-functionally with teams in marketing, finance, operations, and planning to address evolving reporting needs.
  • Develop predictive models to improve inventory accuracy, reduce stockouts, and increase sell-through.

Data Management & Architecture:

  • Manage and optimize data sources including SQL databases, cloud-based storage, and APIs.
  • Build and maintain well-structured data models using star and snowflake schemas.
  • Partner with data engineers to improve data accessibility and ensure efficient data warehousing practices.

Required Skills & Experience:

  • Advanced proficiency in Power BI and Excel (including DAX, Power Query, custom visuals, and report optimization).
  • Solid understanding of data modeling techniques (star/snowflake schemas, normalization, denormalization).
  • Experience working with data from ERP, POS, and eCommerce systems.
  • Strong analytical thinking with a keen eye for identifying trends, anomalies, and opportunities.
  • Let me know if you’d like a version tailored to a specific industry or company voice!

Job Tags

Similar Jobs

BPO Recruit

Senior Actuarial Analyst (INSURANCE SECTOR ONLY) Job at BPO Recruit

 ...We are recruiting for a Top Tier ICT organisation. Require an experienced Sr. Actuarial Analyst MUST HAVE INSURANCE EXPERIENCE focusing on risk monitoring, profitability analysis, and other key actuarial functions. This role involves conducting in-depth reviews of... 

JRN Associates

Power BI Developer/ Data Analyst Job at JRN Associates

 ...managers with limited technical expertise. This role requires strong proficiency in Microsoft Power BI and a solid background in data analytics. Key Responsibilities Report Development : Design and create Power BI reports and dashboards that visualize QA test... 

Frette

Marketing Coordinator Job at Frette

 ...Frette is seeking a Marketing Coordinator to join our team, based out of our NYC office, working a hybrid schedule, 3 days in office...  ...slept beneath its sheets. Today, its legacy lives on in luxury hotels, private residences, yachts, and jets, remaining dedicated to outfitting... 

Ultimate Staffing

Inside Sales Representative Job at Ultimate Staffing

Position: Inside Sales Representative Location: San Diego, CA (92127) Pay Rate: $20 per hour plus opportunity to make commission Hours: Monday through Friday, 7 AM to 3:30 PM. Position Overview Ultimate Staffing Services is actively seeking a dynamic Inside...

Onward Search

Marketing Manager [78456] Job at Onward Search

 ...Join our client's team as a Marketing Manager, where you will serve as the creative asset liaison, collaborating with Creative, Publicity,...  ...qualify for our benefits package, you must work over 30 hours per week and the length of assignment must be a minimum of 10 weeks...