Data Engineer
Summary
Data Engineer in Lahore building the data foundation for Infotech's AI and analytics initiatives: designing data warehouses and semantic layers, auditing and cleaning production databases, and maintaining ETL/ELT pipelines across on-premises and Azure environments in close collaboration with AI/ML and product teams.
We’re looking for a Data Engineer to build the data foundation behind Infotech's AI and analytics initiatives. You will be responsible for designing data warehouses and semantic layers, improving the quality and reliability of existing databases, and developing data pipelines that support analytics and AI-powered applications.
The role involves working across on-premises and Azure environments, ensuring that data from different software products is properly structured, integrated, and accessible. You will also work closely with the AI/ML and product engineering teams to ensure they have reliable, well-organized data to support their applications and product features.
Responsibilities
- Design and build data warehouses that consolidate data from across our software products.
- Build semantic layers that provide a consistent, business-friendly view of data for analytics and AI applications.
- Audit, clean, and resolve issues in existing production databases, including inconsistent schemas, duplicate or missing data, and broken relationships.
- Build and maintain ETL/ELT pipelines across on-premises databases and Azure environments.
- Partner with the AI/ML team to ensure data is properly structured, available, and suitable for AI-powered product features.
- Monitor data quality and implement checks to identify and address issues before they reach production systems.
Requirements
- 2+ years of experience as a Data Engineer or in a similar data-focused engineering role.
- Strong SQL skills and experience with data modeling, including data warehouse and semantic layer design.
- Hands-on experience building and maintaining ETL/ELT pipelines.
- Comfortable working with both on-premises databases and Azure cloud data services.
- Experience diagnosing and resolving data quality issues in live production systems.
- Good communication skills and the ability to work closely with AI/ML and product engineering teams.
- Experience with a programming language for pipeline development, such as Python.
- Experience with data processing frameworks for large-scale or batch workloads.
- Familiarity with real-time or streaming data pipelines.
- Basic awareness of data governance and access-control practices.
Nice to Have
- Experience working with financial data or other regulated-industry data.
- Experience supporting analytics or AI/ML teams with clean, well-modeled data.