Data Analytics engineer

Job summary

A Data Analytics Engineer is responsible for the administration, optimization, security, and analysis of enterprise databases, as well as developing business intelligence, reporting, and data-driven decision-making for the Company's Customers. The role combines: Database Administration (DBA), Advanced SQL Development, Data Analytics, Business Intelligence Reporting, and Data Engineering.

The successful candidate will play a key role in ensuring the availability, integrity, performance, and reliability of data systems, while developing insightful dashboards and analytics solutions to support customer decision-making.

Key Responsibilities

SQL Development & Data Engineering Advanced SQL Development Develop and maintain: Complex SQL scripts Stored procedures Database functions Views ETL processes Batch processing scripts Query Optimization Write and optimize: Complex SELECT statements JOIN operations Window functions Common Table Expressions (CTEs) Dynamic SQL queries Data Automation Develop automated processes for: Data synchronization Scheduled reporting Data validation Data cleansing Reporting pipelines Data Warehousing Support Assist in: Data warehouse development Data transformation Data mart creation Aggregation and analytics structures Data Analytics & Business Intelligence Data Analysis Analyze operational and transactional data to identify: Trends Patterns KPIs Exceptions Risk indicators Dashboard & Reporting Develop and maintain dashboards and reports using the Company’s BI tool: To develop: Executive dashboards KPI scorecards Operational reports Drill-down analytics reports Trend and performance reports Business Intelligence Support Design and maintain: Star schemas Dimensional models Data marts Reporting structures Data Quality & Governance Data Quality Management Implement and monitor: Data validation rules Duplicate detection Data consistency checks Data cleansing processes Data Governance Maintain: Data standards Naming conventions Metadata documentation Data structure documentation Requirements Required Qualifications Bachelor’s Degree in: Computer Science, Information Technology, Statistics and Data Science, or related field Minimum of 2–5 years’ experience in database administration, SQL development, or data analytics.

Professional certifications in SQL Server, PostgreSQL, Power BI, or Data Analytics will be an added advantage. Required Technical Skills: Database Technologies Microsoft SQL Server PostgreSQL Oracle Database (advantage) SQL & Database Skills Strong knowledge in: SQL scripting Query optimization Stored procedures Triggers Views Functions Database indexing Performance tuning Backup and recovery Analytics & BI Skills Power BI Tableau Data modeling Dashboard development KPI reporting Statistical and trend analysis Data Engineering Skills ETL development Data transformation Data warehousing API integrations Soft Skills Strong analytical and problem-solving skills Excellent attention to detail Good communication and presentation skills Ability to work independently and within teams Strong business and reporting mindset Ability to explain technical information to non-technical users Creativity and innovation Goal-oriented mindset Ability to work under pressure and meet targets Key Performance Indicators (KPIs): Performance for this role will be measured using: Database up time and availability Query performance optimization Report and dashboard delivery timelines Data accuracy and quality levels Reduction in data inconsistencies Efficiency of analytics reporting Customer satisfaction with reports and dashboards Ideal Candidate Profile The ideal candidate should: Have strong SQL scripting and database administration skills.

Be highly analytical and business oriented. Be capable of translating data into actionable business insights. Understand enterprise systems and reporting environments. Be proactive in identifying opportunities, trends, and operational risks through data analysis. Have experience working with business intelligence and analytics tools.

Benefits

GHS 4,000

• GHS 5,000 Other Benefits: SSNIT, 13th Month Salary, & Performance Incentives