Technical Financial Analyst

Husch Blackwell; Denver (CO); Remote; USD 75,000 - 134,000; Full time

Job summary

A leading law firm is seeking a Technical Financial Analyst to enhance financial tools and reporting. This role involves writing complex SQL queries, analyzing financial data, and collaborating with other analysts. The position offers opportunities for remote work and a supportive environment for diverse professionals.

Benefits

Medical and dental coverage

Life insurance

Paid Time Off

Retirement plan participation

Qualifications

• Proven experience as Financial Analyst or Data Analyst.
• Extensive experience with SQL for data manipulation.

Responsibilities

• Enhance tools, functions, and procedures for financial reporting.
• Prepare and present detailed financial reports and dashboards.
• Analyze and distribute financial and statistical reports.

Skills

Analytical skills

Problem-solving skills

SQL

Data visualization

Education

Bachelor’s degree in related field

MBA or CFA

Tools

Power BI

Microsoft Excel

Job description

Husch Blackwell LLP is a full-service litigation and business law firm with multiple locations across the United States, serving clients with domestic and international operations.

At Husch Blackwell we believe that diverse, equitable and inclusive teams lead to better outcomes. Husch Blackwell is committed to retaining, recruiting, developing, and promoting talented lawyers and business professionals with diverse backgrounds and experiences. We foster an engaged, diverse, and inclusive team culture of accountability and purpose that makes our Firm and our communities better.

Our firm is committed to attracting and retaining professionals who value each other and the service we provide by embracing Teamwork, Collaboration, Client Service, and Innovation. If you are a motivated professional looking for a long-term fit where you can grow in a role, and will be valued and empowered, then we invite you to apply to our Technical Financial Analyst position. This position may be filled remotely, or in any of our locations.

The Technical Financial Analyst is responsible for enhancing tools, functions, and procedures, assisting with software implementations and upgrades, and analyzing and distributing financial and statistical reports. The position requires expertise in writing complex SQL queries, designing customized reports for internal and external clients, and visualizing financial data to uncover key insights and trends. Essential job junctions include :

• Serve as the subject matter expert for reporting sources and tools; collaborate with other Financial Analysts to ensure comprehensive knowledge of reporting responsibilities.
• Extract, transform, and load (ETL) data from various sources using SQL.
• Prepare and present detailed financial reports and dashboards that streamline distribution of financial data to support strategic initiatives.
• Lead projects of varying sizes and complexities.
• Contribute to the enhancement of tools, functions and procedures, including assistance with software implementations and upgrades.
• Prepare, analyze and distribute financial and statistical reports.
• Write complex Structured Query Language (SQL) queries to mine, manage and analyze large datasets.
• Analyze potential lateral hires; review historic statistics, project impact to firm and make recommendations on hiring.
• Design and develop customized reporting for internal and external client needs.
• Visualize financial data to highlight key insights and trends; comparison to industry and peers; identify areas of risk and opportunity.
• Conduct detailed statistical analysis of Firm, SBU, clients or timekeepers.
• Assist with preparation and monitoring of budget and forecast; provide variance analyses.
• Deliver profitability analytics that align with the Firm’s strategic goals.
• Other duties as assigned.

Position Requirements

• Bachelor’s degree with major coursework in related field; or combination of education and commensurate work experience required.
• Proven experience as Financial Analyst, Data Analyst or similar role, preferably in a professional services environment.
• Advanced degree (MBA or CFA) or relevant certification preferred, but not required.
• Extensive experience with SQL for data manipulation and analysis required.
• Expertise in Power BI (including DAX functions and Power Query) preferred.
• Strong analytical and problem-solving skills.
• Proficiency in Microsoft Excel (advanced functions / macros).
• Familiarity with financial modeling and forecasting.

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of essential functions, responsibilities, or requirements. The Firm will provide reasonable accommodations as necessary to allow an individual with a disability to apply for and / or perform the essential functions of a position. If you need assistance to accommodate a disability, please contact HR.

COMPENSATION AND BENEFITS

Employees are entitled to compensation commensurate with skill and experience. The exact compensation will vary based on skills, experience, location, and other factors permitted by law. The expected compensation ranges for this position in various states and jurisdictions are as follows :

• State of California : $82,000 - $156,000
• State of Colorado : $75,000 - $134,000
• Jersey City, NJ : $89,000 - $161,000
• State of Massachusetts : $82,000 - $156,000
• State of New York : $76,000 - $164,000
• State of Washington : $79,000 - 150,000
• Washington, $106,000 - 155,000

The above salaries do not include a discretionary bonus, however bonus opportunities are non-guaranteed, and are dependent upon individual and firm performance. Full-time employees receive benefits including : medical and dental coverage; life insurance; short-term and long-term disability insurance; pre-tax flexible spending account for certain medical and dependent care expenses; an employee assistance program; Paid Time Off; paid holidays; participation in a retirement plan program after meeting eligibility requirements; and more.

Please submit a cover letter and resume when applying.

EOE / Minority / Female / Disabled / Vet. Principal Applicants Only.