What are the responsibilities and job description for the Senior Data Warehouse Analyst position at Berkadia Services India Private Limited?
Back to jobs
New
Senior Data Warehouse Analyst
Ambler, Pennsylvania, United States
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.
This position involves high visibility with internal and external clients through report creation and delivery. The candidate will serve as a report expert utilizing IBM Cognos Power BI, and other applications to support internal servicing and corporate teams with both routine and complex reporting needs.
We are committed to growing your career, so in this role you will:
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.
Apply for this job
indicates a required field
First Name*
Last Name*
Email*
Phone*
Location (City)*
Resume/CV*
Attach
Enter manually
Accepted file types: pdf, doc, docx, txt, rtf
Do you have a preferred name or nick name?
Street Address *
Apartment # or Unit
City*
State
Select...
Zipcode*
Desired Salary Range
Select...
Are you at least 18 years of age?*
Select...
Have you, in the past, been employed by Berkadia or any other Berkadia entity? *
Select...
Have you signed any agreement with any prior or existing employer which includes any restrictions on your ability to compete and non-solicit; to contact customers, clients or employees; or to use and/or disclose business, client or customer information? if you answered "Yes," please provide "Berkadia" with a copy of the agreement so that "Berkadia" can consider whether and to what extent the agreement may preclude and/or restrict your employment with us, if an offer is extended.*
Select...
Will you now, or in the future, require sponsorship to work in the United States?*
Select...
Are you a current Berkadia employee? *
Select...
If you were referred to this position by a current Berkadia employee please type their name below.
How did you hear about this job? *
Select...
Voluntary Self-ID Questions
Completion of this form is voluntary and if you don’t wish to answer any question, please check the “I don't wish to answer” response after any such question. Please note that your responses to these questions will not affect your opportunity for employment or any of the terms or conditions of your employment. We are asking these questions for informational and reporting purposes only. This form will be kept separate from all other application records, and while we may include your responses, together with responses from others, in an aggregated and/or anonymized format, your specific responses will only be accessed by those working for the Human Resources Department at Berkadia. Moreover, none of the information, as disclosed below, will be used for any purpose throughout the application, interview or hiring processes.
How do you describe yourself?*
Select...
How would you describe your racial/ethnic background?*
Select...
Are you a veteran or active member of the United States Armed Forces?*
Select...
Do you have a disability – a physical or mental impairment or medical condition that substantially limits a major life activity? A disability includes if you have, have a record of, or are regarded as having a substantial, unlike minor, impairment.*
Select...
By checking this box, I consent to Berkadia collecting, storing, and processing my responses to the demographic data surveys above.*
New
Senior Data Warehouse Analyst
Ambler, Pennsylvania, United States
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.
This position involves high visibility with internal and external clients through report creation and delivery. The candidate will serve as a report expert utilizing IBM Cognos Power BI, and other applications to support internal servicing and corporate teams with both routine and complex reporting needs.
We are committed to growing your career, so in this role you will:
- Provide analytical and reporting support and solutions to the Loan Servicing department.
- Design, implement, and maintain relational database systems ensuring efficient data-joins to support multi-source data integration.
- Utilize tools like BI, SQL, Advanced Excel, and Python to meet operational needs.
- Develop and automate advanced analytics, Power BI dashboards, and reporting solutions.
- Create and manage complex Cognos dashboards and data models.
- Troubleshoot and resolve report, database and scheduling issues.
- Develop and optimize advanced SQL Server queries.
- Experience with ETL processes, data warehousing and multi-source data consolidation.
- Manage scheduled reports for external and internal recipients.
- Ensure company branding (Berkadia and Private Label) on reports and letters.
- Create and distribute recurring monthly Senior Management and Rating Agency reports.
- Perform other duties and project as assigned.
- Professional report development skills, including creating various report types.
- Experience in report schedule management and data modeling a plus.
- Strong understanding of relational databases and SQL, particularly with Microsoft SQL Server and SQL Server Management Studio.
- Excellent communication and time management skills.
- Knowledge of Loan Servicing/Financial data and systems a plus, especially McCracken’s Strategy Commercial Loan Servicing system.
- Ability to work independently with minimal supervision.
- Proficiency in Microsoft products, advanced SQL queries and joins (inner/outer, cross/Cartesian), Python, Advanced Excel, Power BI, Cognos Analytics, dashboard development, and reporting framework.
- Experience with JavaScript, TypeScript, and integrating machine learning models is beneficial, along with building data solutions using React, Python, and SQL.
- Strong user testing and quality assurance skills.
- Ability to collaborate with business users and the IT department.
- Bachelor’s degree or equivalent
- Three to five years prior experience in a similar position.
- 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!
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.
Apply for this job
indicates a required field
First Name*
Last Name*
Email*
Phone*
Location (City)*
Resume/CV*
Attach
Enter manually
Accepted file types: pdf, doc, docx, txt, rtf
Do you have a preferred name or nick name?
Street Address *
Apartment # or Unit
City*
State
Select...
Zipcode*
Desired Salary Range
Select...
Are you at least 18 years of age?*
Select...
Have you, in the past, been employed by Berkadia or any other Berkadia entity? *
Select...
Have you signed any agreement with any prior or existing employer which includes any restrictions on your ability to compete and non-solicit; to contact customers, clients or employees; or to use and/or disclose business, client or customer information? if you answered "Yes," please provide "Berkadia" with a copy of the agreement so that "Berkadia" can consider whether and to what extent the agreement may preclude and/or restrict your employment with us, if an offer is extended.*
Select...
Will you now, or in the future, require sponsorship to work in the United States?*
Select...
Are you a current Berkadia employee? *
Select...
If you were referred to this position by a current Berkadia employee please type their name below.
How did you hear about this job? *
Select...
Voluntary Self-ID Questions
Completion of this form is voluntary and if you don’t wish to answer any question, please check the “I don't wish to answer” response after any such question. Please note that your responses to these questions will not affect your opportunity for employment or any of the terms or conditions of your employment. We are asking these questions for informational and reporting purposes only. This form will be kept separate from all other application records, and while we may include your responses, together with responses from others, in an aggregated and/or anonymized format, your specific responses will only be accessed by those working for the Human Resources Department at Berkadia. Moreover, none of the information, as disclosed below, will be used for any purpose throughout the application, interview or hiring processes.
How do you describe yourself?*
Select...
How would you describe your racial/ethnic background?*
Select...
Are you a veteran or active member of the United States Armed Forces?*
Select...
Do you have a disability – a physical or mental impairment or medical condition that substantially limits a major life activity? A disability includes if you have, have a record of, or are regarded as having a substantial, unlike minor, impairment.*
Select...
By checking this box, I consent to Berkadia collecting, storing, and processing my responses to the demographic data surveys above.*
