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

bzFsa0V4MVZNNlNRWXlhNkJHa2RtdTFnQXc9PQ==
  • 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

RoadSafe Traffic Systems

Project Manager- Traffic Control Job at RoadSafe Traffic Systems

 ...Project Manager- Traffic Control Title: Project Manager- Traffic Control Classification: Exempt About the Organization RoadSafe Traffic Systems is the largest national provider of traffic safety products and services in the United States. RoadSafe serves... 

Penhall Company

Administrative Assistant (Full-Time) Job at Penhall Company

 ...comprehensive benefits package which includes medical, dental, vision, and life/AD&D/LTD...  ...comprehensive benefits. This is an onsite position; remote work is not offered for this role....  ...time, production data, and payroll records, including certified payroll, in compliance... 

Confidential

Business Operations Analyst Job at Confidential

job summary: Join Our Client, an industry leader in Tualatin, OR! We are seeking a Business Operations Analyst skilled in process improvement, Excel, and Power BI to drive data-driven operational excellence. location: Tualatin, Oregon job type: Contract salary... 

ChristianaCare

Medical Assistant I, Hematology Oncology at Elkton Job at ChristianaCare

 ...Job Details Christiana Care Hematology Oncology at Elkton is seeking a professional, dependable, detail-oriented Medical Assistant I with strong communication, integrity, and solid technical and clinical skills. The ChristianaCare Oncology at Union is in Elkton, Maryland... 

Nitro Roofing

Sales Representative - $1,000 - $3,000/Week Job at Nitro Roofing

 ...Sales Representative - $1,000 - $3,000/Week - Paid Training Stipend On-Target Earnings of...  ...employees with the training, tools, and opportunities they need to succeed. As a Sales Representative...  ...Nitro Roofing & Construction is an equal opportunity employer. We celebrate...