DA-Data Analyst-CMB
At a glance
Mid-level Data Analysis & BI role at Ed.co. Sri Lanka · contract.
Pay not stated Data Analysis & BI salary
dataroles summary, based on the employer's posting.
What you'll do
- Pull records from databases, then clean and structure them for analysis
- Turn findings into charts and graphs for project reports, dashboards and presentations
- Build straightforward tools with VB, Excel Macros or web technologies
- Investigate inaccurate records and resolve issues in data merges and system integration
- Spot patterns in complex datasets and use research to recommend corrective action
What you bring
- You can write advanced SQL to extract and manipulate data, with knowledge of relational databases
- You can build and maintain project data systems and improve collection methods, data quality and efficiency
- You can interpret results, run basic statistical analyses and explain complex findings clearly
- You bring an analytical mindset and can learn while working with minimal supervision
Who this fits
This contract role suits someone comfortable handling data from collection through reporting, with a clear analytical approach. Previous work as a data analyst is optional; a relevant bachelor's degree is preferred.
From the employer
Data Analyst
Data Analytics Team
Position Overview:
The Data Analytics team specializes in conducting data driven, quantitative analysis on behalf of our clients. The data is generated via a mix of creative primary research techniques (e.g., phone surveys, online/web surveys), internal customer databases, and secondary research sources (e.g., financial filings of public companies).
Responsibilities:
Be able to extract data from various databases, format and clean data.
Generate insights from the data and present in relevant charts and graphs to be incorporated into project reports.
Build simple solutions using programming tools such as VB, Excel Macros and web based technologies.
Identify problematic areas and conduct research to determine the best course of action to correct the data.
Analyze and solve issues with current and planned systems as they relate to the integration and management of data (e.g.: review for accuracy in record merge, unmerge processes).
Identify, analyze, and interpret trends or patterns in complex data sets.
Requirements:
Data Capture
Develop and maintain databases and data systems necessary for projects.
Acquire and abstract primary or secondary data from existing internal or external data sources.
Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
Data Reporting
Interpret data and develop recommendations based on findings.
Develop graphs, reports, and presentations of project results.
Perform basic statistical analyses for projects and reports.
Create and present quality dashboards.
Generate routine and ad hoc reports.
Knowledge/Skills
Technical expertise regarding data models and database design development.
Knowledge in relational databases such as MySQL, Oracle and SQL server.
Advanced level knowledge on SQL queries for data manipulation and extraction.
Exposure to data mining and data warehousing technologies would be highly desired.
Proficient in MS Word, Excel, Access, and PowerPoint.
Experience using SAS, SPSS, or other statistical package is desirable for analyzing large datasets.
Programming skills preferred. Adept at queries and report writing.
Knowledge of statistics, at least to the degree necessary in order to communicate easily with statisticians.
Experience in data mining techniques and procedures and knowing when their use is appropriate.
Ability to present complex information in an understandable and compelling manner.
Prior work experience in a similar role is not mandatory, but a clear analytical mindset, the desire to learn and the willingness to work with minimal supervision is an absolute must.
Preferred Qualifications:
Bachelor's in Information Management, Information Technology, Computing, Mathematics, Statistics, or related fields.
Previous data analyst experience.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.