Catalyst Solutions – Data Artist (Associate) – Morning & Afternoon Shifts
Posted: Sat Dec 13, 2025 9:59 pm
Preparation Guide for the Data Artist (Associate) Position at Catalyst Solutions
1. Understand the Company and the Role
- Research Catalyst Solutions through its website (www.adivagraphics.com) and recent news releases.
- Note that the firm is a Knowledge Process Outsourcing (KPO) provider working with Fortune‑500 and top‑10 marketing research companies in the USA and Canada.
- The job focuses on creating data‑heavy charts in Microsoft PowerPoint and Excel, ensuring data quality, and performing quality‑check of online surveys.
2. Review the Required Academic Background
- Verify that you hold a Bachelor’s degree in one of the listed fields (Electrical & Electronic Engineering, Computer Science & Engineering, Electronics and Telecommunication Engineering, Statistics, Mathematics).
- If your degree is in a related discipline, be prepared to explain how your coursework covered statistics, data handling, or visualization.
3. Core Technical Skills to Master
a) Microsoft Excel
- Advanced functions: VLOOKUP, XLOOKUP, INDEX/MATCH, IF, SUMIFS, COUNTIFS.
- Data manipulation: pivot tables, Power Query, data validation, conditional formatting.
- Basic macro recording or simple VBA to automate repetitive tasks.
b) Microsoft PowerPoint
- Master slide layouts, custom themes, and placeholders.
- Insert and format charts, tables, and SmartArt.
- Use animation and transition wisely to highlight key data points without distracting the audience.
c) Data Visualization Principles
- Choose appropriate chart types (bar, column, line, scatter, heat map, waterfall) based on the message.
- Apply best practices for color contrast, labeling, and scale.
- Keep visual clutter to a minimum; prioritize readability.
d) Survey Quality Assurance
- Familiarize yourself with online survey platforms (Qualtrics, SurveyMonkey, Alchemer).
- Practice checking skip logic, piping, and validation rules.
- Understand common questionnaire design pitfalls (leading questions, double‑bars, overload).
4. Build a Targeted Portfolio
- Create 3–5 sample PowerPoint decks that showcase a variety of chart types and data stories.
- Include before‑and‑after versions to demonstrate improvement in clarity and visual appeal.
- Add a brief case study for each deck describing the data source, analytical steps, and design decisions.
- Host the portfolio on a personal website or a cloud folder (Google Drive, OneDrive) and generate shareable links.
5. Practice Real‑World Scenarios
- Download publicly available datasets (Kaggle, data.gov) and replicate a typical client deliverable: clean the data, perform basic analysis, and produce a concise PowerPoint presentation.
- Simulate a survey QC task: design a short questionnaire, implement it in a free online survey tool, and walk through logic checks.
6. Soft Skills and Personal Attributes
- Emphasize your ability to work hard, stay patient under tight deadlines, and adapt to shifting priorities.
- Prepare examples that illustrate self‑starting behavior, a passion for learning, and meticulous attention to detail.
- Highlight organizational techniques you use (task lists, time‑blocking, version control).
7. Prepare for the Interview Process
- Expect a two‑stage process: an initial screening (phone or video) followed by an on‑site assessment at the Dhaka office, even if you are applying for the Chattogram location.
- Anticipate technical questions on Excel formulas, chart selection, and survey logic.
- Be ready to perform a short live exercise: creating a chart in Excel and embedding it into a PowerPoint slide within a limited time.
- Prepare behavioral questions that explore teamwork, handling feedback, and meeting quality standards.
8. Logistics and Documentation
- Ensure your resume is updated, highlighting relevant degrees, technical skills, and any previous experience with data visualization or survey QA.
- Attach a cover letter that connects your background to Catalyst Solutions’ focus on data‑driven insight for North American clients.
- Gather copies of academic transcripts, certificates for Excel/PowerPoint training (if any), and a government‑issued ID.
- Verify that you meet the age limit (maximum 32 years) and that you are comfortable with the full‑time office environment.
9. Understand the Benefits and Compensation
- Salary range: BDT 18,000 – 25,000 per month.
- Review the benefit list (subsidized meals, quarterly bonuses, mentorship, paid leaves, medical examinations, etc.) to discuss during negotiation.
- Note that certain benefits (e.g., maternity/paternity leave, work‑from‑home options) apply only to permanent employees.
10. Final Checklist Before Application
- Completed and proofread resume and cover letter.
- Portfolio links tested and accessible.
- All required documents scanned and organized.
- Email drafted to the recruitment team (use the provided apply email or online portal).
- Mark the deadline (January 2, 2026) on your calendar and submit at least two days before to avoid last‑minute issues.
By following these steps you will be well‑prepared to demonstrate the technical competence, attention to detail, and proactive attitude that Catalyst Solutions seeks in its Data Artist (Associate) candidates. Good luck!
1. Understand the Company and the Role
- Research Catalyst Solutions through its website (www.adivagraphics.com) and recent news releases.
- Note that the firm is a Knowledge Process Outsourcing (KPO) provider working with Fortune‑500 and top‑10 marketing research companies in the USA and Canada.
- The job focuses on creating data‑heavy charts in Microsoft PowerPoint and Excel, ensuring data quality, and performing quality‑check of online surveys.
2. Review the Required Academic Background
- Verify that you hold a Bachelor’s degree in one of the listed fields (Electrical & Electronic Engineering, Computer Science & Engineering, Electronics and Telecommunication Engineering, Statistics, Mathematics).
- If your degree is in a related discipline, be prepared to explain how your coursework covered statistics, data handling, or visualization.
3. Core Technical Skills to Master
a) Microsoft Excel
- Advanced functions: VLOOKUP, XLOOKUP, INDEX/MATCH, IF, SUMIFS, COUNTIFS.
- Data manipulation: pivot tables, Power Query, data validation, conditional formatting.
- Basic macro recording or simple VBA to automate repetitive tasks.
b) Microsoft PowerPoint
- Master slide layouts, custom themes, and placeholders.
- Insert and format charts, tables, and SmartArt.
- Use animation and transition wisely to highlight key data points without distracting the audience.
c) Data Visualization Principles
- Choose appropriate chart types (bar, column, line, scatter, heat map, waterfall) based on the message.
- Apply best practices for color contrast, labeling, and scale.
- Keep visual clutter to a minimum; prioritize readability.
d) Survey Quality Assurance
- Familiarize yourself with online survey platforms (Qualtrics, SurveyMonkey, Alchemer).
- Practice checking skip logic, piping, and validation rules.
- Understand common questionnaire design pitfalls (leading questions, double‑bars, overload).
4. Build a Targeted Portfolio
- Create 3–5 sample PowerPoint decks that showcase a variety of chart types and data stories.
- Include before‑and‑after versions to demonstrate improvement in clarity and visual appeal.
- Add a brief case study for each deck describing the data source, analytical steps, and design decisions.
- Host the portfolio on a personal website or a cloud folder (Google Drive, OneDrive) and generate shareable links.
5. Practice Real‑World Scenarios
- Download publicly available datasets (Kaggle, data.gov) and replicate a typical client deliverable: clean the data, perform basic analysis, and produce a concise PowerPoint presentation.
- Simulate a survey QC task: design a short questionnaire, implement it in a free online survey tool, and walk through logic checks.
6. Soft Skills and Personal Attributes
- Emphasize your ability to work hard, stay patient under tight deadlines, and adapt to shifting priorities.
- Prepare examples that illustrate self‑starting behavior, a passion for learning, and meticulous attention to detail.
- Highlight organizational techniques you use (task lists, time‑blocking, version control).
7. Prepare for the Interview Process
- Expect a two‑stage process: an initial screening (phone or video) followed by an on‑site assessment at the Dhaka office, even if you are applying for the Chattogram location.
- Anticipate technical questions on Excel formulas, chart selection, and survey logic.
- Be ready to perform a short live exercise: creating a chart in Excel and embedding it into a PowerPoint slide within a limited time.
- Prepare behavioral questions that explore teamwork, handling feedback, and meeting quality standards.
8. Logistics and Documentation
- Ensure your resume is updated, highlighting relevant degrees, technical skills, and any previous experience with data visualization or survey QA.
- Attach a cover letter that connects your background to Catalyst Solutions’ focus on data‑driven insight for North American clients.
- Gather copies of academic transcripts, certificates for Excel/PowerPoint training (if any), and a government‑issued ID.
- Verify that you meet the age limit (maximum 32 years) and that you are comfortable with the full‑time office environment.
9. Understand the Benefits and Compensation
- Salary range: BDT 18,000 – 25,000 per month.
- Review the benefit list (subsidized meals, quarterly bonuses, mentorship, paid leaves, medical examinations, etc.) to discuss during negotiation.
- Note that certain benefits (e.g., maternity/paternity leave, work‑from‑home options) apply only to permanent employees.
10. Final Checklist Before Application
- Completed and proofread resume and cover letter.
- Portfolio links tested and accessible.
- All required documents scanned and organized.
- Email drafted to the recruitment team (use the provided apply email or online portal).
- Mark the deadline (January 2, 2026) on your calendar and submit at least two days before to avoid last‑minute issues.
By following these steps you will be well‑prepared to demonstrate the technical competence, attention to detail, and proactive attitude that Catalyst Solutions seeks in its Data Artist (Associate) candidates. Good luck!