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
- 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.
What you need to know about the NYC Tech Scene
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
