Hiring.Camp

Data Modeler Lead

Raymond James

·

Today

Location
FL - Saint Petersburg - 880 Carillon Pkwy, United States of America
Workplace
Hybrid
Type
Full-time
Seniority
Lead
Education
High School
Visa
Not sponsored
Source
Workday

Description

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.

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.

Education

Bachelor’s - Completed: Business Administration, Bachelor’s - Completed: Computer and Information Science, Bachelor’s - Completed: Computer Engineering, High School (HS) - Completed (Required)

Work Experience

General Experience - 3 to 6 years

Certifications

Travel

Less than 25%

Workstyle

Hybrid

The total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions. This position is eligible for a benefits package that may include medical, dental, and vision; life insurance; critical illness insurance and accident insurance; disability benefits; retirement savings; paid time off (including vacation, holidays, and sick leave); and parental leave.  Eligibility for benefits and specific offerings may vary based on position and employment status. To view more details of the benefits offered, visit Myrjbenefits.com.

 

 

At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. 

We expect our associates at all levels to:
•  Grow professionally and inspire others to do the same
•  Work with and through others to achieve desired outcomes
•  Make prompt, pragmatic choices and act with the client in mind
•  Take ownership and hold themselves and others accountable for delivering results that matter
•  Contribute to the continuous evolution of the firm

At Raymond James – as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates.  When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs. 

#LI-NM1

Skills

PythonAWSSQLOracleSQL ServerETLTableauPower BI

Similar Jobs

8

Data Modeler - Lead

Lingaro·Mumbai, Maharashtra·Remote

1mo ago

Lead IT Data Modeler INT

TYIT·Mumbai, Maharashtra

4mo ago

Lead IT Data Modeler INT

Tyson Foods, Inc.·Mumbai, Maharashtra

4mo ago

Lead IT Data Modeler INT

Tyson Foods, Inc.·Mumbai, Maharashtra

4mo ago

Lead Data Engineer - Data Modeler

EXL Talent Acquisition Team·Pune, Maharashtra·Hybrid

6mo ago

Lead Data Engineer - Data Modeler

EXL·Pune, Maharashtra·Hybrid

6mo ago

Lead Data Modeller

Resmed·Australia

Today

Data Acquistion Module Lead

Harmattan AI·Paris, Île-de-France·Onsite

1w ago