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.
Skills Required
- Design, implementation, and deployment of large, complex software projects
- High level of expertise with Oracle Database
- PL/SQL programming
- ASE Sybase
- Familiarity with Python, Perl or other shell scripting languages
- Advanced proficiency with SQL (complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions)
- SQL performance tuning and optimization
- Advanced proficiency with packages/functions/procedures programming and debugging
- Financial industry experience
- Experience 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/tools
- Full software development lifecycle experience (requirements, design, estimation)
- Ability to understand sophisticated mathematical and financial concepts
- Experience with financial data models and orders/trade flows
- Self-starter with strong research and learning initiative
- Strong analytical, organizational, and problem solving skills
- Ability to work independently in a high-pressure, time-critical environment
What We Do
Cantor Fitzgerald is a leading global financial services firm, serving clients from over 30 offices around the world. Founded in 1945 as a securities brokerage and investment bank, the firm pioneered computer-based bond trading, built one of the broadest distribution networks in the industry and became the market’s premier dealer of government securities. Today, Cantor Fitzgerald is known for its strength across a diverse array of businesses, including equity and fixed income capital markets, investment banking, commercial real estate finance and services, prime brokerage, asset management and wealth management, and e-commerce and online ventures. In all its businesses, the firm is an acknowledged leader in developing advanced technologies to expand market access, and help clients achieve their most important financial and strategic objectives. This commitment to client-centered innovation has led to enduring relationships with many of the world’s most demanding institutional investors and corporations. For more information please visit www.cantor.com.
