Business Analyst and Data Analyst

Job summary

Gather and document business requirements, analyze data, and develop Power BI dashboards, KPI reports, and executive reporting solutions using SQL and Excel. Prepare and validate regulatory reports, perform data quality analysis, support UAT, and collaborate with business, compliance, and technology teams to implement reporting solutions.

Job details

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

What you’ll do

Gather and document business requirements, analyze data, and develop Power BI dashboards, KPI reports, and executive reporting solutions using SQL and Excel. Prepare and validate regulatory reports, perform data quality analysis, support UAT, and collaborate with business, compliance, and technology teams to implement reporting solutions.

Requirements

Requires 6–8 years of combined business and data analysis experience, with strong hands-on Power BI, advanced SQL, and expert Excel skills. Candidates should also have experience with regulatory reporting, data warehousing and ETL, dashboard design, stakeholder management, and translating business needs into technical solutions.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Data analysis · Preferred
• Microsoft Excel · Preferred
• Business analysis · Preferred
• Requirements gathering · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Business Analysis
• Data Analysis
• Power BI
• Data Modeling
• DAX
• Power Query
• SQL
• Microsoft Excel
• Dashboard Development
• KPI Reporting
• Data Visualization
• Data Warehousing
• ETL
• Regulatory Compliance Reporting
• Requirements Gathering
• Stakeholder Management

Job areas

• Data & Analytics
• Technology
• Consulting
• Finance & Accounting

More jobs from J&M Group