Legg Mason

Data Architect - Junior

Job Locations US-MD-Baltimore
Req. #
Global Information Business Solutions
Position Type

Position Overview

Legg Mason is seeking a rockstar Junior Data Architect to create, manage, and maintain data architecture and data service components in raw, curated, and organized zones to turn into knowledge. The Junior Data Architect will report to the Head of Digital Business Intelligence (BI) and Enablement and work across the organization globally to execute the firm’s enterprise data management strategy.  This role works directly with business owners, engineers and data scientists.This position provides hands-on technical design and implementation ensuring technologies are successfully incorporated into customer environments.  The position will work out of our Baltimore office.

Key Responsibilities & Duties Include, but not Limited to


This person will design and create physical data models using conceptual and logical models. Areas of core competency are below.

  • Facilitate data architecture working sessions across BI and Analytics teams
  • Document and maintain data standards, lineage and attribute mapping from data sources
  • Create and maintain catalogue tables in Athena and RedShift spectrum
  • Create and maintain tables in Redshift database
  • Design optimal data presentation environment for the customer and works with various reporting tools.
  • Work with Tableau and Business Objects developers to design Tableau Data Extracts and Business Objects Universes
  • Provide support to various data zones to ensure interoperability with BI and Analytics solutions
  • Collaborate with teams to integrate systems
  • Work with Data Scientists to create appropriate data sandboxes to develop machine learning models.
  • Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for complex projects.



Ideal Qualifications and Experience


  • Understanding of data warehousing and data mining.
  • Familiarity with S2, Athena and Redshift.
  • Familiarity with BI technologies. (Tableau & Business Objects)
  • Good understanding of cloud technologies preferably AWS.
  • Good understanding of SQL.
  • Ability to take initiative and be innovative.
  • Background in data analysis.
  • Analytical mind with a problem-solving aptitude.
  • BSc/BA in Computer Science, Engineering or relevant field.

Company Overview

As a leading global asset management firm, Legg Mason offers rewarding career opportunities for individuals who share our passion for investing, and our commitment to putting clients first in everything we do. Whether you have industry experience and are seeking new challenges or are just beginning your career, we invite you to explore the many advantages of joining our global team.


With a presence in every major financial center across the globe, we are always looking for exceptional professionals who want to shape a rewarding career through intellectual curiosity, leadership and collaboration. If you're looking to build your future with one of the industry's premier firms, consider the many opportunities at Legg Mason today.


Legg Mason offers a competitive salary and comprehensive benefits package which includes medical, dental, vision, 401(k), profit-sharing, paid time off, employee stock purchase plan, tuition reimbursement, parental leave, and much more.  Learn more about our amazing culture and our comprehensive benefits package here. EOE


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed