Location: Jersey City, NJ
Work arrangement: On-site
Work type: Full-time
Compensation: DOE
Location: Onsite — Jersey City, NJ
The team is a Data Engineering group focused on building and maintaining robust database-centric data pipelines, database solutions, and analytics platforms across heterogeneous systems. They develop and maintain Oracle, PL/SQL packages, procedures, functions, Vertica and Unix Shell/Python automation, with workload scheduling orchestrated through Autosys. The team ensures end to end data integrity, reliability, and performance across traditional database environments (Oracle, Vertica, MS SQL). They leverage data modeling, data profiling, dimensional modeling, and database testing to deliver well documented, stable, and compliant data solutions. They also support UAT, create training materials, and collaborate with adjacent technology teams to manage dependencies and ensure software stability and data quality.
This is an individual contributor role responsible for providing leadership, technical direction and oversight to a team delivering technology solutions. Key responsibilities include providing oversight of the design, implementation, and maintenance of complex computer programs, aligning technical solutions to business objectives, and ensuring that coding practices/quality comply with software development standards. The role involves conducting multiple software implementations and applying both depth and breadth in knowledge of several technical competencies.
Responsibilities:
Designs, develops and is accountable for feature delivery. Applies enterprise standards for solution design, coding and quality. Ensures solution meets product acceptance criteria with minimal technical debt. Guides the team on work breakdown and execution. Works with the Product Owner to ensure that product backlog/requirements are healthy, with clear acceptance criteria. Plays a team lead role (as an individual contributor) and mentors the team. Guides team members with skills and practices (planning and estimation, peer reviews, and other engineering practices). Analyzes existing business processes and designs Oracle-centric optimizations, automation, and workflow improvements. Gathers and documents functional, non-functional, and technical requirements for incoming requests. Analyzes functional and data requirements to understand how applications store, transform, and expose data within Vertica/Oracle. Assists users and development teams with application testing, data validation, and troubleshooting Oracle/Vertica database processes. Identifies, documents, and troubleshoots application and database-related issues (performance, data integrity, failures). Documents end to end processes, database procedures, workflow logic, and operational runbooks. Creates and maintains training material for end-users and support teams. Demonstrates exceptional analytical/problem solving skills with strong communication and collaboration. Collaborates with other development teams to manage interdependencies, design test cases, debug issues, and maintain high data quality. Ensures software stability through documentation, peer code reviews, regression testing, unit testing, and UAT. Performs logical and physical data modeling, including schema design in Oracle. Performs in-depth data analysis, profiling, and identification of data quality issues. Supports story refinement, requirement elaboration, and effort estimation in Agile processes. Utilizes Github Copilot and other AI tools to speed up delivery of development and leads and encourages team members to drive developer growth. Presents team's work to business partners and leads senior and junior team members onshore and offshore through technical complexities in Oracle development and CI/CD pipeline design and industry standard best practices. Develops strong understanding of stakeholder needs and translates them into scalable database-based technical solutions.
Required Qualifications:
Bachelor's Degree in Engineering, Science, IT, Computer Science or job related field or equivalent work experience. 8+ years of job related experience required. Experience with relational and non-relational databases, focusing heavily on Oracle SQL and PL/SQL. Strong experience designing and implementing Oracle-driven data integration pipelines using SQL, PL/SQL, and Unix shell scripting. Experience automating Oracle processes using job schedulers (Autosys preferred). Professional experience in SQL/PLSQL development, including packages, functions, procedures, triggers, and bulk processing. Ability to refine requirements, participate in story sizing, and help drive Agile delivery. Ability to perform POCs/spikes to test new Oracle features or solution patterns. Develop, test, and deliver Oracle-based solutions that meet acceptance criteria and adhere to compliance standards. Strong understanding of how to integrate multiple architectural components (data, application, business). Good understanding of dimensional modeling, star/snowflake schemas, facts, dimensions, and hierarchies. Skilled in leading and developing complex Oracle data flows, connecting to heterogeneous databases such as Oracle and MS SQL Server. Hands-on experience developing complex Oracle procedures, functions, and PL/SQL packages used in APIs, reporting, and data warehousing. Ability to conduct both proactive and reactive Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization best practices. Strong hands-on experience developing and supporting Unix shell scripts (critical skill). Work split: Oracle PL/SQL / Shell / Python 70%, ETL transformations (Informatica) 10%, Unix shell scripting, Python 20%.
Desired Qualifications:
Financial industry/Banking experience preferred. Demonstrated exceptional analytical skills and problem solving skills; excellent organizational and communication skills. Experience with JIRA tool and infrastructure. An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.
Skills:
Automation, Influence, Result Orientation, Stakeholder Management, Technical Strategy Development, Architecture, Business Acumen, Risk Management, Solution Delivery Process, Solution Design, Agile Practices, Analytical Thinking, Collaboration, Data Management, DevOps Practices.
Hours per week:
40
Compensation: DOE