Skills Required:

Languages SQL, DAX, JavaScript, JSON
BI Tools Power BI Desktop, Power BI Service
GRC Platforms RSA Archer (Core Apps, Admin, Data Feeds, APIs)
Database Systems SQL Server, Oracle, PostgreSQL, MySQL
Integration REST APIs, Data Connectors, ETL Tools
Project/Collaboration JIRA, Confluence, ServiceNow, Agile/Scrum
Banking domain expertise (risk, compliance, lending, payments) is highly regarded

Roles and Responsibilities

· Configure RSA Archer modules, fields, workflows, DDEs, and calculated fields.
· Customize out-of-the-box solutions to meet business requirements.
· Develop and maintain integrations with external systems using Archer Data Feeds and APIs.
· Perform Archer platform upgrades, migrations, and patch management.
· Design dashboards, reports, and iViews within Archer.
· Design and create normalized relational database structures (tables, views, indexes).
· Develop and optimize SQL queries, stored procedures, functions, and triggers.
· Implement ETL (Extract, Transform, Load) processes to move and transform data.
· Connect Power BI to various data sources (SQL databases, Excel, cloud services, etc.).
· Develop dashboards and reports using Power BI Desktop and Power BI Service.
· Use DAX (Data Analysis Expressions) to create calculated columns and measures.
· Design efficient data models optimized for performance.
· Implement row-level security to ensure data access controls.
· Collaborate with business users to gather reporting requirements and translate them into visual solutions.
· Schedule and publish reports to Power BI Service and manage data refresh schedules.