
Data Modeler Lead
Saint Petersburg, FLJobSeen todayIn the employer's feed · checked in the last 2 days
See where you stand before you apply. No sign-up to start.
You apply on the posting's application page, with no Olive account needed.
Watch jobs like this. New roles like this one near Saint Petersburg, FL, by email.
Don't just apply. Show up ready.
Olive works from this exact posting.
At a glance
Olive focuses on jobs in the United States, including remote roles you can work from there.
Job overview
Raymond James seeks an experienced, hands-on Data Modeler and Architecture Lead for its Capital Markets & Advisory Technology organization. The role connects business requirements, data architecture, database engineering, and application development across on-premises and cloud environments. The lead will design and improve data models and database solutions, support hybrid-cloud modernization, and guide technical implementations for reporting, analytics, and AI-enabled capabilities.
Skills & qualifications
Skills
Qualifications
Full job description
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.
Key Responsibilities:
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 transition architectures that preserve existing application functionality while enabling cloud modernization.
-
Help establish reusable data services and cloud-based data foundations supporting future business capabilities.
Data Integration, Analytics & Governance
-
Design and support data integration solutions, including ETL/ELT processes, APIs, data ingestion, transformation, and database-to-database integrations.
-
Investigate and resolve data quality issues, reporting discrepancies, and reconciliation gaps across applications and platforms.
-
Enable governed, reusable datasets for business intelligence, self-service reporting, advanced analytics, and AI use cases.
-
Collaborate with Security, Enterprise DBA, and Data Governance teams to ensure solutions align with enterprise requirements for access controls, data entitlements, ethical walls, auditability, and information security.
-
Improve documentation of data definitions, source systems, transformations, dependencies, and technical architecture.
Business Partnership & Technical Leadership
-
Work directly with CMA business stakeholders and Product Owners to understand business workflows, data requirements, operational challenges, and opportunities for improvement.
-
Translate business needs into actionable technical requirements, architecture recommendations, and prioritized engineering work.
-
Serve as a primary technical point of coordination for assigned CMA database and data architecture initiatives, partnering closely with Development, Enterprise DBA, Cloud Infrastructure, and enterprise technology teams.
-
Provide technical guidance and design reviews to promote consistency, architectural integrity, and alignment with business objectives.
-
Balance immediate production support needs and application enhancements with longer-term data architecture and modernization priorities.
-
Communicate technical findings, solution options, dependencies, risks, and tradeoffs clearly to both business and technology stakeholders.
Required Qualifications:
-
More than eight (8) years of hands-on experience in database architecture, data modeling, SQL development, and enterprise data management.
-
Advanced proficiency with Microsoft SQL Server and Oracle, including relational database design, stored procedures, complex queries, performance tuning, and troubleshooting.
-
Demonstrated experience developing conceptual, logical, and physical data models for operational and analytical systems.
-
Strong understanding of database architecture, normalization, dimensional modeling, data integrity, and performance optimization.
-
Experience designing and supporting data integrations, ETL/ELT processes, source-to-target mappings, and complex application data flows.
-
Practical knowledge of AWS database and data architecture technologies and hybrid on-premises/cloud environments.
-
Experience investigating production database issues, identifying root causes, and working with engineering teams to implement and validate solutions.
-
Understanding of data governance, metadata, lineage, data quality, security, and access control requirements.
-
Demonstrated ability to translate complex business requirements into practical technical solutions.
-
Strong analytical, problem-solving, documentation, and communication skills.
-
Ability to work independently, provide technical leadership, and collaborate effectively across Product Management, Development, Infrastructure, and business teams.
Preferred Qualifications:
-
Experience with AWS services such as RDS, Aurora, S3, Redshift, Glue, Athena, Lake Formation, and IAM.
-
Experience with enterprise database modernization, cloud migration, and hybrid-cloud data architecture.
-
Familiarity with reporting and analytics platforms such as Qlik, Power BI, Tableau, and Python-based analytical solutions.
-
Experience developing curated datasets, semantic models, and governed self-service analytics capabilities.
-
Knowledge of master/reference data management, historical data modeling, data lineage, and cross-system reconciliation.
-
Experience supporting data architectures for advanced analytics and AI-enabled applications.
-
Experience working in financial services, capital markets, investment banking, or another highly regulated environment.
-
Experience operating in a cross-functional technology organization with shared responsibilities across Product Management, application engineering, and enterprise infrastructure teams.
Licenses/Certifications:
- None required.
How this job compares
Set against the 1,554 open Data Architect jobs on Olive Jobs, counted November 18, 2026.
- Pay
- This postingNot listed
- Florida median$116–242K/yr48 salary ranges
- Openings
- Olive Jobs lists 69 open Data Architect jobs in Florida and 1,554 across the US. 14% of them nationwide are listed as remote or flexible.
- Experience
- This posting asks for at least 8 years of experience; Data Architect postings that state a minimum ask for 8 years at the median (1,384 postings).
- Education
- 425 of the 1,554 open Data Architect jobs (27%) ask for a bachelor's degree or higher.
Counted across the open, public US postings on Olive Jobs on November 18, 2026. Figures based on too few postings are left out.
Prepare for this role
You've read the whole posting — now see how you match it.



