Senior Developer, BI Reporting

We need to output HTML fragment with sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title as heading. No Job ID etc. Remove boilerplate. We need to parse the posting. First part: "Role Overview Senior Developer, BI Reporting (Aderant Developer) (HYBRID – All US Offices: SF, LA, CHI, BOS, NY, D.C.) If you are a Senior Developer with Aderant experience 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,100-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 five 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 improvementSet and strive for a high bar of excellenceBelieve 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 longerAre passionate about what you do" That's about role overview and culture. Could be "About the role" or maybe "About the role" includes overview. We'll put that under

About the role. Next: "How You'll Help Our Team Succeed" then bullet list of responsibilities. That's responsibilities. Then "What You'll Need To Be Successful" then list of requirements (experience, skills). That's requirements/qualifications/skills. We need to separate maybe Requirements (experience) and Skills (technical). But we can combine? The instruction: prefer few substantive sections over many thin ones. We could have sections: About the role, Responsibilities, Requirements, Benefits, Pay. Possibly also Qualifications? But we can treat Requirements as encompassing qualifications and skills. However we have separate headings list: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We should only include sections that have real specific content. We have content for About the role, Responsibilities, Requirements (experience), Skills (technical), Benefits, Pay. No schedule info (no mention of schedule beyond hybrid). Hybrid is mentioned but not schedule details like hours. Could we put Schedule? The posting mentions hybrid work model but not specific schedule. Might be considered schedule info? It says "Hybrid work model that balances collaborative in-office time with telecommuting flexibility". That's schedule-ish. Could include Schedule section with that detail. But we need to check if we should include schedule only if posting actually states them. It does state hybrid work model. So we could include Schedule. Qualifications: maybe we can include education and credentials. The posting includes Bachelor’s degree etc. That's qualifications. So we could separate Requirements (experience) and Qualifications (education/credentials) and Skills (technical). But we have a lot of sections; maybe better to combine but instruction says prefer few substantive sections over many thin ones. So we should avoid too many thin sections. Let's decide: We'll have About the role, Responsibilities, Requirements (includes experience, education, qualifications), Benefits, Pay, Schedule. That's 6 sections. That's okay. But we need to follow the headings list exactly? It says use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't say we must use all; we can omit if no content. So we can choose subset. Now we need to extract content. About the role: combine first paragraph up to "You’ll Love It Here If You..." maybe include that as part of about role. Let's capture: "Senior Developer, BI Reporting (Aderant Developer) (HYBRID – All US Offices: SF, LA, CHI, BOS, NY, D.C.) If you are a Senior Developer with Aderant experience 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,100-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 five 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 improvementSet and strive for a high bar of excellenceBelieve 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 longerAre passionate about what you do" We need to format as prose

. Possibly break into paragraphs but can be one. Responsibilities: list from "How You'll Help Our Team Succeed" bullet points. Let's extract each line: - 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. We'll put each as

. Requirements: from "What You'll Need To Be Successful" list. Let's extract: - 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. We could separate qualifications (education, certification) but we can include all in Requirements. Benefits: from "A Holistic Investment in You Benefits" paragraph. Let's extract: - Health & Wellness: Comprehensive healthcare options, a monthly wellness subsidy, and complimentary access to premium wellness apps. - Financial Security: Robust retirement savings plans to secure your long-term financial goals. - Work-Life Blend: A hybrid work model that balances collaborative in-office time with telecommuting flexibility, alongside generous paid time off to recharge. - Family & Personal Support: Specialized support including fertility treatments, parental leave, back-up childcare, eldercare services, concierge assistance for personal errands, and pet care. - Growth & Culture: A firm-wide commitment to mentorship, continuous learning, and a vibrant, inclusive community. - Please note that relocation assistance is not available for this role. We'll put as list. Pay: from "Compensation Base Salary Range:" list per city and bonus. We'll include: - Base Salary Range: - Boston: $136,800 – $166,700 - Chicago: $129,700 – $157,900 - Los Angeles: $135,900 - $165,500 - New York: $139,200 – $169,500 - San Francisco: $149,200 – $181,700 - Washington, DC: $134,300 – $163,600 - Individual base compensation will be tailored to your primary work location and the unique depth of experience you bring to the firm. - Annual Performance Bonus: This role is eligible for a discretionary bonus with a target of 12.5%. This serves as a meaningful way for us to celebrate excellence, awarded based on both individual impact and our collective success as a firm. Schedule: from hybrid mention: "Hybrid work model that balances collaborative in-office time with telecommuting flexibility". Also location list earlier: (HYBRID – All US Offices: SF, LA, CHI, BOS, NY, D.C.). We'll include schedule: Hybrid work model with flexible in-office/remote. Now produce HTML fragment with

headings and

or

• . Ensure no extra text. Let's craft. We'll need to escape any HTML special characters like &, <, >. In text we have "&". Use &. Also we have "IT or financial systems reporting." fine. We'll produce:

  About the role

  ...

  Responsibilities