Senior BI Developer

Job Description

Job purpose

Designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs.

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