Responsibilities:
-Interact with business stakeholders to provide solutions addressing business data analytic requirements
-Work with SQL and other database access tools and methods to address business or technical requirements
-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 and frameworks
-Conduct Shell scripting and advanced SQL developments
-Identify opportunities to fine-tune and optimize SQL queries/views
-Become proficient in the data model and data structures to be able to efficiently respond to business queries and requests
-Provide ongoing maintenance and support of database schemas and views
-Conduct root cause analysis and resolve production problems and data issues
-Work within the defined software development lifecycle, following rigorous 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.
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.
