MP

Trainee Business Analyst

Melstacorp PLCitpro.lk
Nov 3, 2026, 2:06 PM4h ago
InternshipColomboBusiness analysisEntry level

About the role

Melstacorp PLC is seeking a Trainee Business Analyst to join their team. The role involves extracting, cleaning, and analyzing financial and operational data, creating and maintaining Power BI dashboards, assisting with financial performance analysis, and building complex financial models using advanced Excel. The analyst will also collaborate with team leads to understand data requirements and deliver actionable reports. Candidates should have a relevant bachelor's degree and strong skills in Power BI and Excel, as well as good mathematical and communication abilities. The company is open to both fresh graduates with strong project portfolios and those with up to two years of relevant experience.

Must have

  • Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, Engineering, Business Analytics, or related field.
  • Power BI: Solid hands-on experience developing intuitive dashboards, establishing data source connections, and writing functional DAX expressions.
  • Advanced Excel: Complete mastery of data manipulation tools including XLOOKUP/VLOOKUP, Pivot Tables, and Power Query alongside a proven ability to build complex formulas (absolute must)
  • Strong mathematical skills with the ability to spot anomalies in financial statements and data trends.
  • Good verbal and written communication skills to explain data findings clearly to non-technical managers.
  • 01-02 years of experience in a similar data/finance analyst role is preferred, but talented fresh graduates with strong project portfolios are welcome to apply!

Technologies

  • Excel
  • Power Query
  • Power BI
  • Statistics