Location: New York, NY, United States

Responsibilities

Responsibilities:

• Interact with business stakeholders to provide solutions that address business data analytics requirements

• Work with SQL and other database access tools and methods to meet business or technical needs

• Design, implement, and support data‑movement solutions across multiple platforms and data sources (database tables/views and external files) using custom code and ETL tools/frameworks

• Conduct shell scripting and advanced SQL development

• Identify opportunities to fine‑tune and optimize SQL queries and views

• Become proficient in the data model and data structures to efficiently respond to business queries and requests

• Provide ongoing maintenance and support for database schemas and views

• Conduct root‑cause analysis and resolve production problems and data issues

• Work within the defined software development lifecycle, following established change‑control policies

Qualifications

• Demonstrated experience working on the design, implementation, and deployment of large, complex software projects. 
• High Level of expertise with Oracle Database, PL/SQL programming and ASE Sybase,. 
• Familiarity with Python, Perl or other shell scripting languages.  
• Advanced proficiency with SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and SQL Performance/Tuning 
• Advanced proficiency with Packages/Functions/Procedures programming and debugging.
• Financial Industry Experience
• Experience of working with large volumes of data 
• Good understanding of Database Architecture 
• Solid understanding of relational and dimensional data models 
• Experience with business intelligence reporting tools, data integration tools , and metadata repository processes and tools 
• Full Software Development Lifecycle, including requirements identification, design, and task estimation.
• Ability to understand sophisticated mathematical and financial concepts
• Experience working on financial data model and orders/trade Flows
• Self-starter with proven ability and initiative to learn and research new concepts, ideas, and technologies quickly 
• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills 
• Ability to take responsibility and work independently in a high-pressure, time critical environment.