Assurance Mapping and Data Analytics Consultant, Internal Audit & Investigation, OIAI, Hybrid, 6 months, NY
UNICEF · New York, United States · 2 wk ago
AccountingContract
We need to output HTML fragment with sections: headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title as heading. Must not include Job ID etc. Remove boilerplate, navigation, legal, EEO, etc. Must preserve all substantive information.
We need to parse the posting.
Let's extract substantive content:
- Intro about UNICEF mission: "UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the world. We welcome everyone who wants to belong and grow in a diverse and passionate culture, coupled with an attractive compensation and benefits package. Visit our website to learn more about what we do at UNICEF. For every child, the right to care"
That's generic but maybe considered "About the role"? Actually it's about organization. Could be "About the role" or "About UNICEF". The instruction says use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have "About the role" heading with that content.
- Then "How can you make a difference? The purpose of the consultancy is to strengthen OIAI’s data analytics and business intelligence capabilities by developing a semi-automated or automated and sustainable approach to assurance mapping and related audit analytics. The assignment will focus on enhancing the existing assurance mapping model and developing a dynamic analytical solution, preferably using Power BI or similar technology, to facilitate the integration, analysis, visualization and updating of assurance coverage data. The consultancy will also develop analytical tools and outputs that can be applied to related OIAI processes, including the audit universe, risk assessment, audit planning and annual reporting. The assignment is temporary and output-based, with defined analytical products, milestones and knowledge-transfer deliverables to be completed within the consultancy period. The consultant will support further development of OIAI’s assurance mapping and related audit analytics. The work will include maintaining and enhancing the existing Excel-based assurance map; consolidating and integrating relevant assurance and audit data; developing a more automated and dynamic solution, preferably in Power BI or similar technology; and producing analytical tools and visualizations to support assurance mapping, the audit universe, risk assessment, planning and reporting. The assignment will also include testing, documenting and supporting the handover of the developed solutions."
That's responsibilities/duties. So we can put under
for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title as heading. Must not include Job ID etc. Remove boilerplate, navigation, legal, EEO, etc. Must preserve all substantive information.
We need to parse the posting.
Let's extract substantive content:
- Intro about UNICEF mission: "UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the world. We welcome everyone who wants to belong and grow in a diverse and passionate culture, coupled with an attractive compensation and benefits package. Visit our website to learn more about what we do at UNICEF. For every child, the right to care"
That's generic but maybe considered "About the role"? Actually it's about organization. Could be "About the role" or "About UNICEF". The instruction says use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have "About the role" heading with that content.
- Then "How can you make a difference? The purpose of the consultancy is to strengthen OIAI’s data analytics and business intelligence capabilities by developing a semi-automated or automated and sustainable approach to assurance mapping and related audit analytics. The assignment will focus on enhancing the existing assurance mapping model and developing a dynamic analytical solution, preferably using Power BI or similar technology, to facilitate the integration, analysis, visualization and updating of assurance coverage data. The consultancy will also develop analytical tools and outputs that can be applied to related OIAI processes, including the audit universe, risk assessment, audit planning and annual reporting. The assignment is temporary and output-based, with defined analytical products, milestones and knowledge-transfer deliverables to be completed within the consultancy period. The consultant will support further development of OIAI’s assurance mapping and related audit analytics. The work will include maintaining and enhancing the existing Excel-based assurance map; consolidating and integrating relevant assurance and audit data; developing a more automated and dynamic solution, preferably in Power BI or similar technology; and producing analytical tools and visualizations to support assurance mapping, the audit universe, risk assessment, planning and reporting. The assignment will also include testing, documenting and supporting the handover of the developed solutions."
That's responsibilities/duties. So we can put under Responsibilities
with a - list of duties.
- Then "If you would like to know more about this consultancy, please review the complete Terms of Reference here: TMC0006537 External ToR.pdf" That's a link; maybe we can include as a paragraph? It's not boilerplate but it's a reference. Could be part of responsibilities or a separate "Details". But we can keep as a paragraph.
- Then "To qualify as an advocate for every child you will have... Minimum Requirements Education: Completion of secondary/high school diploma or equivalent. Demonstrated proficiency in Power BI or similar visualization tools, use of AI and agentic AI tools such as Copilot, advanced Excel, data structuring and analysis, automation, and working with large or complex datasets.Analytical foundation in data analytics, business intelligence, economics, finance, mathematics, statistics, computer science, information systems, or another relevant quantitative/analytical field.Work Experience:At least two years of relevant work experience in data analytics, data management, business intelligence, data visualization, analytical research or other related areas. Relevant experience may include internships, academic projects or other practical assignments involving data extraction, structuring, analysis and presentation.Skills:Strong proficiency in Excel and Power BI or similar business intelligence/data visualization tools; experience in cleaning, structuring and integrating data from multiple sources; ability to develop dashboards and automated analytical solutions; strong analytical and problem-solving skills; and ability to document analytical processes and present data clearly to non-technical users.Language Requirements:Fluency in English is required.Desirables: Experience with Python, SQL, PowerShell or other data automation tools; familiarity with audit, assurance, risk management or performance reporting; and experience working with large or complex organizational datasets."
We need to split into sections: Requirements (education, work experience), Qualifications maybe overlapping, Skills. The instruction says we can have sections: Requirements, Qualifications, Skills. We need to decide what content goes where.
We have Education, Work Experience, Skills, Language Requirements, Desirables.
We could put Education and Work Experience under
Requirements
. Skills under Skills
. Language Requirements could be part of Requirements or Skills; maybe include under Requirements as a bullet. Desirables could be under Qualifications
(preferred qualifications). Or we could combine Qualifications and Skills. But we need to avoid thin sections. Let's create:
- Requirements: Education, Work Experience, Language Requirements.
- Skills: Technical skills (Excel, Power BI, etc.)
- Qualifications: Desirables (Python, SQL, etc.) maybe also mention analytical foundation? Actually analytical foundation is part of Minimum Requirements; could be under Requirements as well.
But we need to preserve all substantive info. Let's structure:
About the role
with paragraph(s) about UNICEF mission and consultancy purpose? Actually the "How can you make a difference?" is more about the role. Could combine with About the role.
Better: About the role
includes description of consultancy purpose and tasks? But we already have Responsibilities separate. Usually About the role is overview; Responsibilities are detailed duties. So we can put overview in About the role: The purpose of the consultancy is to strengthen OIAI’s data analytics... etc. That's a good overview.
Then Responsibilities: list of specific work items.
Then Requirements: Education, Work Experience, Language Requirements.
Then Skills: Proficiency in Excel and Power BI, data cleaning, dashboard development, analytical problem solving, documentation, presentation.
Then Qualifications: Desirables (Python, SQL, PowerShell, audit familiarity, large dataset experience).
We should not include Benefits, Pay, Schedule because not mentioned.
We must not include boilerplate like "For every child, the right to care" maybe part of About the role but it's okay.
We must remove cookie/navigation/legal/EEO etc. The text includes many EEO statements: "UNICEF encourages applications from all qualified candidates..." etc. Those are boilerplate; we should remove them. Also remove lines about background checks, accessibility, etc. Also remove "UNICEF does not hire candidates who are married to children..." etc. Also remove "Qualified candidates are invited to submit the following documents..." etc. Also remove "Remarks: If the TOR or financial proposal documents are not downloadable..." etc. Also remove "UNICEF does not charge a processing fee..." etc. Also remove "Additional information about working for UNICEF can be found here." etc.
We must preserve substantive info: the consultancy description, requirements, skills, desirables.
Let's extract substantive paragraphs:
From start:
"UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the world. We welcome everyone who wants to belong and grow in a diverse and passionate culture, coupled with an attractive compensation and benefits package. Visit our website to learn more about what we do at UNICEF. For every child, the right to care"
That's generic but maybe we keep as About UNICEF? It's not role-specific but could be considered About the role? Might be considered boilerplate but it's about organization; maybe we can keep short.
Then "How can you make a difference? The purpose of the consultancy is to strengthen OIAI’s data analytics and business intelligence capabilities by developing a semi-automated or automated and sustainable approach to assurance mapping and related audit analytics. The assignment will focus on enhancing the existing assurance mapping model and developing a dynamic analytical solution, preferably using Power BI or similar technology, to facilitate the integration, analysis, visualization and updating of assurance coverage data. The consultancy will also develop analytical tools and outputs that can be applied to related OIAI processes, including the audit universe, risk assessment, audit planning and annual reporting. The assignment is temporary and output-based, with defined analytical products, milestones and knowledge-transfer deliverables to be completed within the consultancy period. The consultant will support further development of OIAI’s assurance mapping and related audit analytics. The work will include maintaining and enhancing the existing Excel-based assurance map; consolidating and integrating relevant assurance and audit data; developing a more automated and dynamic solution, preferably in Power BI or similar technology; and producing analytical tools and visualizations to support assurance mapping, the audit universe, risk assessment, planning and reporting. The assignment will also include testing, documenting and supporting the handover of the developed solutions."
That's substantive.
Then "If you would like to know more about this consultancy, please review the complete Terms of Reference here: TMC0006537 External ToR.pdf" Could be a link; we can keep as a paragraph.
Then Minimum Requirements etc.
Let's capture Minimum Requirements block:
"Minimum Requirements Education: Completion of secondary/high school diploma or equivalent. Demonstrated proficiency in Power BI or similar visualization tools, use of AI and agentic AI tools such as Copilot, advanced Excel, data structuring and analysis, automation, and working with large or complex datasets.Analytical foundation in data analytics, business intelligence, economics, finance, mathematics, statistics, computer science, information systems, or another relevant quantitative/analytical field.Work Experience:At least two years of relevant work experience in data analytics, data management, business intelligence, data visualization, analytical research or other related areas. Relevant experience may include internships, academic projects or other practical assignments involving data extraction, structuring, analysis and presentation.Skills:Strong proficiency in Excel and Power BI or similar business intelligence/data visualization tools; experience in cleaning, structuring and integrating data from multiple sources; ability to develop dashboards and automated analytical solutions; strong analytical and problem-solving skills; and ability to document analytical processes and present data clearly to non-technical users.Language Requirements:Fluency in English is required.Desirables: Experience with Python, SQL, PowerShell or other data automation tools; familiarity with audit, assurance, risk management or performance reporting; and experience working with large or complex organizational datasets."
We need to split.
Education: "Completion of secondary/high school diploma or equivalent."
Analytical foundation: maybe part of Education/Requirements.
Work Experience: "At least two years of relevant work experience..."
Skills: list.
Language Requirements: "Fluency in English is required."
Desirables: list.
Now we need to output HTML.
We'll produce:
About the role
UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the
Requirements
. Skills underSkills
. Language Requirements could be part of Requirements or Skills; maybe include under Requirements as a bullet. Desirables could be underQualifications
(preferred qualifications). Or we could combine Qualifications and Skills. But we need to avoid thin sections. Let's create: - Requirements: Education, Work Experience, Language Requirements. - Skills: Technical skills (Excel, Power BI, etc.) - Qualifications: Desirables (Python, SQL, etc.) maybe also mention analytical foundation? Actually analytical foundation is part of Minimum Requirements; could be under Requirements as well. But we need to preserve all substantive info. Let's structure:About the role
with paragraph(s) about UNICEF mission and consultancy purpose? Actually the "How can you make a difference?" is more about the role. Could combine with About the role. Better:About the role
includes description of consultancy purpose and tasks? But we already have Responsibilities separate. Usually About the role is overview; Responsibilities are detailed duties. So we can put overview in About the role: The purpose of the consultancy is to strengthen OIAI’s data analytics... etc. That's a good overview. Then Responsibilities: list of specific work items. Then Requirements: Education, Work Experience, Language Requirements. Then Skills: Proficiency in Excel and Power BI, data cleaning, dashboard development, analytical problem solving, documentation, presentation. Then Qualifications: Desirables (Python, SQL, PowerShell, audit familiarity, large dataset experience). We should not include Benefits, Pay, Schedule because not mentioned. We must not include boilerplate like "For every child, the right to care" maybe part of About the role but it's okay. We must remove cookie/navigation/legal/EEO etc. The text includes many EEO statements: "UNICEF encourages applications from all qualified candidates..." etc. Those are boilerplate; we should remove them. Also remove lines about background checks, accessibility, etc. Also remove "UNICEF does not hire candidates who are married to children..." etc. Also remove "Qualified candidates are invited to submit the following documents..." etc. Also remove "Remarks: If the TOR or financial proposal documents are not downloadable..." etc. Also remove "UNICEF does not charge a processing fee..." etc. Also remove "Additional information about working for UNICEF can be found here." etc. We must preserve substantive info: the consultancy description, requirements, skills, desirables. Let's extract substantive paragraphs: From start: "UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the world. We welcome everyone who wants to belong and grow in a diverse and passionate culture, coupled with an attractive compensation and benefits package. Visit our website to learn more about what we do at UNICEF. For every child, the right to care" That's generic but maybe we keep as About UNICEF? It's not role-specific but could be considered About the role? Might be considered boilerplate but it's about organization; maybe we can keep short. Then "How can you make a difference? The purpose of the consultancy is to strengthen OIAI’s data analytics and business intelligence capabilities by developing a semi-automated or automated and sustainable approach to assurance mapping and related audit analytics. The assignment will focus on enhancing the existing assurance mapping model and developing a dynamic analytical solution, preferably using Power BI or similar technology, to facilitate the integration, analysis, visualization and updating of assurance coverage data. The consultancy will also develop analytical tools and outputs that can be applied to related OIAI processes, including the audit universe, risk assessment, audit planning and annual reporting. The assignment is temporary and output-based, with defined analytical products, milestones and knowledge-transfer deliverables to be completed within the consultancy period. The consultant will support further development of OIAI’s assurance mapping and related audit analytics. The work will include maintaining and enhancing the existing Excel-based assurance map; consolidating and integrating relevant assurance and audit data; developing a more automated and dynamic solution, preferably in Power BI or similar technology; and producing analytical tools and visualizations to support assurance mapping, the audit universe, risk assessment, planning and reporting. The assignment will also include testing, documenting and supporting the handover of the developed solutions." That's substantive. Then "If you would like to know more about this consultancy, please review the complete Terms of Reference here: TMC0006537 External ToR.pdf" Could be a link; we can keep as a paragraph. Then Minimum Requirements etc. Let's capture Minimum Requirements block: "Minimum Requirements Education: Completion of secondary/high school diploma or equivalent. Demonstrated proficiency in Power BI or similar visualization tools, use of AI and agentic AI tools such as Copilot, advanced Excel, data structuring and analysis, automation, and working with large or complex datasets.Analytical foundation in data analytics, business intelligence, economics, finance, mathematics, statistics, computer science, information systems, or another relevant quantitative/analytical field.Work Experience:At least two years of relevant work experience in data analytics, data management, business intelligence, data visualization, analytical research or other related areas. Relevant experience may include internships, academic projects or other practical assignments involving data extraction, structuring, analysis and presentation.Skills:Strong proficiency in Excel and Power BI or similar business intelligence/data visualization tools; experience in cleaning, structuring and integrating data from multiple sources; ability to develop dashboards and automated analytical solutions; strong analytical and problem-solving skills; and ability to document analytical processes and present data clearly to non-technical users.Language Requirements:Fluency in English is required.Desirables: Experience with Python, SQL, PowerShell or other data automation tools; familiarity with audit, assurance, risk management or performance reporting; and experience working with large or complex organizational datasets." We need to split. Education: "Completion of secondary/high school diploma or equivalent." Analytical foundation: maybe part of Education/Requirements. Work Experience: "At least two years of relevant work experience..." Skills: list. Language Requirements: "Fluency in English is required." Desirables: list. Now we need to output HTML. We'll produce:About the role
UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. At UNICEF, we are committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF is a place where careers are built. We offer our staff diverse opportunities for professional and personal development that will help them reinforce a sense of purpose while serving children and communities across the