Our client in the NGO sector is seeking a talented and experienced Data Analytic Engineer to support its research team. As the organization’s first Data Analytic Engineer, you will be tasked with building their data systems from the ground up. You’ll work closely with stakeholders to design, develop, and maintain scalable data pipelines while also identifying the best data architecture, tools, and strategies to meet the organization’s unique needs.

In this critical role, you will set up and manage data warehouses, ensure data access and security, and lead compliance with data privacy regulations. Additionally, you’ll be responsible for generating and maintaining clear documentation, including data dictionaries, to ensure org-wide clarity on available data, metrics, and reporting capabilities.

Key Responsibilities:

• Lead the development of the client's data infrastructure, designing and building data pipelines (ELT/ETL) to ingest, clean, and transform data from sources such as geospatial data, survey data, and qualitative data from focus groups.
• Collaborate with stakeholders to design and implement the most effective data architecture, tools, and system designs to meet the organization’s objectives.
• Create and maintain detailed documentation of the data systems, including data flow diagrams, process documentation, and best practices for data management.
• Build and maintain data warehouses, ensuring they are scalable, secure, and support the organization’s data-driven initiatives.
• Establish and maintain clear data dictionaries to provide organization-wide clarity on available data, metrics, and reporting standards.
• Define and manage data access controls and security roles, ensuring appropriate access while safeguarding sensitive data.
• Ensure compliance with data privacy laws and regulations, including GDPR and other relevant standards.
• Select and implement appropriate tools for data ingestion, storage, transformation, and visualization, ensuring seamless integration with BI tools and custom visualization platforms.
• Monitor and optimize data pipeline performance, resolving any issues that arise and ensuring data accuracy and reliability.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
• Proven experience in designing and building data pipelines (ELT/ETL) from the ground up, ideally as part of a small or growing team.
• Strong SQL skills and experience with relational databases.
• Experience setting up and managing data warehouses, data access controls, and security protocols.
• Proficiency in creating and documenting data models (ERDs) and designing scalable database schemas.
• Experience working with geospatial data, survey data, and qualitative datasets.
• Familiarity with data privacy and security regulations, including GDPR, and experience implementing compliant data systems.
• Strong ability to generate and maintain documentation, including data dictionaries, to ensure clarity and consistency across the organization.
• Knowledge of data visualization tools and techniques, especially experience supporting BI tools.

Preferred Skills:

• Experience in data analytics, data warehousing, and working in nonprofit or research environments.
• Familiarity with tools like Python, R, GIS tools, and ETL frameworks.
• Previous experience working with data related to informal settlements, marginalized communities, or developing regions.