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. 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.