Lead Data Engineer

About the Company

We are seeking an experienced Lead Data Engineer with strong hands-on expertise in Snowflake, Python, and Oracle PL/SQL. The ideal candidate will have recent experience working on data migration, automation, and data integration projects involving Oracle and Snowflake, with the ability to lead technical delivery and manage offshore/global teams. The role requires a strong balance of technical data engineering, team leadership, client engagement, and project delivery. Experience within Capital Markets or Banking is strongly preferred.

• About the Role
• The role requires a strong balance of technical data engineering, team leadership, client engagement, and project delivery.

Responsibilities

• Design, develop, and optimize scalable data solutions using Snowflake, Python, and Oracle PL/SQL.
• Lead Oracle-to-Snowflake data migration and automation initiatives, including data extraction, transformation, loading, validation, and reconciliation.
• Develop Python-based solutions for data processing, automation, integration, and workflow optimization.
• Develop and maintain data pipelines using DBT and other relevant data engineering technologies.
• Design Snowflake data models and optimize query performance, storage, and overall platform cost.
• Develop complex Oracle SQL/PL/SQL queries, procedures, and performance-tuned solutions.
• Create and maintain dashboards and reports using Power BI, Sigma, or other enterprise BI tools.
• Lead technical teams and coordinate effectively with offshore/global delivery teams.
• Own end-to-end delivery of assigned projects, ensuring milestones, quality, and timelines are met.
• Conduct weekly/monthly governance meetings, provide status updates, track risks and dependencies, and communicate progress to stakeholders.
• Work directly with clients and business stakeholders to understand requirements and translate them into effective technical solutions.
• Review technical designs and code, provide technical guidance, and mentor team members.
• Identify opportunities for process improvement, automation, and application of Generative AI to improve data engineering and analytics processes.

Qualifications

• Strong hands-on experience with Snowflake, including data modeling, performance optimization, and cost management.
• Advanced Python skills with experience in data processing, automation, and integration.
• Strong Oracle PL/SQL experience, including complex queries, stored procedures, and performance tuning.
• Recent hands-on experience with Oracle-to-Snowflake data migration or data movement automation.
• Experience with DBT and modern data engineering practices.
• Experience with at least one enterprise BI/reporting tool such as Power BI or Sigma.
• Proven experience leading technical teams and managing offshore/global resources.
• Strong customer-facing, communication, and stakeholder management skills.
• Experience managing governance, status reporting, risks, dependencies, and project delivery.

• Preferred Skills
• Capital Markets experience is highly preferred; strong Banking/Financial Services experience will also be considered.
• Experience supporting front-to-back-office, securities, or corporate functions within financial services.
• Exposure to Generative AI concepts, tools, or use cases within data engineering or analytics.
• SAFe Product Owner/Product Manager (POPM) certification is a plus.

• Location: Newark, NJ
• Work Arrangement: Hybrid – 3 Days Onsite
• Duration: Contract
• Experience: 7–12 Years

• Equal Opportunity Statement
• We are committed to diversity and inclusivity.