Senior Data Warehouse Analyst
Apply NowCompany: Berkadia Commercial Mortgage LLC
Location: Ambler, PA 19002
Description:
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 U.S. 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:
We are passionate about your growth, so to achieve success in this role you should have:
We believe People Matter, so we offer benefits that go beyond:
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 talentacquisition@berkadia.com.
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 Berkadia's Application Policy and Berkadia's Privacy Policy. Please click the following links for more information about: EEOC, Employee Rights under the FMLA, EPPA.
Join Berkadia's loan servicing platform and learn from the best of the best at the largest U.S. 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 talentacquisition@berkadia.com.
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 Berkadia's Application Policy and Berkadia's Privacy Policy. Please click the following links for more information about: EEOC, Employee Rights under the FMLA, EPPA.