Executive Data Analytics & Reporting Lead (Hybrid)

BC Forward; Charlotte (NC); Hybrid; USD 65,000 - 70,000; Full time

Benefits offered by this job

Competitive compensation

Hybrid work arrangement

Global client exposure

Job summary

BCforward is seeking a Senior Reporting & Data Analytics professional to provide end-to-end production support for executive metric reporting routines and dashboards in Charlotte, NC (preferred) with flexibility for Jersey City or Pennington, NJ.

The ideal candidate has strong expertise in advanced Excel, SQL, data mining, and delivering pristine, executive-ready dashboards. You will diagnose and fix code issues and distill complex data into clear insights for senior management.

Qualifications

• Advanced Excel, Power Query, VBA/macros (5+ years).
• SQL for data extraction, joins, and validation (5+ years).
• Data mining and analytics to distill insights (7+ years).
• Proven delivery of recurring reports with macros and code.
• Attention to detail and ability to work in hybrid environment.

Responsibilities

• Own end-to-end production support for recurring metric reports and dashboards.
• Leverage advanced Excel, Power Query, and VBA/macros to automate reporting.
• Use SQL to extract, join, and validate data from multiple sources.
• Perform data mining, aggregation, and trend analysis to identify discrepancies and at-risk controls.
• Produce inventory and risk program metrics and analytics.
• Create executive summaries and dashboards that are presentation-ready.
• Troubleshoot macro or code breaks.
• Collaborate with stakeholders and respond to adhoc requests.

Skills

Advanced Excel

Power Query

VBA/macros

SQL

Data mining

Data analysis

Attention to detail

Hybrid collaboration

Job description

BCforward is seeking a Senior Reporting & Data Analytics professional to provide end-to-end production support for executive metric reporting routines and dashboards in Charlotte, NC (preferred) with flexibility for Jersey City or Pennington, NJ.

The ideal candidate has strong expertise in advanced Excel, SQL, data mining, and delivering pristine, executive-ready dashboards. You will diagnose and fix code issues and distill complex data into clear insights for senior management.