Data Warehousing Consultant job from Trabeya Pvt Ltd in Colombo, Sri Lanka

Wednesday 29th, April 2020

Trabeya Pvt Ltd

Apply Bookmark

Colombo

Full-Time

IT-Hardware / Networking IT-Software / Internet

DATA WAREHOUSING CONSULTANT

Full-time, Colombo-based

We are on the lookout for talented, innovative and self-motivated individuals who are passionate about next-generation data platforms to power machine learning at scale to join our dynamic and collaborative team.

Role Overview

The successful candidate will contribute expertise in defining overall data models, data dictionaries, designing technical architecture, developing SQL data warehouses, cubes and ETLs and data lake ELTs, as well as developing all reporting layer components needed for serving business intelligence insights to users

Essential Functions and Responsibilities

Design, implement and manage ETL (Extract, Transform and Load) and ELT processes from multiple heterogeneous source systems
Design, develop and manage Data Warehouses/Data Marts and OLTP/OLAP databases Configure and manage Data-as-a-Service platform instances with Amazon S3 or Microsoft Azure Data Lake Storage or on-premise Configure and manage major cloud vendor services for business intelligence, including data integration from:

Azure Data Factory, HDinsight, and Databricks o Amazon Redshift

GCP BigTable and Big Query

Develop interactive visualizations using business intelligence tools such as Power Bland Tableau Implement, track and document query optimizations, data governance requirements and testing of pipelines in the relevant environments

Requirements

Knowledge consistent with a Bachelor's Degree or a professional qualification in Computer Science, Data Analytics, Software Engineering or similar
Excellent SQL skills and capability transforming data and developing pipelines as per various business needs
Knowledge and demonstrable experience in the design and development of stored procedures, procedural SQL, SQL Server DTS, SSIS, SSRS and SSAS
Minimum four (04) years of experience as a Senior Database Administrator/Data Warehousing Engineer, experience working on offshore projects will be an advantage
Experience with Data Lake or NoSQL database management is advantageous
Ability to develop good communication channels and partnerships with the eventual consumers of analytics to understand and anticipate business needs as well as other stakeholders
Ability to learn new technologies and collaborate effectively with the Data Engineering and Product teams with minimum supervision

Our Culture

We believe that curiosity and continuous self-improvement in a collaborative and open work environment makes for effective teams. Our ideal candidate is a team player who genuinely enjoys solving problems in a fast-paced environment, applying sound critical judgement in the planning and execution of tasks and exemplifying professionalism throughout.

About Trabeya

Trabeya is a cutting-edge advanced data analytics and custom Al solution provider for enterprise businesses. With our open and innovative culture, Trabeya focuses on delivering world-class solutions by combining people, processes and technologies to help

organizations transform how data is used to make better business decisions.

If you are a seasoned Data Warehousing Consultant with a drive for professional growth, international exposure, and career

advancement, we would be excited to hear from you.

Skills required

Ability to learn new technologies and collaborate effectively

Excellent SQL skills and capability transforming data

design and development of stored procedures, procedural SQL, SQL Server DTS, SSIS, SSRS and SSAS

good communication channels and partnerships

Computer Science, Data Analytics, Software Engineering or similar