Business Intelligence Consultant - Petaling Jaya, Malaysia - Nityo Infotech

    Nityo Infotech
    Nityo Infotech Petaling Jaya, Malaysia

    2 weeks ago

    Default job background
    Description
    Mandatory and extensive skillsets: SSIS, SSRS, SSAS, data warehousing

    Experience Required

    5 - 7 Years

    Industry Type

    IT

    Employment Type

    Permanent

    Location

    Malaysia

    Required Skills

    -MySQL SSIS & SSRS

    Roles & Responsibilities

    Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders. Direct, organize, and lead projects in the implementation and use of new BI software tools and systems. Lead the integration efforts for merging BI platforms with enterprise systems and applications. Design, code, test, and document all new or modified BI systems, applications, and programs. Develop the semantic layer, metadata, reports, and report definitions. Develop graphs and portal interfaces. Assist in the design of databases and data warehouses to ensure interoperability with BI solutions. Analyze user requirements and, based on findings, design functional specifications for BI front end applications.Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system. Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion. Conduct job duties and responsibilities according to the organization's business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology. Design and deliver end-user training and training materials; provide technical support as necessary. Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary. Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments. Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions. Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts. Mentor and/or provide leadership to junior members of the team.

    Expertise & Qualification

    Degree or higher in the field of computer science, information systems, or computer engineering or related field.  Good knowledge in Database Design  Passionate in understanding data  Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.  Experience with tier-one applications, databases, and data warehouses, such as Oracle 11g, MS SQL Server, Crystal, SAP, SCM, and so on.  Strong ability to analyze user requirements. Possess strong logical thinking  Experienced in Data Warehousing Project or knowledge in Data Warehousing Lifecycle is an added advantage  Strong knowledge in SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services  Fresh graduates or candidates without experience, but with good attitude and ability to learn quickly are encouraged to apply.