Lead Data Analyst - AI-Driven Data Platform

Raymond James; Saint Petersburg (FL); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement plan

Paid time off

Parental leave

Job summary

Raymond James in Saint Petersburg, FL, is seeking a Lead Technical Data Analyst to own requirements and data-mapping for our AWS data platform. Hybrid model, in-office 3 days/week.

You will translate business needs into testable user stories, build source-to-target mappings and data dictionaries, and ensure data quality and UAT support. Experience with data warehouses, SQL, and AWS data services is essential.

Qualifications

• 5+ years as a business analyst in data, BI, reporting, or data‑integration projects.
• Strong understanding of data warehouse concepts: ETL/ELT, dimensional modeling, star schema, SCD Type 1/2.
• Solid SQL; comfortable reading and validating queries across Oracle, SQL Server, or cloud query engines.

Responsibilities

• Elicit and document business and data requirements as user stories, PBIs, BRDs, and acceptance criteria.
• Build source-to-target mappings and data dictionaries for Oracle, SQL Server, vendor files, and cloud data products.
• Define data quality and reconciliation rules with engineering and make sure they are testable.
• Support dimensional modeling decisions—facts, dimensions, SCD Type 1/2, and table classifications such as temporal, append-only, and snapshot.
• Validate delivered data products against requirements and support UAT.
• Coordinate across risk, data engineering, and platform teams; keep requirements and documentation organized in ADO / Confluence.
• Help shape the backlog and sprint priorities for the BA workstream.
• Use AI tooling to speed up mapping, requirements drafting, test-case generation, data analysis, and review tasks.

Skills

SQL

Data warehousing

Business analysis

AWS data services

Agile/Scrum

Stakeholder management

Documentation

AI tooling

Data dictionaries

Education

Bachelor’s: Business Administration

Bachelor’s: Computer and Information Science

High School (HS)

Tools

Confluence

Jira

ADO

Job description

Raymond James in Saint Petersburg, FL, is seeking a Lead Technical Data Analyst to own requirements and data-mapping for our AWS data platform. Hybrid model, in-office 3 days/week.

You will translate business needs into testable user stories, build source-to-target mappings and data dictionaries, and ensure data quality and UAT support. Experience with data warehouses, SQL, and AWS data services is essential.