Cornerstone Research · 6 hours ago
Senior Developer, BI Reporting
San Francisco, CA
Full-time
Onsite
Senior Level, Lead/Staff
$137K/yr - $167K/yr
8+ years expCornerstone Research is a firm that provides economic and financial analysis and expert testimony in commercial litigation and regulatory proceedings. The Senior Developer, BI Reporting will lead initiatives in business analysis and financial reporting, designing and maintaining reporting solutions using Microsoft Power BI and SQL Server while collaborating with cross-functional teams to support strategic decision-making.
AccountingConsultingFinancial ServicesLegal
Responsibilities
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
Qualification
Required
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
Benefits
Annual performance bonus
Flexible options for healthcare
Paid time off
Retirement savings
Company
Cornerstone Research
Cornerstone Research provides economic and financial analysis in all phases of commercial litigation and regulatory proceedings.
501-1000 employees
H1B Sponsorship
Cornerstone Research has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (50)
2024 (42)
2023 (38)
2022 (33)
2021 (28)
2020 (50)
Funding
Current Stage
Late StageLeadership Team
Rahul Guha
Chief Executive Officer
Gary C Schmirer
Vice President
Recent News
2025-09-30
Company data provided by crunchbase