Data Analytics engineer
Administers and optimizes enterprise databases (SQL Server, PostgreSQL) while developing complex SQL, ETL pipelines, and data warehouse structures, and builds BI dashboards and reports (Power BI, Tableau) to support customer decision-making at ROAM Africa in Accra.
- Compensation
- GHS 4K–GHS 5K
- Location
- Accra, Ghana
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Data analytics
- Posted
Skills
Must have
- Bachelor's Degree in Computer Science, Information Technology, Statistics and Data Science, or related field
- Minimum 2-5 years' experience in database administration, SQL development, or data analytics
- Microsoft SQL Server
- PostgreSQL
- SQL scripting
- Query optimization
- Stored procedures, triggers, views, and functions
- Database indexing
- Performance tuning
- Backup and recovery
- Power BI
- Tableau
- Data modeling
- Dashboard development
- KPI reporting
- Statistical and trend analysis
- ETL development
- Data transformation
- Data warehousing
- API integrations
- Strong analytical and problem-solving skills
- Excellent attention to detail
- Good communication and presentation skills
- Ability to work independently and within teams
- Ability to explain technical information to non-technical users
- Ability to work under pressure and meet targets
Nice to have
- Professional certifications in SQL Server, PostgreSQL, Power BI, or Data Analytics
- Oracle Database
Full description
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