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