Data Modeler Lead

Raymond James•Saint Petersburg, FL
•Hybrid

About The Position

Raymond James is seeking an experienced, hands-on Data Modeler & Architecture Lead to support the Capital Markets & Advisory (CMA) Technology organization. The role is a senior technical leadership position within CMA Technology Product Management, connecting business requirements, data architecture, database engineering, and application development across on-premises and cloud data environments. The position requires deep technical expertise in Microsoft SQL Server, Oracle, AWS, and enterprise data modeling, along with an understanding of business processes and application architecture. The successful candidate will work 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 hands-on role involving database analysis, SQL development and optimization, production troubleshooting, data modeling, and guidance of technical implementations. The role also supports CMA's hybrid-cloud modernization strategy and the development of governed, reliable data foundations for enterprise reporting, analytics, and AI-enabled business capabilities. The position follows a hybrid-friendly schedule, with three in-office days per week, including a Monday or Friday, at the St. Petersburg, Florida Corporate Office. It is not eligible for work visa sponsorship, currently or in the future. Travel is less than 25%. The position is eligible for a benefits package that may include medical, dental, and vision coverage; life, critical illness, accident, and disability insurance; retirement savings; paid time off, including vacation, holidays, and sick leave; and parental leave. Eligibility and specific offerings may vary by position and employment status. Total compensation includes base salary or wages and may include additional compensation, discretionary bonuses, or commissions.

Requirements

  • More than eight 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.
  • 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 across Product Management, Development, Infrastructure, and business teams.
  • Work visa sponsorship is not available for this position, currently or in the future.
  • Travel of less than 25%.

Nice To Haves

  • 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 in financial services, capital markets, investment banking, or another highly regulated environment.
  • Experience in a cross-functional technology organization with shared responsibilities across Product Management, application engineering, and enterprise infrastructure teams.

Responsibilities

  • Design, develop, and maintain conceptual, logical, and physical data models for operational applications, databases, data warehouses, reporting, and analytics platforms.
  • Translate business processes, Product Owner requirements, and operational workflows into data architectures, schemas, entity relationships, business rules, and technical specifications.
  • Establish authoritative, reusable data models and identify 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.
  • 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 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, and recommend improvements.
  • Support the design and evolution of hybrid-cloud data architectures that integrate 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 on scalable, secure, and cost-effective AWS database and analytics solutions.
  • Develop transition architectures that preserve existing application functionality while enabling cloud modernization.
  • Help establish reusable data services and cloud-based data foundations for future business capabilities.
  • 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 align solutions with requirements for access controls, data entitlements, ethical walls, auditability, and information security.
  • Improve documentation of data definitions, source systems, transformations, dependencies, and technical architecture.
  • Work with CMA business stakeholders and Product Owners to understand workflows, data requirements, operational challenges, and improvement opportunities.
  • Translate business needs into technical requirements, architecture recommendations, and prioritized engineering work.
  • Serve as a primary technical coordination point for assigned CMA database and data architecture initiatives, partnering 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 production support and application enhancement needs with longer-term data architecture and modernization priorities.
  • Communicate technical findings, solution options, dependencies, risks, and tradeoffs to business and technology stakeholders.

Benefits

  • Medical, dental, and vision coverage may be available.
  • Life insurance, critical illness insurance, and accident insurance may be available.
  • Disability benefits may be available.
  • Retirement savings may be available.
  • Paid time off, including vacation, holidays, and sick leave, may be available.
  • Parental leave may be available.
  • Total compensation may include additional compensation, discretionary bonuses, or commissions.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service