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

Stratton Mountain

Carpenter Job at Stratton Mountain

 ...employees POSITION SUMMARY Perform general carpentry work to include building, installing, repairing and maintaining of structures, furniture, doors, windows, etc. as directed. Operate associated power and hand tools and equipment. This is a full-time year-round benefit... 

Belcan

Senior Electrical and Instrumentation Designer Job at Belcan

 ...Job Title: I&E Designer II Location: Ponca City, OK Zip Code: 74602 Start Date: Right Away Job Type: Contract Keywords:...  ...: * Will work on Refinery Technical Services (RTS) projects electrical or instrument drawings * Work as part of a design team to put... 

Ripple Effect Consulting LLC

Entry Level Construction Material Tester Job at Ripple Effect Consulting LLC

 ...ENTRY LEVEL CONSTRUCTION MATERIAL TESTER (No Prior Experience Necessary) Location: Denver, CO Job Type: Full-Time Starting Pay: $20.00/hr + Growth Through Certifications Ready to Build More Than Just a Job? Are you stuck in a hands-on position with no clear... 

Winslow School Department

Full Time Custodian- Winslow Junior High School Job at Winslow School Department

 ...Full Time Custodian- Winslow Junior High School Position: Custodian Shift Schedule: 1:00pm- 9:00pm Location: Winslow Public Schools...  ...Requirements: Valid Drivers license High School Diploma or equivalent Ability to lift approximately 50 lbs and shovel... 

Compass Maryland

House Manager Job at Compass Maryland

 ...profit organization that supports individuals with developmental and intellectual disabilities. We are accepting applications for House Manager positions in Silver Spring, MD to manage the day-to-day activities of the residential facility of Compass. This Position...