Sql analyst Jobs in Aurora, CO

Pricing Analyst

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 Pricing Analyst position. This position may be filled remotely, or in any of our locations.

The Pricing Analyst supports Pricing Team in administering pricing objectives that align with Firm strategy by compiling and analyzing financial data, creating models to support pricing efforts, and building reports to track actuals and identify trends. Essential functions include:

• Assist Pricing leadership with the development of pricing programs and financial models and provide ongoing measurement on their effectiveness.
• Analyze market trends and competitor pricing to identify strategic opportunities and improvements.
• Collaborate with cross-functional teams to support business objectives.
• Generate financial analyses that support the development of pricing strategies, pricing policies, and optimization of pricing management.
• Provide ongoing profitability analytics, and timely and accurate financial information to support firm's client profitability objectives.
• Support the annual billing rate-setting process, including benchmarking analysis and ongoing maintenance of hourly and alternative fee arrangements.
• Maintain and validate the accuracy of pricing databases, tools, and templates, including Iridium and Elite 3E, to ensure consistent and reliable data capture.
• Prepare and present pricing analyses, reports, and dashboards to Pricing leadership and attorneys to support decision-making.
• Provide ad hoc financial analyses as requested.
• Assist in developing and maintaining a pricing model database.
• Assist in responding to requests from attorneys for matter planning, budgeting, and tracking.
• Identify and implement opportunities to leverage Excel and automation to minimize effort where possible.
• Assist in responding to requests for proposals specific to alternative pricing strategies; prepare pricing estimates.
• Other duties as assigned.

Core requirements include:

• Ability to deliver superior service to all internal and external customers and communicate effectively.
• Ability to interact in a professional and courteous manner with clients and employees at all times; professional appearance required.
• Ability to successfully perform position requirements with excellent organizational, time-management and prioritization skills required.
• Ability to work collaboratively within a team; ability and willingness to adapt to changing business demands.
• Ability to produce acceptable amount of work efficiently and accurately; ability to produce quality final work product.
• Ability to exercise good judgment at all times by making sound and practical decisions; ability to assume responsibility for decisions and act decisively under deadlines.
• High level of professional integrity required; ability to maintain confidentiality and build trust.

Position requirements include:

• 4-year degree with major coursework in Finance preferred; or combination of education and commensurate work experience required.
• 2+ years of related work experience in pricing, financial, profitability analysis or economics, preferably in a professional services environment; knowledge of legal statistical modeling and pricing tools required.
• Robust analytical skills and ability to utilize computer systems and related tools, including Iridium, Elite 3E, Microsoft Excel, Outlook, Word and PowerPoint.
• Strong written and interpersonal communication skills.
• Demonstrated proficiency in all Microsoft office products, specifically Excel.

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 are 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: $72,000 - $146,000
• State of Colorado: $66,000 - $118,000
• State of Connecticut: $57,000 - $144,000
• State of Illinois: $65,000 - $126,000
• State of Maine: $49,000 - $113,000
• State of Maryland: $70,000 - $105,000
• State of Massachusetts: $72,000 - $137,000
• State of Minnesota: $72,000 - $119,000
• Jersey City, NJ: $78,000 - $141,000
• State of New York: $67,000 - $144,000
• State of Vermont: $71,000 - $136,000
• State of Virginia: $47,000 - $136,000
• State of Washington: $70,000 - $132,000
• Washington, D.C.: $93,000 - $136,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 include a cover letter and resume when applying.

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