Data Engineer
New Cairo, Cairo
Data – Data /
Full-time /
On-site
Ready and hungry for a new adventure? You are definitely in the right place!
We at Envision Employment Solutions are always on the look for top talents around the globe and matching them with our partners' hiring needs, to help them build and scale!
Our partners offer awesome work environment, competitive salaries, full benefits, and many others perks.
Our Hiring Process:
1. After filling your online application, our team will review your application and if you are a fit for any of the open positions we have even if it wasn't the one you applied for, our team will reach out to you to schedule an HR Interview.
2. During the call we will go through your resume and discuss the opportunities we have for you in details. We would love to learn a little bit about you, about your work experience and your career's goal. We will also be able to answer any questions you might have.
Please feel free to share our career site with any of your colleagues or anyone you know that might be looking for a job: https://jobs.lever.co/envisionemploymentsolutions
_________________________________________________________________________________________________________
Envision Employment Solutions is currently looking for a Data Engineer for one of our partners, a multinational bank.
Responsibilities:
- Database Development: Develop stored procedure, views, functions, partitions, etc., using SQL Server.
- ETL Development: Develop, code, test, and debug using SSIS ETL (SQL Server Integration Services). Translate complex business requirements into technical solutions. Validate ETL design and ensure completeness of business specifications.
- Production Support: Troubleshoot ETL jobs in Production Support. Apply strong analytical and problem-solving skills in a Production Support environment.
- Technical Skills: Demonstrate proficiency in .Net with C#.NET and VB.NET.
- Database Hosting and Management: Host and manage online databases to ensure accessibility and reliability. Oversee database administration tasks and optimizations.
- MIS Structure Maintenance: Load and maintain Management Information System (MIS) structures related to incorporating external sources (e.g., Cloud, other countries). Explore and implement possible extensions in existing modules.
- Enterprise Scheduling Parameterization: Contribute to the parameterization of enterprise scheduling processes.
Requirements:
- Bachelor's or higher degree in Information Technology or equivalent work experience.
- Minimum 3 years of experience as a Data Engineer.
- Database Management Systems: Hands-on development experience with database management systems, specifically Microsoft SQL Server 2012 and above, Oracle knowledge will be considered as a plus.
- ETL Tools: Hands-on development experience with ETL (Extract, Transform, Load) tools, specifically SSIS.
- Performance Tuning: Hands-on experience in performance tuning, particularly in handling large volumes of data and table partitioning.
- Data Modeling Concepts: Proficiency in Data Warehousing and Data Mining techniques. Familiarity with dimensional data modeling concepts, including dimensions and fact tables, surrogate keys, and star and snowflake schema.
- Soft Skills: Excellent communication and interpersonal skills. Demonstrated ability to handle high-pressure situations.
- Domain Knowledge (Optional): Knowledge of banking subject areas such as Customers, Deposits, Loans, Cards, and Wealth Management.
- Certification (Optional): Microsoft Certification is added value
Benefits:
- Competitive Salary based on experience
- Transportation and mobile allowance
- Profit Share
- Social and medical insurance
- Learning, development and career progression
Envision Employment Solutions is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce. Come join us!
