Senior Reporting & Data Analytics

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

Senior Reporting & Data Analytics

Location: Charlotte, NC (preferred). Also open to Jersey City, NJ and Pennington, NJ.

Duration: Contract - 12 months.

Pay Range: Charlotte, NC -$67.89 (Pay Rate: $47.80) Jersey City, NJ -$71.22 (Pay Rate: $50.15) Pennington, NJ -$71.22 (Pay Rate: $50.15)

Work Model: Hybrid, minimum 3 days onsite per week.

Start: September or October.

Interview: 1-2 rounds. Video required.

Job Description

We are seeking a Senior Reporting & Data Analytics to provide end-to-end production support for executive metric reporting routines and dashboards. The ideal candidate will have strong experience in advanced Excel, SQL, and data mining and a proven ability to deliver accurate, executive-ready dashboards, diagnose and fix code or macro issues, and distill complex data into clear insights. Reports and executive summaries must be pristine and error free due to the senior audience.

Responsibilities

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

Required Skills & Qualifications

• Advanced Excel expertise including formulas, advanced functions, Power Query, and VBA/macros (5+ years).
• Moderate-to-advanced SQL for data extraction, joins, and validation (5+ years).
• Data mining and analytics experience to dissect, distill, and simplify data (7+ years).
• Proven delivery of recurring reports using existing macros and code with quality and timeliness.
• Ability to capture, clean, and manipulate data from multiple sources and systems of record.
• Strong attention to detail with an applied critical eye to catch errors or discrepancies.
• Effective prioritization, timely follow-up, and collaboration in a hybrid environment.
• Experience in a highly regulated industry or financial institution and prior interaction with senior managers.

Preferred Skills

• Prior experience creating executive dashboards or analytics in financial services.
• Prior Bank of America experience.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.
• Opportunities for growth with global clients.
• A supportive, inclusive culture that values innovation and people.
• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.