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, PivotTables, 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. Application Deadline This position is anticipated to close on Feb 24, 2026. h4>About 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 Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. About TEKsystems And TEKsystems Global Services We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.