Senior Reporting & Data Analytics

Job Title: 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)

Job ID: 408835

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

Start: September or October.

Interview: 1-2 rounds. Video required.

Submission Limit: Max 3 candidates per vendor.

Assessment: Glider - Data Consultant. Score report with all skill categories must be attached. Minimum passing score: above 30%.

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

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.

Interested? Apply Now!

If this sounds like the right opportunity for you, please apply with your most recent resume. On your resume, include your current location, relocation plan, availability or start date, and whether a cooling-off period is required. Ensure your Glider assessment report is attached and shows all skill scores.