Description:
Hiring Senior Business Intelligence Specialist
Location: Dubai
Duration: Permanent
JD
- Operational
- Provide expert advice on best data warehousing approach of industry accepted design techniques including things like technology stack, OLAP persistence approach and fact tables’ schema (Star and Snowflake) based on business intelligence and analytical requirement.
- Work with business customers in understanding the business requirements and implementing reporting solutions.
- Develop Dashboards & Reports using BI tools (OBIEE , BIP, Cognos, Power BI, Business Objects)
- Work as a member of the delivery team to implement reporting and analytic solutions / components of solutions delivered to Dubai Customs business departments or business partners.
- Prepare detailed report specifications document to develop the reports.
- Ownership of the overall design of the solutions, including data models, information delivery and ETL mappings.
- Develop ETL solutions using Informatica & PLSQL.
- Maintain operational data warehouses to ensure reports accuracy and synchronization with changes in transactional systems.
- Identifying data sources and extraction processes. Creating data extractions, user interfaces, and queries, and reports.
- EDA using Python and cleansing activities.
- Participate in reference data mapping initiative across multiple solutions and along with external business partners.
- Provide analysis support to the architecture, development, integration test, and user acceptance teams during and after delivery of the project
- Maintain business intelligence models to design, develop and generate both standard and ad-hoc reports.
- Generate reports for internal and external customers for business performance monitoring and business decision making.
- Perform data warehouse design and modelling according to established standards.
- Identify and resolve data reporting issues in a timely fashion.
Competency Title:
Proficiency Level:
- Knowledge of leading business intelligence tool
- Experience in Dimensional Data Modeling
- Strong knowledge of relational database concepts, large-scale RDMS based systems design and development, dimensional modeling, OLAP and Business Intelligence concepts and design methodology.