Pitisci & Associates
Back to List

Sr. Java Data Engineer  (Backend)

W2 Contract - USC/GC

St. Petersburg, FL

Hybrid (2-3 days per week in office)

 

Summary:

We are seeking a Senior Java Data Engineer to model, design and build a consolidated database for consolidated order data across different asset classes.  You will collaborate with Enterprise Architecture, Business Analysts and other development teams across the enterprise.  You may also engage with Trading Desks (Equity, Option, Fixed Income, Mutual Fund and Structured Products), Compliance/Legal and Technology Teams. The successful candidate will be instrumental from analysis, documentation, solution inception, modeling and database design (Star Schema) and development. This role encompasses the analysis and design and support of new technology solutions and processes, enhancements of existing systems, including Enterprise Data hosted internally and in the cloud. Responsibilities include leading analysis, documentation, database modeling and design, and contributing to the development and maintenance of processes and procedures. This position is a blend of architecture and design as well as database development, located at our corporate headquarters in Saint Petersburg, FL.

 

Essential Duties and Responsibilities:

  • Participate in the Agile development lifecycle, including daily stand-ups and biweekly sprint planning
  • Communicate across departments within the company and with business users to solve problems
  • Develop and use collaborative relationships to facilitate the accomplishment of work goals
  •  Identifying business needs
  • Proposing data solutions
  • Evaluating data systems
  • Designing data models
  • Developing data dictionaries
  • Documenting data models

 

SKILLS

  • Strong programming languages like Java, JavaScript, Python, JSON
  • Strong Relational database design and modeling skills including trade-offs
  • Understanding of Dimensional Modeling
  • Oracle Exadata and Golden Gate, MySQL and PostgreSQL
  • Strong Pl/SQL development and debugging skills
  • Performance tuning and understanding how to analyze query plans, , knowledge of AWR, SQL trace and ability to optimize SQL queries, create indexes, and use other performance-enhancing features.
  • Experience with data modeling tools such as ERwin, IBM Data Architect, etc.
  • Experience with cloud-based databases such as AWS Aurora, Redshift and Snowflake.
  •  Advanced analytics, reporting, and machine learning capabilities with Oracle databases
  • The ability to creatively resolve database-related problems

 

Education/Previous Experience:

  • Minimum of a Bachelor’s degree in Computer Science, MIS, Business or related degree
  • Three (3) to five (5) years of relevant experience or a combination of education, training and experience approved by HR.
  • Experience in Financial Services Industry is nice to have.

 

Apply to this Job
First Name *
Last Name *
Email

Phone