Job Description
BE PART OF OUR GROWTH STORY
BANKING ASSISTANT
(SERVICE EXCELLENCE & TRANSFORMATION: POWER BI & DATA VISUALIZATION)
You should ideally:
- possess minimum 3 years of relevant experience in banking/financial institution including project experience in data analytics or reporting
- undergraduate or currently pursuing a Bachelor's degree in Computer Science, Information Systems, or a related field will be an added advantage
- possess advanced skills in Power BI, including Power Query, DAX, data modeling, and Power BI Service
- have foundational knowledge of SQL, ETL processes, and experience with automation tools such as Power Automate and Power Apps, including integration with SharePoint, SQL Server, and APIs
- have knowledge of VBA and Macros, which will also be an advantage
- possess familiarity with banking operations and terminology and possess strong communication and collaboration skills
You will be mainly responsible for:
- developing and maintaining interactive Power BI dashboards and reports for internal stakeholders.
- performing data extraction, transformation, and loading (ETL) using Power Query and Excel.
- writing DAX expressions to create calculated columns, measures, and KPIs.
- connecting to various data sources, including SQL Server, Excel, SharePoint, and APIs.
- cleaning and preparing data using Excel functions and Power BI tools.
- creating dynamic Excel dashboards with pivot tables, charts, and advanced formulas.
- supporting automation efforts through Power Automate and Power Apps.
- designing internal communication materials (e.g., flyers, visuals) using Canva.
- collaborating with internal teams to understand reporting needs and deliver actionable insights.
We are an equal opportunity employer, committed to promoting an inclusive and diverse environment. Recruitment to the Bank is based solely on merit and competency irrespective of other characteristics that make our employees unique. Any form of canvassing is discouraged. Correspondence will only be with the short-listed candidates.
Please apply via e-mail by sending an updated CV or a DFCC Bank application form which could be downloaded from our website to recruit@dfccbank.com with the post applied for in the subject by 18th July 2025.
Chief Human Resource Officer
DFCC Bank PLC 73/5,
Galle Road, Colombo 03
0112 350000
www.dfcc.lk
Fitch Ratings A (Ika)
Licensed Commercial Bank supervised by CBSL