Sr. Snowflake developer - NJ, NY (Onsite)

Location: NY, NJ (Onsite) | Duration: 12 Months

About the Role

Drive performance analysis and optimization of SQL queries across Oracle and Snowflake. Troubleshoot complex data and systems issues and lead root-cause analysis for data quality. Partner with technology and business stakeholders to define requirements, functional specifications, and operational architecture for strategic global programs. Provide input to data strategy and actively influence software development process improvements.

Responsibilities

• Analyze, optimize, and benchmark SQL queries across Oracle and Snowflake.
• Diagnose and resolve highly complex performance and data-quality issues through rigorous root-cause analysis.
• Collaborate with Universal Client Manager and technology teams to define specifications, design documents, and functional use cases for system enhancements and integrations.
• Elicit, challenge, and prioritize business requirements using standard processes and templates; translate requirements into clear functional designs, user stories, and use-case documentation.
• Develop project scope, objectives, constraints, and assumptions for large strategic multi-year initiatives; ensure alignment to business outcomes and operational architecture.
• Provide consultation to IT and business management on applying technology to business opportunities; plan and guide implementation of cross-functional applications and systems.
• Participate in and provide guidance on technical design reviews, test planning, and user documentation; ensure end-to-end traceability from requirements through testing and release.
• Manage scope changes and dependencies using formal requirements-management principles, including change control, traceability, and stakeholder sign-offs.
• Gather and analyze quantitative and qualitative data to develop recommendations addressing strategic objectives across multiple global business and technology areas.
• Engage in industry forums to maintain current domain knowledge; incorporate best practices into solution design and process improvements.
• Apply experience with software/systems development processes to design and implement improved methodologies; actively influence continuous improvement in SDLC and data practices.
• May allocate and coordinate work within a team or project, ensuring delivery quality and timeline adherence.
• Hands-on experience designing and implementing data pipelines using Snowflake features including Streams, Tasks, Dynamic Tables, and Snowpipe for automated ingestion and incremental processing.
• Strong proficiency in complex SQL (window functions, CTEs, merge statements) and experience integrating Java-based ETL/ELT logic with Snowflake via JDBC or Snowflake connectors; familiarity with stored procedures and Snowpark is a plus.
• Build multi-layer lake architectures (raw, curated, consumption zones) with data-quality checks, deduplication, and schema-evolution handling for high-volume transactional datasets.
• Prior exposure to financial data domains such as payment transactions, SWIFT messaging (MT/MX formats), customer inquiry records, or bank/client reference data; understanding of data sensitivity, masking, and compliance requirements.
• Integrate Snowflake pipelines with external datastores (e.g., GCS, S3, Azure Blob, or relational DBs) and orchestration tools (e.g., Apache Airflow, dbt, or equivalent) for end-to-end pipeline scheduling.
• Tune and optimize SQL queries, including explain-plan analysis, normalization/denormalization, 2NF/3NF, and dimensional models.
• Perform data profiling and ensure data quality.
• Understand financial models, including Party and Party relationships.

Requirements

• Must-have skills: SQL, Oracle, Snowflake, Collibra, Financial Domain Expertise.
• Good-to-have skills: Data Modeling, Banking Structures, AI, Data Analytics Exposure, Enterprise Data, SDLC Practices.
• Experience working with Collibra.
• Proven expertise in SQL performance analysis and tuning across Oracle and Snowflake environments.
• Hands-on experience investigating and remediating data-quality issues, including root-cause analysis and corrective/preventive actions.
• Demonstrated ability to elicit and document business requirements and translate them into functional specifications, use cases, and technical designs.
• Familiarity with operational architecture, systems integration, and cross-functional application implementation.
• Proficiency with requirements management practices, change control, traceability, and participation in testing, test plans, and UAT defect triage.
• Strong stakeholder management and communication skills with the ability to consult and influence across business and technology teams.

Preferred Qualifications

• Experience working with Artificial Intelligence.
• Experience working with Universal Client Manager or similar client/platform technologies.
• Exposure to large-scale strategic multi-year programs spanning global business and technology areas.
• Knowledge of modern SDLC practices, Agile methodologies, and process-improvement frameworks.
• Participation in industry forums or professional communities related to data analytics or enterprise architecture.

Core Competencies

• Analytical problem-solving and structured root-cause analysis.
• Requirements elicitation and prioritization.
• Technical design literacy and testing rigor.
• Data strategy awareness and business acumen.
• Stakeholder engagement and consultative communication.
• Process improvement and change management.