Here are the key skills and ways to test them based on the job description:
- Coordinating and developing business and functional specifications for applications: Give candidate sample business requirements and have them draft specification documents. Assess their ability to translate requirements into technical specifications.
- Reviewing technical documents: Provide technical documents and use cases to candidate and have them identify if business needs are met. Evaluate their attention to detail.
- Developing reporting tools: Give access to sample data and have candidate create mock dashboards/reports. Assess data analysis skills and tool proficiency.
- Data analysis: Provide sample data sets and business questions. Test ability to interpret data, identify trends/insights, and draw conclusions.
- Microsoft Excel skills: Have candidate complete Excel skills assessment test with formulas, pivot tables, macros, etc. Gauge proficiency level.
- Database/BI skills: Ask about specific tools used and have candidate demonstrate query building, data modeling, visualization, etc.
- Decision making/problem solving: Pose hypothetical situations and problems. Evaluate how they analyze problems and propose solutions.
- Attention to detail: Have candidate proofread sample documents or spot errors in data. Check accuracy.
- Time management/organization: Ask about methods for prioritizing and managing multiple tasks and projects. Seek examples.
Let me know if you need any clarification or have additional questions!