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