Data Analytics engineer

• Advanced SQL Development
  
• Develop and maintain:
  
• Complex SQL scripts
  
• Stored procedures
  
• Database functions
  
• Views
  
• ETL processes
  
• Batch processing scripts
  

• Complex SELECT statements
  
• JOIN operations
  
• Window functions
  
• Common Table Expressions (CTEs)
  
• Dynamic SQL queries
  

• Data synchronization
  
• Scheduled reporting
  
• Data validation
  
• Data cleansing
  
• Reporting pipelines
  

• Data warehouse development
  
• Data transformation
  
• Data mart creation
  
• Aggregation and analytics structures
  

• Analyze operational and transactional data to identify:
  
• Trends
  
• Patterns
  
• KPIs
  
• Exceptions
  
• Risk indicators
  
  

• Executive dashboards
  
• KPI scorecards
  
• Operational reports
  
• Drill-down analytics reports
  
• Trend and performance reports
  

• Design and maintain:
  
• Star schemas
  
• Dimensional models
  
• Data marts
  
• Reporting structures
  

• Implement and monitor:
  
• Data validation rules
  
• Duplicate detection
  
• Data consistency checks
  
• Data cleansing processes
  

• Data standards
  
• Naming conventions
  
• Metadata documentation
  
• Data structure documentation
  

Requirements

• Bachelors Degree in: Computer Science Information Technology Statistics and Data Science or related field
  
• Minimum of 25 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