Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
NorthBay Solutions2 months ago
Karachi, PakistanStaff+
Responsibilities
- Lead the architecture and implementation of AWS 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, including indexing, partitioning, and query optimization.
- Establish best practices for data governance, security, and quality.
- 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 in enterprise-scale data warehouse architecture.
- Strong understanding of ETL/ELT frameworks and pipeline design.
- Expertise in performance tuning and large-scale data processing.
- Prior experience in technical leadership or mentoring roles.
Benefits
- Full-time, permanent employment.
- Hybrid work arrangement in Lahore, Karachi, or Islamabad, Pakistan.
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.