Business Analyst

Description

This role is on the CRA Data Integrity & Reporting team doing complex reporting, multi-source data management, and compliance-driven analysis. This role builds dashboards, automates data workflows, validates large datasets, and ensures accurate CRA/HMDA/Community Benefits Plan reporting for leadership, auditors, and regulators. Emphasis on advanced Excel (Power Query, VBA/macros), BI (Power BI and/or Tableau), rigorous reconciliation, and clear insight delivery as the team modernizes its reporting infrastructure.

Key Responsibilities Build and maintain Power BI or Tableau dashboards for CRA lending, investment, and service activity. Automate data preparation and validation using Excel Power Query and VBA/macros (leverage Alteryx where available). Ingest, cleanse, transform, and reconcile large multi-source datasets; maintain data definitions and business rules. Produce automated monthly, quarterly, and ad hoc reports; ensure accuracy, consistency, and timeliness. Support quarterly and annual CRA regulatory submissions and examiner readiness packages.

Document reporting processes, data lineage, and assumptions to ensure repeatability and transparency. Identify and implement process improvements and automation to scale and reduce manual effort. Publish and manage deliverables via SharePoint, including versioning and controlled distribution. Collaborate with Compliance, Risk, Community Development, and business units to ensure accurate CRA population tracking and proper application of guidance. Translate regulatory requirements and data findings into clear insights, highlighting trends, risks, and recommendations.

Skills

tableau, Alteryx, Excel, CRA, banking

Top Skills Details

tableau,Alteryx,Excel,CRA,banking

Additional

Skills & Qualifications

Advanced Excel:
Power Query, Pivot Tables, XLOOKUP/INDEX‑MATCH, complex formulas, and VBA/macros for automation. BI tools:
Power BI and/or Tableau for building and maintaining dashboards. Proven ability to build automated, repeatable reporting from multiple data sources; strong self‑QA discipline. Documentation of business rules, data lineage, and assumptions to ensure consistency and auditability. SQL for data exploration/validation (plus). Banking domain familiarity; CRA exposure is a strong plus (not required). Experience publishing to SharePoint, managing permissions, and version control;
Excel-SharePoint integrations. Ability to translate data into clear insights and recommendations for non‑technical stakeholders. Demonstrated process improvement/automation mindset (e.g., Alteryx, Power Query, Power Automate). Comfortable in a small, scaling team; proactive, intellectually curious, and improvement‑oriented. Time‑zone flexibility for remote collaboration; punctual and accountable. Work authorization without the need for visa sponsorship

Experience Level

Intermediate Level

Job Type & Location

This is a Contract to Hire position based out of Raleigh, NC.

Pay and Benefits

The pay range for this position is $30.46 - $57.68/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

- Medical, dental & vision - Critical Illness, Accident, and Hospital - 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available - Life Insurance (Voluntary Life & AD&D for the employee and dependents) - Short and long-term disability - Health Spending Account (HSA) - Transportation benefits - Employee Assistance Program - Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully remote position.

Final date to receive applications

This position is anticipated to close on Feb 24, 2026.

h4About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack…