Lead Technical Data Analyst

Posted 4 Days Ago
2 Locations
In-Office
Expert/Leader
Financial Services
The Role
Lead the requirements and data-mapping work for an AWS-based data platform: elicit/document business and data requirements, build source-to-target mappings and data dictionaries, define testable data quality rules, support dimensional modeling and UAT, coordinate across engineering/risk/platform teams, manage BA backlog in ADO/Confluence, and leverage AI assistants to accelerate analysis and test-case generation.
Summary Generated by Built In

Job Description Summary

This position follows a hybrid work model, with an expectation to be in the office 3 days per week at the St. Petersburg, FL Corporate Office location.
Please note: This role is not eligible for Work Visa sponsorship, either currently or in the future.

Job Description

About the Role:

We need a Lead Technical Data Analyst who can own the requirements and data-mapping side of our AWS data platform. You do not need to be an expert in every AWS service day one; you need strong business-analysis fundamentals, solid SQL, and a good grasp of how data warehouses and data lakes work. You will work with engineers, risk analysts, and platform teams to turn business needs into clear, testable requirements.

Why This Role Stands Out:

You will be part of a team that is augmenting business/data analysis with AI directly inside the IDE. We use Claude models to accelerate the hard parts of the job: mapping data gaps, drafting requirements and user stories, generating test cases, analyzing datasets, and helping engineers review code and outputs. You will spend less time on boilerplate and more time on the judgment, domain expertise, and stakeholder work that actually matters.

What You’ll Do
  • 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.

What We’re Looking For:
  • 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, 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.

  • Experience in financial services or risk/data analytics is a plus.

Education

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

Work Experience

General Experience – 10 to 15 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-SA1

Skills Required

  • 5+ years as a business analyst in data, BI, reporting, or data-integration projects
  • General experience 10 to 15 years
  • Strong understanding of data warehouse concepts (ETL/ELT, dimensional modeling, star schema, SCD Type 1/2)
  • Solid SQL; able to read and validate 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 and tools such as ADO (Azure DevOps) or Jira, and Confluence
  • Strong communication, documentation, and stakeholder-management skills
  • Curiosity and willingness to use AI assistants (e.g., Claude) to support analysis and requirements work
  • Bachelor's degree (Business Administration or Computer and Information Science) or HS (listed as required)
  • Experience in financial services or risk/data analytics
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Saint Petersburg, FL
14,491 Employees
Year Founded: 1962

What We Do

Founded in 1962 and a public company since 1983, Raymond James Financial, Inc. is a Florida-based diversified holding company providing financial services to individuals, corporations and municipalities through its subsidiary companies engaged primarily in investment and financial planning, in addition to capital markets and asset management. The firm's stock is traded on the New York Stock Exchange (RJF). Through its three broker/dealer subsidiaries, Raymond James Financial has approximately 8,400 financial advisors throughout the United States, Canada and overseas. Total client assets are $1.18 trillion (as of 9/30/2021). Raymond James has been recognized nationally for its community support and corporate philanthropy. The company has been ranked as one of the best in the country in customer service, as a great place to work and as a national leader in support of the arts.

Similar Jobs

CrowdStrike Logo CrowdStrike

Sr. Brand Media Manager (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
130K-200K Annually

Comcast Logo Comcast

Account Executive

Digital Media • Information Technology • News + Entertainment
Hybrid
Nashville, TN, USA
115000 Employees

CrowdStrike Logo CrowdStrike

Senior Consultant

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
115K-160K Annually

CrowdStrike Logo CrowdStrike

Red Team Services Manager (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
140K-195K Annually

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account