Lead Data Engineer - Multiple Teams
About the job
- At least 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.
- Lead the architecture and implementation of data pipelines and data warehouse solutions on AWS.
- Design and optimize Amazon Redshift-based analytics platforms.
- Develop and review complex PL/SQL and 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.
- Experience with AWS S3 and Lambda, SQL, ETL/ELT, data modeling, query optimization, performance tuning, Linux/Unix, Git, and CI/CD.
About the company
NorthBay Solutions is an AWS Premier Partner that helps large organizations move their databases and applications to Amazon Web Services, modernize software, and build data analytics, DevOps/DataOps pipelines, and ML/AI solutions. Its services cover database and application migrations, data and analytics workloads, DevOps and DataOps practices, and technology modernization across cloud and data platforms. The company operates by delivering engineering and consulting projects in an agile, quality-focused way to accelerate time-to-market and maximize value from cloud investments. What sets NorthBay apart is its status as an AWS Premier Partner with deep expertise in cloud migrations, data engineering, and AI/ML workloads, along with a track record of working with recognizable brands. The goal is to help clients securely migrate to AWS, modernize their applications, and unlock data-driven insights and intelligent capabilities quickly and reliably.
Company Size
201-500
Company Stage
N/A
Total Funding
N/A
Headquarters
Cambridge, Massachusetts
Founded
2007
Get referred to NorthBay Solutions
See people who can refer or advise you
Simplify's Take
What believers are saying
- NorthBay launched two AWS Marketplace agentic AI products by July 2026.
- Foundant’s migration delivered 30% performance improvement, strengthening enterprise credibility.
- Workshop-led offerings create low-friction entry points and land-and-expand services pipelines.
What critics are saying
- NorthBay’s revenue depends on AWS partner status and Marketplace visibility in 2026.
- Consulting work commoditizes fast; Accenture, Slalom, and EPAM outspend NorthBay on sales.
- If AWS favors its own services, NorthBay’s agentic products lose differentiation by 2027.
What makes NorthBay Solutions unique
- AWS Marketplace launch in 2025 put NorthBay’s agentic AI offerings inside AWS procurement.
- NorthBay touts 350-plus AWS-certified professionals and Premier Tier consulting status.
- Retail AI Agentic Platform co-innovated with AWS GenAIIC and Partner Agent Factory.
Help us improve and share your feedback! Did you find this helpful?
Benefits
- Hybrid Work Options