BI Engineer (PL/SQL, Redshift, MicroStrategy)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Ampstek is hiring a BI Engineer for a contract role in Dubai (hybrid). You will design and build database solutions, develop ETL processes, and work with PL/SQL, Redshift, and MicroStrategy.
Key Skills for This Role
Responsibilities
- Design and build database solutions
- Work with complex, disparate data sources and perform data transformation, data analysis
- Design and build data integration & warehouse solutions
- Develop and implement data integration requirements
- Collaborate with other IT and business departments as per project needs to deliver common goals
Requirements
- Advanced SQL and PL/SQL knowledge
- Strong skills in writing, optimizing, and debugging complex SQL queries and stored procedures
- Experience in bulk data processing using advanced SQL and PL/SQL techniques
- Proficiency in data modeling, schema design, and query optimization
- Hands on knowledge of Oracle and Amazon Redshift databases
- Expertise in gathering and analyzing data integration requirements to create scalable solutions
- Ability to design modular and reusable ETL components for large scale data pipelines
- Strong aptitude for identifying and resolving ETL and data related issues efficiently
- Proven experience in performance tuning of data flows and SQL queries
- Strong communication and collaboration skills for working with cross functional teams
Full Job Posting
Job Description
- Title: BI Engineer (PL/SQL, Redshift, MicroStrategy)
- Location: Dubai, UAE (Hybrid)
- Employment Contract.
Required Skills
- Advanced SQL and PL/SQL Knowledge
- Strong skills in writing, optimizing, and debugging complex SQL queries and stored procedures.
- Experience in bulk data processing using advanced SQL and PL/SQL techniques.
- Proficiency in data modeling, schema design, and query optimization.
- Hands on knowledge on Oracle, Amazon Redshift databases
- Develop, and Implement Data Integration Requirements
- Expertise in gathering and analyzing data integration requirements to create scalable solutions.
- Ability to design modular and reusable ETL components for large scale data pipelines.
- Problem Solving and Debugging Skills
- Strong aptitude for identifying and resolving ETL and data related issues efficiently.
- Proven experience in performance tuning of Data flows and SQL queries.
Other Skills
- Strong communication and collaboration skills for working with cross functional teams.
- Prefer to have experience working with Hadoop, Hive, Spark frameworks, AWS cloud
- Airlines domain experience preferred
- Primary responsibility of this role is to design and build database solutions
- Work with complex, disparate data sources and perform data transformation, data analysis.
- Design and build data integration & warehouse solutions.
- Collaborate with other IT and business departments as per project needs to deliver common goals
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Ampstek
Data Engineer/ Architect (UAE Citizen/ Golden Visa)
Dubai, UAE
Ampstek is looking for a Data Engineer/Architect with 10+ years of experience for a contract role in Dubai. You will work with Python, Spark, Databricks, and Data Lake technologies, and handle CI/CD deployment tracking.
Project Manager
Dubai, UAE
Ampstek is looking for a Project Manager to oversee technology and operational system projects in an airport environment. The role involves managing end-to-end project execution for systems like departure control, baggag
Business Analyst
Dubai, UAE
Ampstek is looking for a Business Analyst to compile requirements, drive initiatives through SDLC, and propose IT solutions. The role involves process mapping, project management using agile methodology, and coordinating
Oracle Financial Functional Consultant
Dubai, UAE
Ampstek is seeking an Oracle EBS Techno Functional Consultant for a contract position in Dubai. The role requires expertise in Oracle application framework, PL/SQL, workflows, AME, XML publisher, SOA gateway, and Oracle
Data Engineer/ Architect (Python, Spark, Databricks, Data Lake)
Dubai, UAE
Ampstek is looking for a Data Engineer/Architect with 10+ years of experience for a hybrid contract role in Dubai. You will work with Python, Spark, Databricks, and Data Lake technologies, handling CI/CD deployment and d
Oracle Consultant
Dubai, UAE
Ampstek is seeking an Oracle E-Business Suite Techno Functional Consultant for a contract role in Dubai. The ideal candidate will have experience in Oracle application framework, PL/SQL, workflows, AME, XML publisher, SO
AI Product Owner - Contact Center Solutions
Brampton, CAN
Ampstek is seeking an experienced AI Product Owner for Contact Center Solutions to lead product strategy and collaborate with engineering teams. The role requires a strong technical background in Python and JavaScript, w
Project Manager
Dubai, UAE
Ampstek is looking for a Project Manager to oversee technology and operational system projects within an airport environment. The role involves managing end-to-end project execution for systems like Departure Control, ba
Data Engineer/ Architect (UAE Citizen/ Golden Visa)
Dubai, UAE
Project Manager
Dubai, UAE
Business Analyst
Dubai, UAE
Oracle Financial Functional Consultant
Dubai, UAE
Data Engineer/ Architect (Python, Spark, Databricks, Data Lake)
Dubai, UAE
Oracle Consultant
Dubai, UAE
AI Product Owner - Contact Center Solutions
Brampton, CAN
Project Manager
Dubai, UAE