Skip to main content

• Help Log in ReliefWeb

  Content Search

  What are you looking for?
  • Updates
  • Countries
  • Disasters
  • Organizations
  • Topics
  • Jobs
  • Training Informing humanitarians worldwide 24/7 — a service provided by UN OCHA

    Kenya

    ERP Data Migration Specialist

    Organization

    • International Rescue Committee

    Posted

    31 Jan 2024

    Closing date

    30 Jun 2024

    The International Rescue Committee (IRC) responds to the world’s worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and more than 25 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees delivers lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future.

    The IT department supports the organization’s work by providing reliable and scalable applications and infrastructure for the IRC’s offices in the US and around the world, including many technologically challenging locations.

    Job Overview/Summary

    The IT department supports the organization’s work by providing reliable and scalable applications and infrastructure of the IRC’s offices in the US and around the world. An integral component of this effort is the implementation of an ERP solution, Microsoft Dynamics 365 for Operations.

    The ERP Data Management Specialist is focused on ensuring the successful conversion of legacy data into the ERP system, and ongoing operations of ETL processes. Primary responsibilities include data conversions, mapping from legacy systems, and assisting with development and operations of automated ETL systems in support of ERP, ability to solve and provide guidance on data issues, data analysis, data quality management, developing business rules, and ad-hoc data reporting.

    Major Responsibilities

    • Develop, handle, and implement data mapping and conversions for imports of master and historical data. Participate in automated ETL design, implementation, testing, performance tuning, documentation, and operational management.

    • Perform analysis, cross-referencing, merging, and consolidation of data from various sources. Collaborate with staff and vendors, including Data Architect, System Architects, and Business System Managers to contribute to current and future design, implementation, and documentation of data, metadata, and overall systems data architecture.

    • Collaborate with QA teams to ensure appropriate technical and business testing of data conversion and ETL operations. Support as necessary the daily administration and performance of the IRC’s systems for users throughout IRC’s field and headquarters operations and external partners

    • Build and maintain systems documentation including processes and procedures, data architecture, functionality, security, and policies. Perform third-level support functions for IRC business systems.

    • Coordinate data migration activities, across various functional groups, globally. Contact person for any kind of issues, raised by end users, with respect to data.

    Key Working Relationships

    **Position Reports to:**Senior Technical Services Manager

    **Position directly supervises:**N/A

    Indirect Reporting: N/A

    Other Internal and/or external contacts:

    Internal:
    • Applications Group team members, in particular Data Architect, Software Development Manager

    • Project Business Owners, business project team members outside IT, and wider stakeholders

    • Subject Matter Experts across other departments

    • Project Managers and Project Coordinators in the Project Management team

    External:

    • Vendors and Consultants

    Required Skills

    • Bachelor’s degree or equivalent experience

    • 3+ years of proven ability working with SQL queries, stored procedures.

    📚 𝗗𝗶𝘀𝗰𝗼𝘃𝗲𝗿 𝗛𝗼𝘄 𝘁𝗼 𝗚𝗲𝘁 𝗮 𝗝𝗼𝗯 𝗶𝗻 𝘁𝗵𝗲 𝗨𝗡 𝗶𝗻 𝟮𝟬𝟮𝟯! 🌍🤝 𝗥𝗲𝗮𝗱 𝗼𝘂𝗿 𝗡𝗘𝗪 𝗥𝗲𝗰𝗿𝘂𝗶𝘁𝗺𝗲𝗻𝘁 𝗚𝘂𝗶𝗱𝗲 𝘁𝗼 𝘁𝗵𝗲 𝗨𝗡 𝟮𝟬𝟮𝟯 𝘄𝗶𝘁𝗵 𝘁𝗲𝘀𝘁 𝘀𝗮𝗺𝗽𝗹𝗲𝘀 𝗳𝗼𝗿 𝗨𝗡𝗛𝗖𝗥, 𝗪𝗙𝗣, 𝗨𝗡𝗜𝗖𝗘𝗙, 𝗨𝗡𝗗𝗦𝗦, 𝗨𝗡𝗙𝗣𝗔, 𝗜𝗢𝗠 𝗮𝗻𝗱 𝗼𝘁𝗵𝗲𝗿𝘀! 🌐

    ⚠️ 𝐂𝐡𝐚𝐧𝐠𝐞 𝐘𝐨𝐮𝐫 𝐋𝐢𝐟𝐞 𝐍𝐨𝐰: 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐓𝐞𝐜𝐡𝐧𝐢𝐪𝐮𝐞𝐬 𝐡𝐨𝐰 𝐭𝐨 𝐠𝐞𝐭 𝐚 𝐣𝐨𝐛 𝐢𝐧 𝐭𝐡𝐞 𝐔𝐧𝐢𝐭𝐞𝐝 𝐍𝐚𝐭𝐢𝐨𝐧𝐬 𝐍𝐎𝐖!

    • 3+ years of data analysis, conversions, source to target mappings, testing, and operations.

    • 1+ years of experience with automated ETL tools

    • 1+ years of experience working D365 Finance and operation product, in terms of loading data.

    • Familiar with the concepts of Entity, and able to solve data errors.

    • Solid grasp of data quality concepts and processes

    • Strong with Microsoft Excel

    • Experience with full lifecycle ERP implementations and typical master data requirements

    • Ability to constantly learn and adapt to new technologies.

    • Proven interpersonal skills in both verbal (i.e. day-to-day discussions, team meetings, workshops) and written (requirements and design specifications) form, as well as an overall ability to be clear and concise in all communications.

    • Strong analytic curiosity and innovative problem-solving skills.

    • Good active listening skills and solid attention to detail

    • Strong presentation and interpersonal skills

    • Demonstrable ability to work both independently and in a dynamic, multi-functional team structure.

    • Demonstrable ability to work both independently and in a dynamic, multi-functional team structure.

    Preferred Additional Qualifications

    • Knowledge of Microsoft 365 for Finance and Operations (formerly AX) related data structures and entities

    • Software development experience, some programming experience.

    • Working knowledge of Microsoft Access

    • Working proficiency of data modeling, normalization, entity-relationship diagrams, star schemas, data warehousing, entity models, and other data design concepts

    • Experience with Business Intelligence tools and methods such as PowerBI, and Tableau

    • Experience with Data management framework, with D365 Finance and operation product.

    • Experience in the NGO sector in the delivery of systems across varying IT infrastructure and low/intermittent bandwidth scenarios

    Working Environment

    • Standard office working environment.

    • Some international travel as needed.

    **Standard of Professional Conduct:**The IRC and the IRC workers must adhere to the values and principles outlined in the IRC Way – our Code of Conduct. These are Integrity, Service, Accountability, and Equality.

    Commitment to Gender, Equality, Diversity, and Inclusion: The IRC is committed to creating a diverse, inclusive, respectful, and safe work environment where all persons are treated fairly, with dignity and respect. The IRC expressly prohibits and will not tolerate discrimination, harassment, retaliation, or bullying of the IRC persons in any work setting. We aim to increase the representation of women, people that are from country and communities we serve, and people who identify as races and ethnicities that are under-represented in global power structures.