Data Analytics engineer
Job Summary
- 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
- 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.
Required Skills:
* 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. * SQL & Database Skills * Database Technologies * Analytics & BI Skills * Data Engineering Skills * Professional certifications in SQL Server PostgreSQL Power BI or Data Analytics will be an added advantage.
Required Education:
Bachelors Degree in: Computer Science Information Technology Statistics and Data Science or related field