Lead Data Analyst - AI-Driven Data Platform

Raymond James; Memphis (TN); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Raymond James in St. Petersburg, FL is seeking a Lead Technical Data Analyst to own requirements and data-mapping for our AWS data platform.

This hybrid role values strong business-analysis fundamentals, solid SQL, and a practical grasp of how data warehouses and data lakes work. You’ll collaborate with engineers, risk analysts, and platform teams to turn business needs into clear, testable requirements, user stories, mappings, and data dictionaries.

Qualifications

• 5+ years of experience as a business analyst in data, BI, reporting, or data‑integration projects.
• Strong understanding of data warehouse concepts: ETL/ELT, dimensional modeling, star schema, slowly changing dimensions, fact vs. dimension tables.
• Solid SQL; comfortable reading and validating queries across Oracle, SQL Server, or cloud query engines.
• Familiarity with one or more AWS data services.
• Experience writing acceptance criteria, source-to-target mappings, and data dictionaries.
• Experience with Agile/Scrum, ADO or Jira, and Confluence.
• Strong communication, documentation, and stakeholder‑management skills.
• Curiosity about using AI assistants to raise the quality and speed of analysis.

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

Business analysis

SQL

AWS data services

Agile/Scrum

Stakeholder management

Education

Bachelor's degree in Business Administration

Bachelor's degree in Computer and Information Science

High School Diploma

Tools

Jira

Confluence

ADO

Job description

Raymond James in St. Petersburg, FL is seeking a Lead Technical Data Analyst to own requirements and data-mapping for our AWS data platform.

This hybrid role values strong business-analysis fundamentals, solid SQL, and a practical grasp of how data warehouses and data lakes work. You’ll collaborate with engineers, risk analysts, and platform teams to turn business needs into clear, testable requirements, user stories, mappings, and data dictionaries.