Data Engineer

Position Overview:

We are seeking a experienced Data Engineer to join the team. As a Data Engineer, you will play a crucial role in designing, implementing, and maintaining the infrastructure necessary for our data initiatives, ensuring scalability, reliability, and efficiency. You will collaborate with cross-functional teams to develop robust data pipelines, optimize data workflows, and ensure the reliability and scalability of our data systems.

Key Responsibilities:

· Develop and maintain ETL (Extract, Transform, Load) processes to integrate data from disparate sources into SQL Server databases.

· Write complex SQL queries, stored procedures, and optimize database performance for large-scale datasets.

· Develop and implement efficient data models to support analytical and reporting requirements.

· Design, implement, and optimize database structures, stored procedures, queries, and views for performance and scalability.

· Design and implement database schemas, tables, indexes, Triggers and constraints to ensure efficient storage and retrieval of data.

· Perform database debugging, troubleshooting, and bug fixing to identify and resolve issues related to data integrity, performance, and functionality.

· Troubleshoot and resolve database issues, including performance bottlenecks, data corruption, and system errors.

· Collaborate with cross-functional teams, including software developers, analysts, and business stakeholders, to gather requirements and implement database solutions.

· Implement security measures and access controls to protect sensitive data stored in SQL Server databases, in compliance with regulatory requirements and industry best practices.

Requirements:

· Degree in Computer Science, Engineering, or a related field.

· Strong expertise in Microsoft SQL Server (T-SQL, indexing, query tuning, performance optimization).

· 5+ years of experience as a Data Engineer or similar role, with a strong background in data warehousing, ETL, and database technologies.

· Can demonstrate experience working with large and complex data sets as well as experience analyzing volumes of data.

· Experience with monitoring and optimizing database performance in production environments.

· Familiarity with cloud-based data architecture and pipelines.

· Strong problem-solving, analytical, and debugging skills.

· Ability to analyze complex data sets and design scalable data solutions.

· Excellent communication and collaboration skills.

Job Type: Full-time

Application Question(s):

• what is your current salary?
• what is your expected salary?
• What is your notice period?
• Since it's an onsite role, would you be able to commute to Bahria Complex 1, M.T. Khan Road?

Work Location: In person