Business Analyst

TEKsystems is a leading provider of business and technology services, and they are seeking a Business Analyst to join their CRA Data Integrity & Reporting team. The role involves complex reporting, multi-source data management, and compliance-driven analysis, with a focus on building dashboards and automating data workflows.

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

Requirements:

• 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