About the Role
We are looking for a skilled Engineer to join our data team. The ideal candidate will play a key role in designing, building, and optimizing data pipelines and data models that empower our organization to make data-driven decisions. They will work closely with teams across the organization, including kitchen managers, warehouse staff, and the BI team, to integrate data from multiple sources and ensure data quality and accuracy.
Key Responsibilities:
ETL/ELT Pipeline Development
Assist in designing, developing, and maintaining ETL/ELT pipelines to support data flow from kitchens, warehouses, and schools into the central data warehouse.
Monitoring of data pipelines and processes.
System Integration
Integrate new data sources, such as kitchen management systems and payment platforms, into the existing data architecture and warehouse.
Data Quality Assurance
Conduct regular data audits to maintain consistency and accuracy across all data sets.
Implement validation checks within pipelines to identify and resolve data issues proactively.
Review and assist in implementing data experiment results and findings
Collaboration and Support
Assist in training and supporting team members in using data tools and interpreting data reports.
Collaborate with Senior Data Engineer in implementing the data strategy and policies
Documentation
Maintain comprehensive documentation of data models, ETL/ELT processes, and integration procedures.
Contribute to the creation of user guides and best practices for data handling within the organization.
Requirements
Skills and Qualifications:
Technical Skills:
Knowledge in SQL for data analysis, query optimization, and ad-hoc reporting.
Hands-on experience with ETL/ELT tools and data pipeline development.
Knowledge of data modeling and database design principles.
Familiarity with cloud-based data platforms such as Google BigQuery, AWS, or Azure is an added advantage
Experience in integrating data from multiple sources.
Soft Skills:
Strong analytical and problem-solving skills.
Excellent communication and collaboration skills, with the ability to work with cross-functional teams.
Attention to detail and a proactive approach to identifying data issues.
Preferred Experience:
2-3 years of experience in data driven environment
Bachelor's degree in Computer related field
Experience working with BI tools like Tableau or Power BI is and added Advantage
Knowledge of data quality assurance and data validation techniques.
Prior experience in the non-profit or education sector is a plus.