Senior Developer, BI Reporting

Overview

SENIOR DEVELOPER, BI REPORTING (HYBRID - LOS ANGELES)

If you are a Power BI expert looking for an opportunity to showcase your design, development and administration of financial reports, then we would like to meet with you!

The Senior Developer, BI Reporting will have primary responsibility for leading various analysis and programming initiatives in Cornerstone Research's IT applications development department, utilizing a high degree of knowledge in the overall field of business analysis and financial reporting.

At Cornerstone Research, you will be part of a thriving, 900-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

• Develop visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Hands on experience in creating and deploying Power BI reports, analytic, and dashboard solutions including design, development, deployment, data engineering, and data management projects and practices.
• Implementing row-level security on data along with an understanding of application security layer models in Power BI.
• Act as Power BI administration, manage and troubleshoot premium capacity environment.
• Work 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 reporting requests.
• Design and implement business intelligence solutions to support the decision makers and users of the data by utilizing, but not limited to, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI
• Create, compile, and prepare management reports, graphs, and charts, including highly complex internally developed custom reports utilizing TSQL, Excel, Access, VBA, SSRS and Power BI
• Maintain and improve reporting data infrastructure which contains data compiled from Aderant Expert, Host Analytics, UltiPro, Legal Key, and other source systems. This includes troubleshooting issues and anomalies in system data, data validation, and maintaining system continuity.
• Participate in month-end accounting system close, and reporting.
• Maintain data integration between systems, creating automated data feeds, and structuring data for use by the data warehouse.

What You'll Need to Be Successful

• 8+ years of experience that demonstrates increasing capability and responsibility; professional services experience preferred.
  • 8+ years of experience with SQL and T-SQL programming.
  • 8+ years of experience working with SSRS reports.
  • 7+ years of experience working with and translating company financial data into executive-level reports and KPIs.
  • 5+ years of experience working with Aderant databases, including SQL Server 2012/2016/2019, SSAS, SSRS, and SSIS, and other hands-on financial systems experience.
  • 3+ Years expert level experience with Power BI Development and administration.
• Hands on experience in creating and deploying Power BI reports, analytics, and dashboard solutions including design, development, deployment, data engineering, and data management projects and practices.
• The desire to take initiative and actively contribute to the team and the firm.
• The ability to communicate effectively and
• Strong business acumen and the ability to learn the firm's financial and operational
• The mindset to provide superior service.
• MS SQL report and Visual Basic programming experience.
• Advanced MS Office skills - especially Excel, including macro development and troubleshooting.
• Ability to successfully engage in multiple tasks simultaneously.
• Excellent problem-solving skills and techniques.
• Ability to identify opportunities and propose solutions.
• Ability to understand the perspective of the business and end users and apply that understanding to solution proposals.
• Ability to utilize IT Best Practices and IT tools related to application support, 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.
• Bachelor's degree in computer science or related field or equivalent experience preferred.

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.

The firm's uniquely collegial and 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 and enriching aspects of a career at Cornerstone Research.

Equal Employment Opportunity

Cornerstone Research is an equal employee opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, age, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other factors protected by law.

For Los Angeles Candidates Only: Cornerstone Research is offering a competitive market base salary for this position between $130,100 and $162,000. A job offer will depend on how closely a candidate's skills, experience and education match the requirements for the role. In addition to base salary, we offer a total compensation package that includes annual performance bonus and generous benefits.

Equal Employment Opportunity

Cornerstone Research is an equal employee opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, age, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other factors protected by law.