Business Analyst and Data Analyst Job at J M Group Inc, Ontario, CA

  • J M Group Inc
  • Ontario, CA

Job Description

We are hiring for a Business Analyst and Data Analyst . This role focuses on business analysis, data analytics, Power BI dashboard development, SQL, and regulatory compliance reporting.

The ideal candidate will have 6 8 years of experience combining business analysis and data analytics with strong Power BI, SQL, and Excel skills.

What you bring

  • 6 8 years of experience in Business Analysis and Data Analysis

  • Strong hands-on experience with Power BI, including data modeling, DAX, Power Query, and dashboard development

  • Advanced SQL skills, including joins, views, stored procedures, and query optimization

  • Expert knowledge of Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, Power Query, and Macros

  • Experience with dashboard design, KPI reporting, and data visualization

  • Knowledge of data warehousing concepts and ETL processes

  • Experience preparing and validating regulatory and compliance reports

  • Experience with requirement gathering, stakeholder management, and business process analysis

  • Strong analytical and problem-solving skills

  • Ability to translate business requirements into technical solutions

What you'll do

  • Gather, analyze, and document business requirements from stakeholders

  • Analyze data to identify trends, patterns, and business insights

  • Design, develop, and maintain interactive Power BI dashboards and reports

  • Extract, transform, and analyze data using SQL from multiple sources

  • Prepare management reports, KPI scorecards, and executive dashboards

  • Develop and automate reporting processes using Excel

  • Generate and validate regulatory and compliance reports

  • Perform data quality checks and root cause analysis for data discrepancies

  • Work with business users, compliance teams, and technology teams on reporting requirements

  • Translate business requirements into functional specifications and reporting solutions

  • Support UAT and successful implementation of reporting solutions

  • Create process documentation, BRDs, and reporting guidelines

Nice to have

  • VBA

  • Advanced Excel automation and reporting experience

Job Tags

Similar Jobs

Fixari Family Dental

Dental hygienist Job at Fixari Family Dental

 ...and your dependents. Competitive paid time off for full-time team members, which increases...  ...holidays and 3 floating holidays. Gym Membership Reimbursement, for any gym you...  ...at Fixari Family Dental Full-time and Part-time are available Pay: $47.00 - $52.00... 

California Institute of Technology

Research Scientist Job at California Institute of Technology

 ...part of the diverse Caltech community.Job SummaryThe Research Scientist will work to constrain and characterize the effusive volcanic...  ...duties as assigned.Basic QualificationsPh.D. in Radar and Remote Sensing.5 years of experience in analyzing Mars sounder data.Knowledge... 

Commodore Perry Estate

Reservation Agent Job at Commodore Perry Estate

 ...Reservation Agent Embark on a journey of refined hospitality as a Reservations Agent at Commodore Perry Estate and Bowie House, where every...  ...Assisting and ensuring effective guest challenge resolution. Working closely with fellow guest service team members and other... 

Lancesoft INC

Nurse Supervisor - Maternal & Child Health Job at Lancesoft INC

 ...Job Description Job Description Title: Nurse Supervisor - Maternal Child Health Type: Full Time/Permanent - Direct Hire Location: Brooklyn, NY, US, 11206 Shift Time: 8:00 AM-4:30 PM Salary: $150,000 Annually plus benefits Purpose of Position: Under... 

Cityview Helicopter Tours

Sr. Leadership Job at Cityview Helicopter Tours

 ...topaccount managersand existing entrepreneurs. Be your own boss, but have the power of athriving startup.We're a next-generation platform.We are looking for a remote account manager to help facilitate communication between our clients and our team The Perfect...