Data Analytics engineer
NewBe an early applicantSummary
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.
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
Salary: GHS 4,000 - GHS 5,000
Other Benefits: SSNIT, 13th Month Salary, & Performance Incentives