Senior Developer, BI Reporting

Cornerstone Research UK Ltd.; Town of Boston (NY); On-site; USD 139,200 - 169,500; Full time

Benefits offered by this job

Competitive total compensation package

Annual performance bonus

Comprehensive healthcare options

Paid time off

Retirement savings opportunities

Job summary

A leading consulting firm is seeking a Senior Developer to lead BI reporting initiatives. The role involves maintaining financial systems and developing reporting strategies using Power BI, SQL, and Aderant applications. Ideal candidates have over 8 years in financial reporting, are proficient with T-SQL, and possess advanced skills in Excel. This position offers a competitive salary range based on location, benefits, and a collaborative work environment.

Qualifications

• 8+ years of experience in IT or financial systems reporting.
• 5+ years of experience with Aderant applications.
• 3+ years of experience in Power BI development and administration.

Responsibilities

• Lead analysis and programming initiatives for BI reporting.
• Develop reporting strategies with Finance and IT teams.
• Maintain and improve reporting data infrastructure.

Skills

Business analysis

SQL

Power BI

Aderant applications

Data Warehouse

T-SQL programming

MS Office (Excel)

Education

Bachelor’s degree in computer science or related field

Tools

SQL Server

Excel

Job description

**Role Overview:**If you are a Senior Developer looking for an opportunity to showcase your Business & Financial Systems administration, then we would like to meet with you! The Senior Developer, BI Reporting, will lead various analysis and programming initiatives in Cornerstone Research’s Software Engineering department utilizing a high degree of knowledge in the overall field of business analysis and financial reporting. They will be responsible for designing, developing, and maintaining advanced reporting solutions using Microsoft Power BI, SQL Server, Data Warehouse and upcoming BI technologies. This role requires specialized experience with Aderant applications and a strong understanding of financial and operational data within a professional services or legal environment. They will collaborate with cross-functional teams to deliver data-driven insights that support strategic decision-making, operational efficiency, and financial transparency.At Cornerstone Research, you will be part of a thriving, 1,000-strong team that spans nine offices, comprises more than 55 nationalities, and leads the industry in its commitment to develop team members across all levels. *Inc.* Magazine has recognized Cornerstone Research three times as a Best Workplace for its outstanding employee engagement, collaborative culture, and professional growth opportunities.**You’ll Love It Here If You:*** Embrace learning and continuous improvement* Set and strive for a high bar of excellence* Believe that teamwork leads to success: ask us what it means to be #onefirmfirm!* Take pride in always doing your best work, even if it’s harder or takes longer* Are passionate about what you do**How You'll Help Our Team Succeed:*** Works with the Finance department and IT Reporting team in developing Cornerstone’s reporting strategy to determine scalable and appropriate solutions for the variety of financial and analytical reporting requests.* Develops and supports Aderant and related applications including Expert Time, Expert GL, Expert Billing, and Prebill Manager.* Maintains the financial systems, including the time and accounting system, payroll, fixed assets, budgeting, and financial reporting systems.* Participates in month-end accounting system close, and reporting and balancing.* Customizes reports and the user interface in Aderant Expert, including advanced scripting in Summit Basic, using the customization tools in Aderant Expert.* Integrates data from Aderant modules (e.g., Time & Billing, General Ledger, Matter Management) into Power BI using best practices.* Creates, compiles, and prepares management reports, graphs, and charts, including highly complex internally developed custom reports utilizing TSQL, Excel, Access, VBA, Power BI and SSRS.* Influences department processes, procedures, and strategy while driving employee development and collaborating with cross-functional teams.* Develops and maintains Power BI dashboards and reports using data from Aderant and other enterprise systems.* Translates business requirements into technical specifications and reporting solutions.* Optimizes data models and DAX queries for performance and usability.* Ensures data accuracy, consistency, and compliance with governance standards.* Documents report logic, data flows, and provides user support as needed.* Maintains and improves reporting data infrastructure which contains data compiled from several enterprise systems. This includes troubleshooting issues and anomalies in system data, data validation, and maintaining system continuity.* Assists financial system users to improve efficiency, data integrity, and ease of use.* Maintains data integration between systems, creating automated data feeds, and structuring data for use by the data warehouse. ##### **What You'll Need to Be Successful:*** Strategic 8+ years of experience in IT or financial systems reporting.* 8+ years of experience with SQL and T-SQL programming.* 5+ years of experience working with Aderant and related applications.* 3+ years of experience in Power BI development and administration.* 5+ years of experience with Datawarehouse technologies.* 3+ years of experience working with and translating company financial data into executive-level reports and KPIs.* Advanced MS Office skills - especially Excel, including macro development and troubleshooting.* Excellent problem-solving skills and techniques.* Ability to identify opportunities and propose solutions.* Ability to utilize IT Best Practices and IT tools related to application development, implementation, and documentation.* Thorough understanding of complex data models for Financial and related business systems along with underlying associated processes.* Strong understanding of relational database structures, advanced data concepts, theories, principles, and practices.* Excellent communication and interpersonal skills with demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the firm.* Bachelor’s degree in computer science or related field, or equivalent combination of education, skills, and experience.* Professional credential or certification in a relevant field.Cornerstone Research is offering a competitive market base salary for this position. The base salary range represents the low and high end of the salary range for this position in all eligible locations. This range may differ based on your geographic location and cost of living considerations. At Cornerstone Research, we believe compensation is more than just a base salary. We offer a competitive total compensation package that includes an annual performance bonus and comprehensive benefits such as flexible options for healthcare, paid time off, and retirement savings. Relocation assistance is not offered for this position.Boston: $136,800 – $166,700Chicago: $129,700 – $157,900Los Angeles: $135,900 - $165,500New York: $139,200 – $169,500San Francisco: $149,200 – $181,700Washington, DC: $134,300 – $163,600**Who We Are:**Cornerstone Research provides economic and financial analysis and expert testimony in all phases of commercial litigation and regulatory proceedings.We work with a broad network of testifying experts, including leaders from academia and industry, who are recognized for their depth of knowledge, accomplishments, and research. Our staff consultants contribute expertise in economics, finance, accounting, and marketing, as well as business acumen, familiarity with the litigation process, and a commitment to produce outstanding results.We’re looking for passionate individuals who share our firm’s core values and can bring varied perspectives and experiences to our team. The firm’s uniquely collegial, supportive atmosphere makes Cornerstone Research a great place to work. We invest in our people in a host of ways, from providing meaningful learning and development opportunities to organizing memorable social events. To many, our culture and our people are the most exciting, enriching aspects of a Cornerstone Research career.**Equal Employment Opportunity:**Cornerstone Research provides Equal Employment Opportunities to all employees and applicants for employment without regard to legally protected categories, such as age, sex, gender, gender identity, race, color, creed/religious belief, medical condition, predisposing genetic characteristics or genetic information or testing, disability, marital status, pregnancy status, military status, veteran status, arrest or conviction record (except where permitted by law), sexual orientation, ethnic background, citizen status, ancestry, national origin, or any other consideration protected by federal, state or local law.Cornerstone Research is a leading firm providing economic and financial consulting to attorneys and companies involved in complex commercial litigation and regulatory proceedings. We work