Swan Global WLL logo

Senior Data Engineer

Swan Global WLL
Contract
On-site
Doha, Doha, Qatar
Senior Jobs
Role: Senior Data Engineer

<\/div>
Experience Level: 8 to 16 Years

<\/div>
Work location: Doha, Qatar

<\/div>
Required Skills:

<\/div>
● Bachelor’s degree in Computer Science or similar field or equivalent work experience.
<\/div>
● 8+ years of experience on Data Warehousing, Data Engineering or Data Integration projects.
<\/div>
● Expert with data warehousing concepts, strategies, and tools.
<\/div>
● Strong SQL background.
<\/div>
● Strong knowledge of relational databases like SQL Server, PostgreSQL, MySQL.
<\/div>
● Strong experience in GCP & Google BigQuery, Cloud SQL, Composer (Airflow), Dataflow, Dataproc, Cloud Function and
<\/div>
GCS
<\/div>
● Good to have knowledge on SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
<\/div>
● Knowledge of AWS and Azure Cloud is a plus.
<\/div>
● Experience in Informatica Power exchange for Mainframe, Salesforce, and other new -age data sources.
<\/div>
● Experience in integration using APIs, XML, JSONs etc.
<\/div>
● In -depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract,
<\/div>
transform, load) framework, data -warehousing and Data Lakes
<\/div>
● Good understanding of SDLC, Agile and Scrum processes.
<\/div>
● Strong problem -solving, multi -tasking, and organizational skills.
<\/div>
● Highly proficient in working with large volumes of business data and strong understanding of database design and
<\/div>
implementation.
<\/div>
● Good written and verbal communication skills.
<\/div>
● Demonstrated experience of leading a team spread across multiple locations.
<\/div>
Role & Responsibilities:
<\/div>
● Work with business users and other stakeholders to understand business processes.
<\/div>
● Ability to design and implement Dimensional and Fact tables
<\/div>
● Identify and implement data transformation/cleansing requirements
<\/div>
● Develop a highly scalable, reliable, and high -performance data processing pipeline to extract, transform and load data
<\/div>
from various systems to the Enterprise Data Warehouse
<\/div>
● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical
<\/div>
data definitions
<\/div>
● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique
<\/div>
● Provide research, high -level design, and estimates for data transformation and data integration from source
<\/div>
applications to end -user BI solutions.
<\/div>
● Provide production support of ETL processes to ensure timely completion and availability of data in the data
<\/div>
warehouse for reporting use.
<\/div>
● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate,
<\/div>
design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and
<\/div>
data quality.
<\/div>
● Work collaboratively with key stakeholders to translate business information needs into well -defined data
<\/div>
requirements to implement the BI solutions.
<\/div>
● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into
<\/div>
reporting & analytics.
<\/div>
● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.
<\/div>
● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers,
<\/div>
quality issues, and continuously validate reports, dashboards and suggest improvements.
<\/div>
● Train business end -users, IT analysts, and developers.
<\/div><\/span>