Senior Database Developer

Job Title: Sr. Database Developer

Location: New York, NY or Redbank, NJ

Firm Overview:

Cantor Fitzgerald L.P., with over 16,000 employees, has been a leading global financial services firm at the forefront of financial and technological innovation since 1945. Cantor Fitzgerald & Co. is a preeminent investment bank serving more than 5,000 institutional clients around the world, recognized for its strengths in fixed income and equity capital markets, investment banking, SPAC underwriting, PIPE placements, commercial real estate, and for its global distribution platform. Capitalizing on the firm’s financial acumen and technology prowess, Cantor’s portfolio of businesses also includes Prime Brokerage, Asset Management, and other businesses and ventures. For 79 years, Cantor has consistently fueled the growth of original ideas, pioneered new markets, and provided superior service to clients. Cantor operates trading desks in every major financial center globally, with offices in over 30 locations around the world. As one of the few remaining private partnerships on Wall Street, Cantor has the distinct ability to focus on long-term value creation and solid relationship building. Our structure allows us to respond quickly to client needs, develop solutions that address complex challenges, avoid the limitations of bureaucracy, and attract talented individuals who are driven to succeed.

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

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.

Educational Qualifications:

· Bachelor’s Degree required

Salary: $ 180,000- $ 200,000

The expected base salary for this position ranges from $180,000 to $200,000 annually. The actual base salary will be determined on an individualized basis taking into account a wide range of factors including, but not limited to, relevant skills, experience, education, and, where applicable, licenses or certifications held. In addition to base salary and a competitive benefits package (including health, vision, and dental insurance, paid time off and a 401(k) retirement), this position may be eligible for additional types of compensation including discretionary bonuses and other short- and long-term incentives (e.g., deferred cash, equity, etc.).