Business Intelligence Specialist

The Business Intelligence Specialist is responsible for aggregating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for very large multidimensional databases.

A.S. Bryden & Sons (Trinidad) Limited

 BUSINESS INTELLIGENCE SPECIALIST

Major Responsibilities and Accountabilities:

• Conducts research and makes recommendations on BI products, services and standards in support of procurement and development efforts
• Evaluates and selects database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools and database design solutions
•  Leads the integration efforts for merging BI platforms with enterprise systems and applications
• Develops the semantic layer, metadata, reports, and report definitions
• Designs, code, tests, and documents all new or modified BI systems, applications, and programs
• Assists in the design of databases and data warehouses to ensure interoperability with BI solutions
• Analyses user requirements and, based on findings, design functional specifications for BI front-end applications
• Produces ETL design guidelines to ensure a manageable ETL infrastructure for the BI system
• Designs and delivers end-user training and training materials; provide technical support as necessary
• Creates Management Views, reports that leverage the full feature set of BI to deliver information to meet user requirements with a focus on ease of use and intuitive navigation and use of best practices.
• Supports BI Architecture and server implementation.
• Supports any new installs and future upgrades within BI environments.
• Assists in the building and maintaining of BI Reporting system.
• Installs, configures, customizes and troubleshoots Business Intelligence tools and applications.
• Debugs, monitors and troubleshoots BI solutions
• Creates and deploys reports
• Writes relational and multidimensional database queries
• Configures, deploys and maintains database servers

Knowledge and Experience:

• Bachelor’s degree in Computer Science, Business Information Systems or a related field
•  Microsoft Structured Query Language (SQL) certification
• A minimum of four (4) years similar experience in a BI environment
• Experience with data processing flowcharting techniques and database design applications, using MS SQL 2000 and later.
• Comprehensive data warehouse analysis and design experience.
• Demonstrated ability with MS Windows, UNIX and AIX operating systems.
• Strong understanding of relational database structures, theories, principles, and practices

Key Competencies:

• Exceptional analytical and problem solving skills
• Strong understanding of the organization’s goals and objectives
• Excellent interpersonal skills with the  ability to communicate effectively with persons at all levels
• Strong organizational, time management and multitasking skills
• Strong communication skills, both verbal and written
• Ability to adapt to the environment quickly
• Self-motivated and takes initiative
• Ability to innovate and lead new initiatives