Demo

Senior Data Warehouse Analyst

Berkadia
Berkadia Salary
Ambler, PA Full Time
POSTED ON 3/7/2025
AVAILABLE BEFORE 6/6/2025

Are you looking for an opportunity to bring your unique skills and experiences to a leading commercial loan servicer?

Join Berkadia's loan servicing platform and learn from the best of the best at the largest non-bank commercial mortgage servicer in the industry. We provide the personal and professional development opportunities you need to impact the commercial real estate industry, build a career that takes the long view, and reach your full potential.  Be Your Best Self. Be Berkadia.

The Senior Data Warehouse Analyst at Berkadia will play a crucial role with high visibility among internal and external clients, primarily through the creation and delivery of detailed reports. The Senior Data Warehouse Analyst will serve as an expert in Cognos, our internal reporting system, providing specialized assistance to both our internal servicing teams and corporate departments. This role involves not only developing and refining reports but also ensuring their accuracy and timely distribution to meet the strategic needs of the organization.

We are committed to growing your career, so in this role you will :

  • Provide analytical support and develop reporting solutions for the Loan Servicing department.
  • Utilize a variety of tools including BI, SQL, Excel, and Access to fulfill operational and managerial requirements.
  • Identify and resolve issues related to complex reports, databases, and report scheduling.
  • Develop, refine, and maintain queries in SQL Server.
  • Oversee the distribution of scheduled reports to both external and internal stakeholders.
  • Ensure adherence to Berkadia and Private Label branding on designated reports and communications.
  • Create and distribute advanced reports for Senior Management and Rating Agencies on a recurring monthly basis.
  • Other duties as assigned.

We are passionate about your growth, so to achieve success in this role you should have :

  • Possess advanced report development skills, capable of creating various types of reports such as list, summary, cross-tab, charts, and free-form reports like forms and letters; proficiency in Microsoft products including Excel, Access, and Word is essential.
  • Experienced in report schedule management, with a deep understanding of relational databases and SQL, particularly with Microsoft SQL Server and SQL Server Management Studio.
  • Strong analytical skills with experience in report data modeling, user testing, and quality assurance; knowledge of Loan Servicing / Financial data and systems, especially McCracken’s Strategy Commercial Loan Servicing system, is highly beneficial.
  • Excellent communication and time management skills, with the ability to work independently with minimal supervision.
  • Bachelor's degree or equivalent
  • 3 years of experience in a similar position
  • We believe People Matter, so we offer benefits that go beyond :

  • Monthly paid volunteer hours and donation matching to benefit our communities
  • Employee Resource Groups that help you grow with us
  • Fertility and family planning services
  • Up to 12-weeks of fully paid parental leave
  • Mental health care, including free counseling sessions :
  • We'll help you fund your learning journey with generous tuition reimbursement
  • Pet insurance discounts
  • And more!
  • Be Your Best Self. Be Berkadia.

    LI-EP1 #LI-HYBRID

    Berkadia, as an equal opportunity employer, celebrates our employees’ unique differences, which we believe drives personal and company-wide innovation and creates a people-first culture where your career can take the long view. To achieve these goals, we are committed to the full inclusion of all qualified individuals, without regard to race, religion, age, color, national origin, gender, sexual orientation, gender identity or expression, marital status, domestic partner status, military and veteran status, disability, pregnancy, parental status, genetic information, political affiliation, or any other status protected by federal, state and local laws.

    In keeping with our commitment, Berkadia takes the necessary steps to provide a workplace free from harassment and discrimination, as well as access and reasonable accommodations for individuals with disabilities. If you require reasonable accommodation to take part in the interview process, please contact

    You have rights under Federal and State employment laws. No question in this Application is intended to elicit information in violation of any such law, nor will any information obtained in response to any question be used in violation of any such law. If you apply for this role, you are acknowledging and . Please click the following links for more information about :  , , .

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Data Warehouse Analyst?

    Sign up to receive alerts about other jobs on the Senior Data Warehouse Analyst career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $62,792 - $92,726
    Income Estimation: 
    $80,038 - $118,710
    Income Estimation: 
    $42,524 - $54,094
    Income Estimation: 
    $48,050 - $64,197
    Income Estimation: 
    $48,514 - $65,011
    Income Estimation: 
    $48,050 - $64,197
    Income Estimation: 
    $62,792 - $92,726
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Berkadia

    Berkadia
    Hired Organization Address Dallas, TX Intern
    Are you looking to spend your summer learning from seasoned professionals focused on developing future leaders? Berkadia...
    Berkadia
    Hired Organization Address St Louis, MO Intern
    Are you looking to spend your summer learning from seasoned professionals focused on developing future leaders? Berkadia...
    Berkadia
    Hired Organization Address Atlanta, GA Full Time
    Are you looking for the opportunity to make an impact? Berkadia’s mortgage banking platform is consistently ranked among...
    Berkadia
    Hired Organization Address Ambler, PA Full Time
    Company Description Berkadia, a joint venture of Berkshire Hathaway and Leucadia National Corporation, is an industry le...

    Not the job you're looking for? Here are some other Senior Data Warehouse Analyst jobs in the Ambler, PA area that may be a better fit.

    Junior Data Ops Data Analyst

    NTT DATA, King of Prussia, PA

    AI Assistant is available now!

    Feel free to start your new journey!