The Data Analysis & Reporting Senior Analyst is responsible for supporting the AVP Data Analysis & Reporting and the Head of Business Governance in fulfilling the Data Analysis & Reporting needs of all Consumer Banking Groups entities which include all business segments (Mass Elite Elite World NHL Islamic etc.) and functions (Product Sales & Distribution Business Development Digital Digital Marketing Strategies other Business Governance units etc.). The role holder is also expected to support business units outside of Consumer Banking including Global Private Banking Customer Experience KYC & Onboarding Finance Contact Centre DAAI Group Compliance etc.). The role holder focuses on ad hoc requirements deep dive analytics and other special business intelligence projects and initiatives and to support in the overall objectives of Business Analytics in terms of automation Power BI reporting and performance packs in order to drive data-driven decisions. The role holder will also lead the analytical and reporting requirements on marketing leads activities and overall lead-management performance and digital adoption and sales journeys.
ACCOUNTABILITIES:
Data Sourcing & Maintenance
- Discovering new data from the Enterprise Data Warehouse (EDW) and migrating into the EDW such processes that source data from outside of it by establishing and governing data logics from EDW tables.
- Performing sanity checks on all data inputs and liaising with respective EDW IT custodians in the event of anomalies.
- Liaising with EDW IT to onboard new columns or tables.
- Running the necessary jobs on a regular basis to ensure that the backend tables are created on time.
- Establishing a clean responsible and easy-to-track data source. While the infrastructure is governed by IT the substance data logics and sources for CBG should be managed to ensure that users do not rely on any other sources and bridge towards a single version of truth for the whole Group.
Ad Hocs & Special Projects
- Handling and delivering various ad hoc requirements across the different CBG functions as well as other FAB business units as stated in the Job Purpose ranging from Digital to Sales to Customers to KYC to Compliance to CRM Leads etc.
- Supporting on the data inputs required for group or bank-wide activities and initiatives like EWRA TESS RBS etc.
- Supporting on regulatory data requirements including CBUAE FATCA/CRS AML/CFT etc.
- Supporting on CBG special projects including MSD CRM Migration RPA Automation Finalta Sales Effectiveness Finalta Digital & Multichannel Study etc.
Regular Reporting
- Delivery of reports that are committed to stakeholders to be delivered daily weekly monthly or quarterly. These are reports that normally come up from requirements that start off as ad hocs or one-offs including Excel based-reports Power Point decks and/or Power BI reports.
- Working towards full automation of reports in favor of EDW and Power BI.
CRM Campaign/Lead Performance Reporting and Oversight
- Monitoring and tracking campaign/lead performance results and performs campaign/lead performance analysis
- Preparing regular and ad hoc reports as required in a timely and accurate manner using the data gathered and the analysis conducted to meet the departments and FABs requirements policies and standards.
- Assisting in planning and deployment of new campaign/leads including proper configurations in CRM to ensure seamless data flows and facilitate reporting
- Working towards full automation of reports in favor of EDW and Power BI.
- Maintaining proper governance and controls around lead allocation by ensuring the allocation mechanism in CRM is sound and aligning with agreed processes
Digital Journeys Reporting and Insight
- Making sure all the digital journeys are tagged and reported to top management.
- Bridge the gap between Business and Tech team to get the requirements for digital journeys.
- Perform adhoc analysis as and when needed.
- Assist digital team for proper database taggings with Tech team so that we BI team can also perform deep dive analysis.
Qualifications :
Minimum Qualification
- Bachelors degree in Management Information Systems or related discipline.
Minimum Experience
- 3 years of relevant experience in the banking sector with at least 1 year in similar positions in the Business Intelligence Business Analytics or Decision Support functions
Other Essential Requirements
- Strong technical knowledge of Consumer Banking products and business model
- Basic SQL knowledge
- Advanced Excel skills
Remote Work :
No
Employment Type :
Full-time
Key Skills SQL,Agile,Business Analysis,Visio,Waterfall,Business Process Modeling,Requirements Gathering,Business requirements,JD Edwards,SDLC,Systems Analysis,Data Analysis Skills
Experience: years
Vacancy: 1