Duties and responsibilities
- Consolidate and optimize available data warehouse infrastructure
- Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
- Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
- Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard
- Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
- Carry out monitoring, tuning, and database performance analysis
- Perform the design and extension of data marts, meta data, and data models
- Ensure all data warehouse architecture codes are maintained in a version control system
Job Requirements
Soft Skills
- Good work ethics
- Good English Language
- Good Communication Skills
- Good Analytical Skills
- Team Player with Excellent Team Spirit
- Good Estimation Skills
- Positive and Self-motivated
- Good Problem Solving Skills
- High Ownership
- Good Time Management Skills
- Excellent Estimation Skills
- Technical Writing Skills
- Self-managed and Self-motivated
- Proactive
General Technical Skills
- Remarkable experience with SQL Server 2008 and above
- Remarkable experience with Extraction, Transformation and Loading (ETL) using SSIS and stored procedures
- Remarkable experience with SSRS and stored procedures
- Remarkable experience with OLAP Cube Development (Microsoft SSAS and MDX)
- Remarkable experience in writing complex SQL/MDX queries
- Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
- High proficiency in dimensional modeling techniques and their applications
- Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel