Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
NorthBay Solutions2 months ago
Islamabad, PakistanStaff+
Responsibilities
- Lead the architecture and implementation of AWS-based data pipelines and data warehouse solutions.
- Design and optimize Amazon Redshift-based analytics platforms.
- Develop and review complex Oracle PL/SQL and PostgreSQL PL/pgSQL procedures, functions, and scripts.
- Drive data migration and transformation across Oracle, PostgreSQL, and Redshift environments.
- Implement performance tuning strategies involving indexing, partitioning, and query optimization.
- Establish data governance, security, and data quality best practices.
- Collaborate with cross-functional teams to define and deliver data solutions.
- Mentor engineers, conduct code reviews, and provide technical leadership.
Requirements
- 10+ years of experience in data engineering, data warehousing, and database development.
- Strong hands-on experience with the AWS data ecosystem, including Redshift, Glue, S3, and Lambda.
- Advanced expertise in Oracle PL/SQL and PostgreSQL PL/pgSQL.
- Proven experience with enterprise-scale data warehouse architecture.
- Strong understanding of ETL/ELT frameworks and data pipeline design.
- Expertise in performance tuning and large-scale data processing.
- Prior experience in technical leadership or mentoring roles.
- Experience with SQL, data modeling, query optimization, Linux/Unix, Git, and CI/CD is desirable.
Benefits
- Full-time, permanent employment.
- Hybrid work arrangement in Lahore, Karachi, or Islamabad, Pakistan.
Tech Stack
Categories
Data Engineering
About NorthBay Solutions
NorthBay Solutions is a privately held IT services firm that helps enterprises modernize on AWS through cloud migration, data engineering, and AI/ML solutions. An AWS Premier Consulting Partner founded in 2010 and headquartered in Andover, MA, it also partners with Snowflake and provides managed services, DevOps enablement, and application development. The company operates distributed teams across the US, Canada, UAE, India, and Pakistan.