Data Engineer at CloudFactory in Nairobi, Kenya

    CloudFactory logo

    Data Engineer

    CloudFactoryNairobi, Kenya

    Posted

    5 days ago

    Apply by

    1 Sept

    Contractor
    On Site
    Mid
    ICT & Telecommunications
    IT & Software

    Build your CV in minutes! Tailored for the Kenyan job market.

    Build My CV

    Job Description

    As a Data Engineer, you will build and maintain the data pipelines and models that power CloudFactory's reporting and analytics. You will work with tools such as Fivetran, DBT, Snowflake, and Python to extract, transform, and model data, while ensuring data quality, security, and governance standards are consistently met. This is a great opportunity to grow your data engineering expertise within a mission-driven, fast-scaling organization.

    Key Responsibilities

    • Develop data pipelines in Fivetran to extract data from common data sources.
    • Write Python scripts, using libraries such as Pandas, for data cleaning and transformation.
    • Create data models in DBT with transformations and joins between tables.
    • Implement data quality checks in DBT and Snowflake to identify and address data quality issues.
    • Follow established data governance practices, including access controls and documentation procedures.
    • Monitor data pipelines for errors or inconsistencies, reporting issues to senior engineers.
    • Design and document conceptual and logical data models for well-defined datasets, considering star schema or data vault principles.
    • Apply data normalization techniques and select appropriate data types based on data characteristics.
    • Collaborate with stakeholders to understand their data needs and identify potential model improvements.
    • Create data visualizations in QuickSight or Tableau to explore and communicate data insights.
    • Select appropriate chart types and apply dashboard design principles for effective communication.
    • Take ownership of designing and implementing moderately complex data engineering tasks, identifying dependencies and risks during planning.
    • Write integration tests to verify how code interacts with other parts of the data pipeline.
    • Adhere to established data security and compliance protocols while handling data.
    • Follow data access control procedures and complete required data security and compliance training.

    Required Qualifications

    • Good understanding of data engineering concepts, data transformation techniques, and tools such as Fivetran, DBT, Snowflake, and QuickSight or Tableau.
    • Proficient in Python, including libraries such as Pandas, for data cleaning and transformation.
    • Experience building and maintaining data pipelines from common data sources.
    • Understanding of data modelling methodologies and normalization principles for data warehousing.
    • Experience implementing data quality checks and following data governance practices.
    • Familiarity with data visualization tools and best practices for effective dashboards.
    • Strong SQL skills for querying and transforming data.
    • Good communication skills, able to collaborate with stakeholders on data requirements.
    • Bachelor's degree in Computer Science, Data Engineering, or a related field, or equivalent practical experience.
    • 2–4 years of experience in data engineering or a related role.
    • Experience with Snowflake performance optimization.
    • Exposure to workflow orchestration tools.
    • Familiarity with data governance frameworks.

    Job Details

    Job Function

    IT & Software

    Minimum Experience

    2 years

    Education Level

    Bachelor’s Degree

    Area of Study

    Computer Science

    Field of Study

    Computer Science

    Languages

    English

    Additional Information

    How to Apply: Visit the application link provided on this page to submit your application.

    Show Your Pipeline Craft in the Interview

    Data engineering roles at CloudFactory are hands-on. They want to see that you can build reliable pipelines, not just talk about them. Be ready to walk through your past projects and the trade-offs you made.

    1. Prepare a pipeline walkthrough: Pick a past data pipeline you built and explain the architecture, the tools used, and the challenges you faced. Focus on how you ensured data quality and handled failures. This shows your practical experience.

    2. Brush up on DBT and Snowflake: Since these are core tools, be ready to discuss how you've used them. Mention specific features like DBT tests, Snowflake clustering, or performance tuning. If you haven't used them, show that you understand their concepts and are eager to learn.

    3. Highlight your Python skills: Be prepared to write or explain Python code for data cleaning and transformation. Emphasize your use of Pandas and any other relevant libraries. Show that you write clean, efficient code.

    4. Show your SQL fluency: Expect SQL questions on joins, aggregations, and window functions. Practice writing complex queries and be ready to explain your thought process. Strong SQL is a must for this role.

    5. Demonstrate data modeling knowledge: Be ready to discuss star schemas, data vaults, and normalization. Explain how you decide on a modeling approach for a given dataset. This shows you think about the big picture.

    6. Talk about data governance: Mention your experience with access controls, documentation, and compliance. Show that you take data security seriously. This is critical for a company like CloudFactory.

    7. Prepare for behavioral questions: Expect questions about collaboration with stakeholders and handling conflicting priorities. Use the STAR method to structure your answers. Show that you can communicate technical concepts to non-technical people.

    8. Ask smart questions: Prepare a few questions about their data stack, team structure, and current challenges. This shows your genuine interest and helps you assess if the role is a good fit.

    CareerSasa Safety Alert: Never pay employers or agencies for interviews, training, or job placement. Does a job request payment? Report it immediately using the "Flag" button. While CareerSasa vets job postings thoroughly, always verify opportunities independently.
    Share this job:

    Boost Your Application Success

    1. 1

      Expert CV help that gets you noticed. Build Your CV

    2. 2

      A personalized cover letter for this role. Write Cover Letter

    3. 3

      Attract recruiters with a stronger profile. Boost LinkedIn

    Tags

    Fivetran
    DBT
    Snowflake
    Python
    SQL