Aviation Data Specialist Jeppesen ForeFlight builds industry-leading aviation software used by pilots, aircraft operators, and major airlines worldwide. As a high-growth, private equity-backed company, we are focused on scaling our operations, strengthening our financial infrastructure, and driving operational excellence across the business. Our team combines deep domain expertise with a collaborative, high-performance culture to solve complex challenges and support continued growth. This role is remote within the US. About the Role: We are looking for an Aviation Data Specialist to join our team. In this role, you will play a crucial part in enhancing and advancing solutions tailored for government and military clients, all in support of aviation safety initiatives. Our team is dedicated to analyzing global aeronautical data to create precise and timely Enroute navigation charts. Key Responsibilities: - Utilize established processes and tools to create and maintain geospatial assets that drive our mission forward. - Ensure that all assets meet stringent regulatory and contractual requirements, playing a vital role in our commitment to excellence. - Proactively seek clarification on any source or specification ambiguities. - Conduct thorough quality control checks to uphold the highest standards of data integrity and reliability. - Collaborate effectively with a remote team, leveraging technical guidance from senior members while embracing new software and adapting to evolving workflows. Basic Qualifications: - High School Diploma or equivalent. - Proficiency in GIS Mapping Software (e.g., ESRI ArcGIS and/or QGIS). - Strong computer skills, including Microsoft Office and online collaboration tools. - Experience working remotely. - Excellent communication and attention to detail. Preferred Qualifications - Background in piloting, navigating, flight planning, or navigation systems. - College degree in geography, cartography, geographic information systems, aviation, or a related field. - 1+ years of experience with GIS Mapping Software. Why You Should Join: At Jeppesen ForeFlight, we know you want a rewarding career. To do that, you need challenging projects, a good work environment, and awesome coworkers. We believe in our employees, and we empower them to make a direct impact on our products and services messaging. We strive to provide our employees with a world-class benefits experience, focused on supporting their physical, financial, and emotional wellbeing. Our benefits package includes but not limited to the following: - Medical, dental, vision insurance with Employer paid health premiums - Open PTO Policy - 401(k) with up to 10% company matching and immediate vesting - 12 Weeks Paid Maternity Leave - 4 Weeks Paid Paternity Leave - Flight Training Rewards Pay is based upon candidate experience and qualifications, as well as market and business considerations. Summary Pay Range: $65,000.00 to $75,000.00 Jeppesen ForeFlight - EOE including Disability/Vets | Pay Transparency | E-Verify Participant |

• Lead the design, development, testing, deployment, maintenance, and improvement of advanced data engineering solutions and pipelines. • Prioritize, manage, and deliver multiple high-impact projects. • Establish data quality standards — automated tests, anomaly detection, and freshness SLAs • Write and maintain dbt models, tests, and documentation to ensure data quality and consistency • Identify infrastructure improvements to reduce cost, improve reliability, and eliminate single points of failure • Build and govern canonical dbt models in Snowflake using dimensional modeling principles, ensuring consistent metric definitions and entity relationships across Looker and the MCP server for both BI and AI consumers • Own dbt model governance — standardize modeling patterns, enforce testing and documentation requirements, and manage the project structure across domains • Define and maintain a consistent semantic layer — metric definitions, business logic, and entity relationships — ensuring alignment across BI tools, the MCP server, and AI consumers regardless of the tooling layer • Support Snowflake administration/Looker administration alongside other data platform team members

• Diseñar y construir código optimizado y escalable para pipelines de datos complejos y distribuidos (batch y streaming), aplicando patrones de diseño de datos avanzados y promoviendo las mejores prácticas. • Diseñar e implementar estrategias de prueba robustas para pipelines y conjuntos de datos (incluyendo pruebas de calidad de datos), y guiar a otros en la escritura de pruebas de alta calidad. • Depurar problemas complejos en sistemas de datos distribuidos, identificando rápidamente la causa raíz de fallos de datos o pipelines. • Diseñar y optimizar sistemas de monitoreo y logging para garantizar la observabilidad completa de la plataforma de datos. • Diseñar modelos de datos complejos para data warehouses, data lakes o lake houses, y definir estrategias de modelado de datos. • Administrar y optimizar bases de datos y sistemas de almacenamiento de datos, y participar en la selección e implementación de tecnologías de infraestructura de datos (ej. Hadoop, Snowflake, Databricks, MS Fabric). • Implementar medidas de seguridad robustas en el desarrollo de pipelines de datos y comprender y contribuir a los conceptos de gobernanza de datos. • Proponer soluciones de datos que optimizan el valor y la eficiencia económica (ej. costo de almacenamiento, rendimiento de consultas, optimización de recursos). • Mentorizar activamente a Data Engineers junior y medianos en el equipo, compartiendo conocimientos avanzados y fomentando el crecimiento profesional. • Comunicar ideas técnicas complejas de datos de manera clara a audiencias diversas (técnicas y no técnicas), y dar retroalimentación constructiva y accionable sobre enfoques y soluciones de ingeniería de datos.

Role Description The organization’s global reporting ecosystem — including dashboards, data models, and analytical workflows — is a critical technical layer supporting Individual Giving (IG) performance monitoring, operational reporting, and decision‑making across Country Offices and National Committees. As SES adoption has matured, market demand has shifted from basic reporting to increasingly complex Power BI segmentations, Salesforce reports with advanced logic, and frequent changes to dashboards used for financial and operational processes. In parallel, Country Offices have reported the need to create reports outside SES, indicating gaps in consolidation and automation. The consultant will be responsible for stabilizing, consolidating, and modernizing the SES global IG reporting ecosystem, covering the full reporting stack from data models to dashboards and alignment across platforms. The scope includes 6 phases. (See TOR for details) Qualifications - Bachelor's degree in Data Science, Computer Science, Information Systems, Statistics, Engineering, Business Intelligence, or other related quantitative or technical fields. - 7+ years of experience in business intelligence, data modelling, analytics engineering, or similar technical functions. - Proven expertise in Power BI dataset design, including incremental refresh, partitions, DAX optimization, and metadata governance. - Strong experience with data warehousing, SQL, ETL/ELT, and transformation logic across multi‑market environments. - Experience aligning Salesforce reporting with BI/KPI frameworks. - Experience working within the UN system, UNICEF, or similar international organizations is an asset. - Demonstrated ability to automate and document financial or operational models. - Experience producing technical documentation, KPI definitions, SOPs, and dashboard or dataset specifications. - Ability to deliver training and capacity-building for non‑technical users. - Experience with UNICEF/INGO fundraising data and supporter/campaign structures. - Familiarity with Azure (Data Factory, Synapse, Databricks) and/or Python/R for analytical prototyping. - Understanding of AI governance, data ethics and privacy considerations. - Fluency in English (written and verbal) is required; knowledge of another UN language (e.g., Spanish, French, Arabic) is an asset. Requirements - UNICEF’s Core Values of Care, Respect, Integrity, Trust and Accountability and Sustainability (CRITAS). - Commitment to include everyone, irrespective of their race/ethnicity, disability, gender identity, sexual orientation, religion, nationality, socio-economic background, minority, or any other status. - UNICEF encourages applications from all qualified candidates, regardless of gender, nationality, religious or ethnic backgrounds, and from people with disabilities, including neurodivergence. - Reasonable accommodation for persons with disabilities throughout the recruitment process. - UNICEF does not hire candidates who are married to children (persons under 18). - Zero-tolerance policy on conduct incompatible with the aims and objectives of the United Nations and UNICEF. - All selected candidates will undergo rigorous reference and background checks. Benefits - Diverse opportunities for professional and personal development. - Attractive compensation and benefits package. Application Process - Qualified candidates are invited to submit the following documents via the online recruitment portal, TMS (Talent Management System): - An up-to-date TMS profile and curriculum vitae (CV) - Cover letter - A separate financial proposal - A detailed technical proposal - UNICEF does not charge a processing fee at any stage of its recruitment, selection, and hiring processes. - All UNICEF positions are advertised, and only shortlisted candidates will be contacted.