Lead Analyst, Data Analytics

Role Summary

• Serves as the primary Power BI developer and reporting lead for Legal, Compliance, Audit & Risk (LCAR) and Enterprise Risk Management (ERM), owning end-to-end delivery of reporting solutions and executive dashboards.
• Partners with stakeholders to translate complex business needs into scalable insights, while leading high-visibility reporting initiatives and supporting ad hoc analysis.
• Enhances reporting accuracy and efficiency through data modeling, automation, data quality improvements, and governance best practices.
• Daily work includes data ingestion (Power Query), data modeling (DAX), dashboard development, stakeholder meetings, production support, automation needs, and AI incorporation.
• 4 days per week on-site in Owings Mills, MD is required.

Responsibilities

• Independently conducts advanced, complex statistical and quantitative analyses for assigned area. In partnership with business subject matter experts, leads development of advanced statistical modeling and quantitative analysis projects. Serves as a resource to less experienced team members in development of advanced methodologies and techniques.
• Validates and reviews results to ensure they address identified business needs. Reports results to senior leaders as needed.
• Prepares visualizations and delivers results to management and/or other leaders. In partnership with business subject matter experts, provides recommendations for addressing observed outcomes. Translates complex technical concepts and analyses to nontechnical audiences.
• Partners with cross-functional leadership to define the firm's data-related requirements. Creates and manages the strategy and ensures data deliverables and processes drive business results for key segments of the firm. Oversees internal and external business partners in the execution of the plan. Drafts project plans, use cases, user stories, or business cases.

Qualifications

Required:

• Bachelor's degree or the equivalent combination of education and relevant experience AND 8+ years of total relevant work experience.

Preferred:

• Power BI (advanced proficiency required).
• Power Query (M) and DAX for complex calculations and KPIs, ETL, and data transformation.
• Power Automate (workflow automation).
• Coding background of any sorts: Python, SQL, VBA, etc.
• SharePoint / OneDrive integration for data storage and refresh.
• Strong data modeling expertise (fact/dimension design, relationships, performance optimization).
• Experience working with large, complex datasets across multiple sources.
• Understanding of introducing AI overlays into reports (CoPilot) .
• Strong stakeholder management and communication skills.

FINRA Requirements

FINRA licenses are not required and will not be supported for this role.

Work Flexibility

This role is eligible for hybrid work, with up to one day per week from home.

Base Salary Ranges

Please review the job posting for the location of this specific opportunity.

$122,000.00 - $209,000.00 for the location of: Maryland, Colorado, Washington and remote workers
$135,000.00 - $230,000.00 for the location of: Washington, D.C.
$153,000.00 - $261,000.00 for the location of: New York, California

Placement within the range provided above is based on the individual’s relevant experience and skills for the role.  Base salary is only one component of our total compensation package.  Employees may be eligible for a discretionary bonus, which is determined upon company and individual performance.

Commitment to Diversity, Equity, and Inclusion

At T. Rowe Price, our associates are our greatest asset. We thrive because our company culture is built on inclusion and because we sustain a work environment where associates can bring their best selves to work every day. The backgrounds, talents, and experiences of our global associates allow us to embrace new ideas and perspectives that move our business priorities forward and enable us to deliver strong client outcomes. Here, you can expect equal opportunity and fair and consistent treatment for all. 

Benefits

T. Rowe Price is an equal opportunity employer and values diversity of thought, gender, and race. We believe our continued success depends upon the equal treatment of all associates and applicants for employment without discrimination on the basis of race, religion, creed, color, national origin, sex, gender, age, mental or physical disability, marital status, sexual orientation, gender identity or expression, citizenship status, military or veteran status, pregnancy, or any other classification protected by country, federal, state, or local law.