Data Modeler Lead
-
IT/Tech
Job Description & How to Apply Below
Job Description Summary
Note:
This position follows our hybrid-friendly schedule, so you get the best of both worlds – flexibility and collaboration. In office days are 3 days per week (including a Monday or Friday), in our St Petersburg, FL Corporate Office. This role is not eligible for Work Visa sponsorship, either currently or in the future.
Raymond James is seeking an experienced, hands‑on Data Modeler & Architecture Lead to support the Capital Markets & Advisory (CMA) Technology organization. This position will serve as a senior technical leader within CMA Technology Product Management, connecting business requirements, data architecture, database engineering, and application development across the organization’s on‑premises and cloud data environments. The successful candidate will combine deep technical expertise in Microsoft SQL Server, Oracle, AWS, and enterprise data modeling with a strong understanding of business processes and application architecture.
This individual will work directly with Product Owners, business stakeholders, and Development teams to investigate complex data challenges, design scalable solutions, improve existing systems, and establish consistent, reusable data architectures. This is a highly technical, hands‑on position requiring the ability to independently analyze databases, develop and optimize SQL, troubleshoot production issues, design data models, and guide technical implementations. The role will also play a key part in advancing CMA’s hybrid‑cloud modernization strategy and building governed, reliable data foundations for enterprise reporting, analytics, and AI‑enabled business capabilities.
- Data Architecture & Modeling Design, develop, and maintain conceptual, logical, and physical data models supporting operational applications, databases, data warehouses, reporting, and analytical platforms.
- Translate business processes, Product Owner requirements, and operational workflows into data architectures, schemas, entity relationships, business rules, and technical specifications.
- Establish authoritative and reusable data models, identifying opportunities to standardize, consolidate, and improve existing data structures.
- Design normalized and dimensional models, source‑to‑target mappings, reference data structures, and data integration patterns.
- Define and promote database design standards, data quality controls, metadata management, and data lineage practices.
- Database Engineering & Technical Problem‑Solving Provide hands‑on technical expertise across Microsoft SQL Server, Oracle, and AWS database environments. Develop, review, and optimize complex SQL queries, stored procedures, database objects, and supporting scripts. Investigate and resolve complex database performance issues, data discrepancies, integration failures, and production incidents. Analyze execution plans, database dependencies, query performance, and application data flows to identify root causes and implement improvements.
Partner with Development and engineering teams to design, implement, test, and validate database changes and technical solutions. Evaluate database performance, scalability, reliability, and maintainability, recommending improvements that support business and operational requirements. - Cloud Architecture & Data Modernization Support the design and evolution of hybrid‑cloud data architectures integrating existing SQL Server and Oracle environments with AWS. Evaluate database modernization opportunities, cloud migration approaches, workload placement, and integration architectures. Partner with cloud engineering and enterprise architecture teams to design scalable, secure, and cost‑effective AWS database and analytics solutions. Develop practical…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction