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.
QualificationsRequired:- 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 RequirementsFINRA licenses are not required and will not be supported for this role.
Work FlexibilityThis role is eligible for hybrid work, with up to one day per week from home.
Base Salary RangesPlease 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.
BenefitsWe value your goals and needs, at work and in life. As an associate, you'll be supported with resources, benefits, and work-life balance so you can thrive in ways that matter to you.
Featured employee benefits to enrich your life:
- A generous retirement plan
- Health and wellness benefits, including online therapy
- Paid time off for vacation, illness, medical appointments, and volunteering days
- Family care resources, including fertility and adoption benefits
Learn more about our benefits.
