Junior Data Analyst - Ipsos Karian & Box
Role details
Job location
Tech stack
Job description
Are you an early-career data enthusiast who loves turning survey responses into clear, actionable insights? Do you enjoy cleaning and shaping data, automating reports, and working with cross-functional teams to improve employee experience across large organisations? Join a specialist team where your technical skills make real impact., Join Ipsos Karian & Box as a Junior Data Analyst and help shape how we collect, process and present employee experience data for FTSE100 and other major clients. Working in a multidisciplinary team of business psychologists, consultants, data scientists, designers and project managers, you'll clean and transform survey datasets, build schemas and automated reporting pipelines, and produce concise summary tables and visual outputs for internal teams and clients. Day-to-day tasks include preparing datasets, documenting project requirements, developing data cleaning processes, creating automated results tables and presenting data clearly to non-technical stakeholders. This is a hands-on role ideal for someone who wants to develop technical analysis skills (Excel, Python/R, DisplayR) and learn best practice in survey workflows while contributing to projects that directly improve workplace experience.
Requirements
Do you have experience in Scripting?, * Strong analytical mindset with comfort handling quantitative survey data and attention to data quality.
- Proficient in Microsoft Excel and experienced with at least one scripting language for data work (Python or R).
- Able to clean, transform and join datasets from multiple sources and document schemas/definitions.
- Clear communicator who can explain data findings to non-technical colleagues and support project teams.
- Organised and able to prioritise work to meet deadlines while managing own workload.
- Collaborative team player who shares knowledge and works across functions.Proficiency in AI use and adoption to speed routine tasks (e.g., data preparation, code snippets, synthesis) and improve deliverables.
Essential skills:
- Strong numerical, analytical and problem-solving ability.
- Advanced Excel skills (pivot tables, formulae, data cleaning).
- Practical experience with Python or R for data manipulation and analysis.
- Experience cleaning, transforming and joining survey datasets.
- Ability to produce clear summary tables and basic visualisations for reporting.
- Good written and verbal communication; ability to present findings to non-technical audiences.Organisational and time-management skills with a focus on accuracy and data governance.
Desirable skills:
- Familiarity with survey workflows, questionnaire tooling and survey metadata/schema design.
- Experience automating pipelines or reporting (scripting, scheduled jobs, ETL).
- Exposure to DisplayR or other report-building/visualisation platforms.
- Background or interest in HR research / employee listening programmes.
- Knowledge of basic statistical concepts or experimental design.Experience working with multidisciplinary teams (data scientists, analysts, project managers).
Benefits & conditions
We offer a comprehensive benefits package designed to support you as an individual. Our standard benefits include 25 days annual leave, pension contribution, income protection and life assurance. In addition, there are a range health & wellbeing, financial benefits and professional development opportunities.