About the job Data Transformation Specialist
POSITION OVERVIEW
The Program Data Transformation Specialist leads initiatives to evolve Family Legacy’s data ecosystem from fragmented collections to integrated systems that enhance decision-making and program effectiveness. This position bridges analytical needs with technological capabilities to build cohesive data architectures and user-centered applications that directly strengthen our ability to serve vulnerable children. The role requires a systems thinker who can transform scattered information into unified insights while building the organization’s capacity to collect, manage, and utilize data effectively.
REPORTING RELATIONSHIPS
Reports to :
- Primary : Monitoring, Evaluation and Research Manager
- Functional : ICT Manager
Collaborates with : Program directors, field staff, data collectors, and technology implementers
PURPOSE
Family Legacy exists to glorify God by empowering vulnerable Zambian children to live to the fullest expression of their God-given worth and potential. Through redemptive child development, we serve and educate vulnerable children in a holistic manner : spiritually, intellectually, physically, and emotionally.
The Program Data Transformation Specialist designs and implements solutions that transform our program data ecosystem from distributed collections into integrated systems that enhance program effectiveness and child outcomes. This position systematically addresses data fragmentation by developing unified databases, creating user-friendly collection tools, and establishing workflows that connect information across programs. By building coherent data architectures and application interfaces, this role ensures that critical program information is accessible, reliable, and actionable directly enhancing our capacity to measure impact and improve services to vulnerable children.
DIMENSIONS OF THE ROLE
The Program Data Transformation Specialist works at the intersection of program monitoring, data analysis, and technology implementation converting program measurement needs into practical digital solutions while ensuring data quality and accessibility. This position requires a deep understanding of how field-level data collection connects to program evaluation and decision-making, with the ability to design systems that function effectively in environments with varying connectivity and user technical proficiency. The role demands both analytical rigor and human-centered design thinking to create solutions that collect meaningful data while remaining practical for frontline implementation.
KEY RESPONSIBILITIES
1. Data System Architecture and Integration (30%)
Design and implement a unified data architecture that consolidates information from currently fragmented sourcesDevelop migration strategies to transition data from Google Sheets, Dropbox, and other distributed locations into structured databasesCreate data mapping frameworks that establish relationships between previously isolated datasetsImplement data validation protocols that ensure consistency across integrated systemsDevelop automated synchronization processes between field collection tools and central databasesDesign scalable database structures that accommodate program growthCreate standardized data models that enable cross-program analysisEstablish metadata frameworks that enhance searchability and contextImplement data versioning systems that maintain historical recordsDevelop integration pathways between program-specific and organization-wide systems2. Custom Application Development and Implementation (25%)
Design and develop field-appropriate data collection applications that improve data quality and timelinessCreate user-friendly dashboards that provide real-time program performance visualizationImplement mobile solutions that function effectively in environments with limited connectivityDevelop offline-capable applications that synchronize when connectivity is availableDesign workflow applications that standardize program processesImplement beneficiary tracking systems that monitor child progress across multiple programsCreate monitoring tools that streamline field data collectionDevelop solutions that minimize duplicate data entryImplement feedback collection mechanisms that capture beneficiary perspectivesDesign case management applications that enhance coordination of child services3. Data Quality and Governance (15%)
Establish organization-wide data standards and definitions to ensure consistencyImplement automated quality control processes that identify anomalies and inconsistenciesDevelop comprehensive data dictionaries that standardize terminology across programsCreate data cleaning protocols and tools for legacy and ongoing dataImplement classification systems that improve data organizationDevelop permission structures that balance accessibility with privacy protectionCreate longitudinal data linkage protocols that maintain child records over timeDevelop procedures for managing sensitive child informationImplement comprehensive data documentation systemsCreate data quality scorecards to track improvements over time4. Analytics and Reporting Solutions (15%)
Design and implement automated reporting systems that reduce manual compilationDevelop interactive visualization tools that make data accessible to non-technical usersCreate standardized report templates that ensure consistency in program reportingImplement advanced analytics capabilities that identify patterns in program dataDevelop predictive models that support early intervention in child developmentCreate outcome tracking systems that measure progress against goalsImplement comparative analysis tools that identify program improvement opportunitiesDevelop trend analysis capabilities that monitor changes over timeCreate beneficiary segmentation frameworks that enable targeted interventionsImplement impact measurement dashboards aligned with organizational objectives5. User Adoption and Capacity Building (10%)
Develop and deliver training programs that build staff capacity with new data systemsCreate user documentation and support resources tailored to different technical proficiency levelsImplement user testing protocols that ensure solutions meet field requirementsDevelop phased roll-out strategies that support successful adoptionCreate super-user programs that establish in-house expertiseDevelop context-appropriate training materials for field staffImplement user feedback mechanisms that inform continuous improvementCreate troubleshooting resources that support field-level problem resolutionDevelop data literacy programs that enhance staff analytical capabilitiesImplement change management strategies that support transition to new systems6. Research and Continuous Improvement (5%)
Research emerging data collection technologies relevant to development contextsEvaluate potential solutions against organizational constraints and requirementsConduct user research to identify pain points in current data processesDevelop measurement frameworks for system effectivenessImplement systematic user feedback collection to guide improvementsCreate innovation testing protocols for evaluating new approachesDevelop efficiency metrics that quantify process improvementsResearch best practices in development-sector data managementConduct regular system reviews to identify enhancement opportunitiesImplement A / B testing methodologies for interface improvementsQUALIFICATIONS AND EXPERIENCE REQUIRED
Educational Requirements
Bachelor’s degree in Information Systems, Data Science, Computer Science, or related fieldProject Management Certification will be an advantageTraining in database architecture and managementCertifications in relevant data or application development technologiesExperience
Minimum 4 years experience working with program data in development organizationsDemonstrated success consolidating distributed data into unified systemsExperience developing practical applications for challenging implementation environmentsBackground in monitoring and evaluation data systemsExperience implementing mobile data collection solutionsProven track record transforming manual processes into digital workflowsExperience working with vulnerable populations data preferredBackground in designing user-centered solutions for varying technical proficiency levelsTechnical Knowledge
Strong database design and management capabilitiesExpertise in data migration and integration methodologiesProficiency in application development for resource-constrained environmentsUnderstanding of data governance principles and implementationKnowledge of data quality assurance methodologiesFamiliarity with offline-first application architectureUnderstanding of data security and privacy requirementsProficiency with data visualization techniques and toolsKnowledge of development sector data standardsUnderstanding of appropriate technology principlesProfessional Skills
Excellence in translating program needs into technical requirementsStrong analytical thinking and problem-solving abilitiesOutstanding data modeling and systems thinking capabilitiesExcellent communication skills, particularly explaining technical conceptsStrong documentation and knowledge management abilitiesAbility to balance ideal solutions with practical constraintsExcellent stakeholder management and requirement gathering skillsStrong project management capabilitiesAbility to work effectively with both technical and non-technical teamsCultural sensitivity and contextual awarenessCORE COMPETENCIES
Systems Architecture Thinking
Ability to design cohesive data ecosystems from fragmented componentsExcellence in identifying integration pathways between disparate systemsSkill in developing scalable data models that accommodate future needsCapacity to balance immediate solutions with long-term architecture goalsHuman-Centered Design
Strong ability to develop solutions based on user needs and constraintsExcellence in creating interfaces appropriate for varying technical literacy levelsSkill in optimizing user experiences for challenging implementation environmentsCapacity to design solutions that minimize burden on data collectorsData Quality Leadership
Ability to establish and maintain high data quality standardsExcellence in designing validation processes that ensure reliable informationSkill in developing practical quality assurance protocolsCapacity to build organizational culture that values data integrityAdaptive Problem Solving
Strong ability to develop creative solutions for resource-constrained settingsExcellence in modifying approaches based on field realitiesSkill in balancing technical best practices with practical implementationCapacity to identify appropriate technology solutions for challenging contextsImplementation Excellence
Ability to manage successful transitions from concept to operational systemsExcellence in phased implementation approaches that build on successesSkill in supporting users through system transitionsCapacity to maintain focus on improving child outcomes through better dataWORKING ENVIRONMENT AND CONDITIONS
The position is based at the FLMZ Ibex Hill Office and requires :
Regular field visits to understand data collection realities at Legacy Academies and programsAbility to develop solutions that function in environments with connectivity challengesFlexibility to adapt approaches based on user feedback and field constraintsCommitment to creating systems that ultimately improve services to vulnerable childrenWillingness to balance technical ideals with practical implementation realitiesPERFORMANCE MEASURES
Success in this role will be measured by :
Successful consolidation of fragmented data into unified, accessible systemsImprovement in data quality, completeness, and timelinessIncreased efficiency in program monitoring and reporting processesDevelopment and adoption of practical field data collection applicationsReduction in manual data processing requirementsEnhanced analytical capabilities across the organizationImproved data accessibility for decision-makingUser satisfaction with implemented solutionsContribution to improved program outcomes through better data utilizationDevelopment of sustainable, maintainable data systems