Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Consolidate datasets in Excel and append key Census attributes for local telco segmentation.
- Company: Join a dynamic team focused on data processing and analysis.
- Benefits: Short-term contract with flexible hours and valuable experience.
- Why this job: Enhance your Excel skills while making a real impact on data-driven decisions.
- Qualifications: Proficiency in Microsoft Excel and strong data processing abilities.
- Other info: Opportunity to work on a meaningful project with a quick turnaround.
The predicted salary is between 500 - 1500 £ per month.
Build a single consolidated Excel dataset with 1 row per corregimiento – total of 699 (official IGNTG DPA 2025, updated to 2024 dataset) and append key 2023 Census attributes to support local telco segmentation.
Overview of steps and output:
- Step 1: Pull the DPA corregimiento data set and have this become the master file. Keep official codes/names (province, district, corregimiento), and ensure 699 rows (IGN Panamá).
- Step 2: Pull the 3 INEC Census 2023 layers above and export attributes (no need to keep their geometry).
- Step 3: Join everything onto the DPA master using a stable key. Key can be the official corregimiento code fields since they are consistent across the 699 rows and the census.
- Step 4: Append fields from the census as columns based on the provided list.
- Step 5: QA and documentation. Produce a join coverage summary (matched/unmatched by source) and list the unmatched corregimientos.
Output format: Deliver a single Excel workbook:
- Tab 1: master → 1 row per corregimiento, DPA codes/names + appended census/IPM fields.
- Tab 2: qa → row counts, duplicates, join match rates, unmatched list.
Contract duration of less than 1 month.
Mandatory skills: Microsoft Excel, Data Processing.
Quick dataset consolidation in Excel employer: FreelanceJobs
Contact Detail:
FreelanceJobs Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Quick dataset consolidation in Excel
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or other platforms. Let them know you're on the hunt for opportunities in data processing and Excel. You never know who might have a lead or can refer you to someone looking for your skills.
✨Tip Number 2
Practice makes perfect! Brush up on your Excel skills by working on sample datasets. Create your own mini-projects that mimic the job description. This will not only boost your confidence but also give you real examples to discuss during interviews.
✨Tip Number 3
Be proactive! Instead of waiting for job postings, reach out directly to companies you admire. Send them a friendly email expressing your interest in potential roles, especially in data processing. It shows initiative and could land you an interview before a position is even advertised.
✨Tip Number 4
Apply through our website! We’ve got loads of opportunities that might just be perfect for you. Plus, applying directly can sometimes give you a better chance of getting noticed. So, don’t hesitate – check us out and get your application in!
We think you need these skills to ace Quick dataset consolidation in Excel
Some tips for your application 🫡
Show Off Your Excel Skills: Make sure to highlight your Microsoft Excel expertise in your application. We want to see how you can handle data processing and consolidation, so don’t hold back on showcasing any relevant projects or experiences!
Be Clear and Concise: When writing your application, keep it straightforward. We appreciate clarity, so make sure your points are easy to understand. Avoid jargon unless it's necessary, and get straight to the point about your skills and experience.
Tailor Your Application: Take a moment to customise your application for this specific role. Mention the key tasks from the job description and explain how your background aligns with them. This shows us that you’re genuinely interested and have done your homework!
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at FreelanceJobs
✨Know Your Excel Inside Out
Make sure you’re well-versed in Excel, especially functions like VLOOKUP, INDEX-MATCH, and pivot tables. Brush up on how to manipulate datasets and perform data validation, as these skills will be crucial for the role.
✨Understand the Project Requirements
Familiarise yourself with the job description and the steps outlined for dataset consolidation. Be prepared to discuss how you would approach each step, particularly how to ensure data integrity and accuracy when joining datasets.
✨Prepare for Practical Questions
Expect to face practical questions or even a test during the interview. Practice consolidating datasets and creating summaries in Excel beforehand so you can demonstrate your skills confidently.
✨Showcase Your Attention to Detail
Highlight your ability to QA your work. Discuss any previous experiences where you’ve had to ensure data accuracy and how you documented your processes. This will show that you take pride in delivering high-quality results.
