Database & Business Intelligence (Data Analytics Engineer)

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

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.

Location: Accra

Salary: Attractive