Data Warehouse Specialist

6 - 11 Year Qatar

JOB DESCRIPTION

Roles and Responsibilities : Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements. Develop data warehouse process models, including sourcing, loading, transformation, and extraction. Create or implement metadata processes and frameworks. Proficiency in design and implementation of data warehouse inMSBI stack (SQL server, SSIS,SSAS,SSRS, Power BI). Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. Design and implement warehouse database structures. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases. Implement business rules via stored procedures, middleware, or other technologies. Map data between source systems, data warehouses, and data marts. Evaluate all data and perform various tests on data warehouse and ensure effective implementation. Administer all data and ensure compliance to standards and policies. Maintain high quality of all deliverables and provide efficient guidance to all database architecture. Review all new tools and methodologies on various data processes for warehouse. Communicate how data (structured & unstructured) is created, modified, consumed and flows through the enterprise. Communicate how to maximize the value of information to the organization Ensure that the appropriate level of architecture diligence is applied across all initiatives in a consistent manner Coordinate closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements Manage and continuously improve the design and implementation of Information and Data Architecture processes and artifacts Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to "sell" the information/data architecture process, its outcome and ongoing results Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account Coordinate closely with business data architects to ensure adherence to documented procedures and standards Responsible for guidance on high level solutions for information/data architecture requirements Assist, coach and mentor information/data architecture practitioners. Experience working with health organizations Excellent interpersonal skills in areas such as teamwork, facilitation and negotiation Strong written and verbal communication skills Excellent skills in data management, data modeling, data services, reporting, and analytics as well as the tools used to support these areas Ability to understand the long-term ("big picture") and short-term perspectives of situations Ability to translate business needs into architecture requirements Understanding of business process principles and tools Understanding of application development methodologies Experience in data integration and data conversions preferred Ability to quickly comprehend the functions and capabilities of new technologies Knowledge of Enterprise Architecture Fundamentals; exposure to Enterprise Architecture software tools desirable

  • Work Location: Qatar
  • Notice Period: 1 Month
  • Salary: As per Company Standard
  • Industry: Other
  • Functional Area: IT Software - Other
  • Role Category: Programming & Design
  • Job Role: Performs technical administration duties for datwarehouse development and maintenance. Provides technical support and coordination during warehouse design, testing and movement to production.

COMPANY PROFILE

Magika Smartech LLP is an emerging global leader in the field of Information Technology. We provide a comprehensive range of technology solutions by leveraging our deep domain Knowledge and technical expertise. Magika Smartech LLP has a state-of-the-art Global Development Center in Mumbai, India and is committed to develop World-class products and business solutions using cutting-edge technology and cross domain expertise. Magika Smartech LLP provides top notch technology products and innovative services worldwide, with a focus on the Healthcare and Education industry vertical. Our extensive range of services includes Application development & management, independent testing, mobility and Technology consulting.