Role Description

• This is a full-time on-site role for a Data Analyst Engineer at Sight and Sound Computers Limited in Nairobi County, Kenya.

Duties

• Data Pipeline development
• Data Integration: ensuring data consistency, quality, and timeliness.
• Data Warehousing: Optimize data warehouse performance for efficient querying and reporting.
• Data Modeling: Develop and maintain data models, including dimensional and relational models, to support data analytics and reporting needs.
• ETL (Extract, Transform, Load)
• Data Quality and Governance: Implement data quality checks and data validation procedures to identify and address data issues.
• Data Security: Implement security measures to protect sensitive data, including encryption, access controls, and data masking techniques.
• Performance Tuning: Optimize database and data processing systems for performance, including indexing, query optimization, and hardware scaling.
• Data Cataloging and Metadata Management
• Data Versioning and Change Management
• Streaming Data Processing
• Cloud Data Platforms: Work with cloud-based data platforms: Microsoft Azure, or Google Cloud to build and manage data solutions in the cloud.
• Database Administration: backup and recovery, user management, and system monitoring.
• Documentation and Knowledge Sharing: Document data engineering processes, best practices, and solutions for knowledge sharing and team collaboration

Required Qualifications

• Degree in Information Technology, Computer Science, Statistics, Data Science
• Have experience with BI tools and systems such as Power BI, Tableau, and SAP.
• Must have minimum 1 year of experience in data-specific roles.
• Knowledge in Microsoft BI Stack
• Grip over data analytics
• Should possess software development skills