The BI Specialist will act as a technical SME for organization and internal teams on BI/Data Warehouse projects (implementations, customizations, integration, and more). The individual may be responsible for one or more aspects of the project including extending existing platforms, simple to complex customizations, UI/backend development, upgrades and more. Other responsibilities include project management, design, architecture, development, deployment, operations, administration, configuration, training and support of infrastructure and business solutions. The candidate must be extremely detail-oriented, have the ability to multitask, be meticulously organized, ensure the use/rollout of latest technologies and features and be able to prioritize multiple demands in a fast-paced environment. Also have an excellent Business Analyst Qualities including proper requirements definition, presentation and client facing skills.
Responsibilities:
• Expert knowledge of reporting and BI platforms, tools and techniques used within enterprise and within broader industry and ability to effectively leverage it to support broad range of reporting and BI functions
• Expert at utilizing data sources across the organization with ability to integrate data across multiple platforms. Gather data from various sources/databases to compile a variety of intelligence briefings
• Background in data warehousing and data modeling. Understanding of existing architecture and defining the future architecture for DW. Assessment of existing architecture and recommending reliable, feasible and scalable futuristic architecture
• Provides technical consulting and guidance on the design and development of highly complex or critical architecture. Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of existing platforms and solutions
• Work effectively across multiple business units with numerous stakeholders to deliver reporting and BI solutions
• Conduct impact assessment and determine size of effort based on requirements
• Assist and verify design of solution and production of all design phase deliverables
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to architecture
• Develop solution in highly demanding environment and provide hands on guidance to other team members
• Assist in developing and maintaining SQL Server data warehouse housing multiple data sources
• Develop and maintain highly complex reports using SQL queries, SSIS Packages, stored procedures, and SQL Server Reporting Services (SSRS), Power BI. Programming in C# and Python experience a plus
• Experience writing stored procedures and table/scalar value functions
• Exposure to other database applications (MySQL, DB/2, etc.)
• Develop and maintain analytical charts and dashboards for multiple departments. Improve business process to enhance overall data quality, automation and efficiency
• Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL related activities. Develop and maintain tracking for automated processes to ensure quick response times to system failure
• Ensure accuracy and integrity of data provided to internal and external partners
• Participate in discovery calls/meetings with stakeholders to assist in the definition, formalization and improvement of business processes and procedures as they relate to environment
• Plan and run weekly internal user group meetings and convey information to the team. Reporting should include usage activity, progress of site content development, platform roadmap recommendations, and enhancements
• Understand and follow IT related processes and procedures for change control, security patching, backup and restoration of infrastructure and Databases. Ensure compliance to all relevant quality management procedures and controls across the project to guarantee compliance and delivery of high quality products/service
• Monitor to ensure workflow and tasks are working correctly, perform ongoing research to determine the platform current and future capabilities
• Provide end-user support, encourage user adoption and responsible for creation of training materials
• Ensuring the achievement of project goals and objectives by coordinating activities and resolving issues within the Project Team
• Reviewing, assuring quality and paying particular attention to those deliverables which mark project milestones or are required for project phase completion
• Monitoring progress of all project activities on an ongoing basis and provides regular reports to the Project Team/ Management and other stakeholders to keep them appraised of project progress and raise issues that require resolution
• Co-ordinating activities across the various business departments and with external resources and suppliers to ensure an understanding of needs and to provide expert technical advice and guidance
Job Details
| Posted Date: | 2018-11-05 |
| Job Location: | Abu Dhabi, United Arab Emirates |
| Job Role: | Information Technology |
| Company Industry: | Information Technology |
Preferred Candidate
| Career Level: | Mid Career |
from Jobs in UAE | Bayt.com https://ift.tt/2qpZq2i
