Senior Real Estate Analyst at Berkadia leading analytical projects in Commercial Real Estate finance. Supporting Mortgage Banking and Investment Sales teams to meet customer needs.
About the role
- Senior Systems Analyst (Oracle Forms and Reports) assisting with design and implementation of IT solutions. Collaborating with teams to ensure project success and effective communication.
Responsibilities
- Work collaboratively with multiple teams across the organization.
- Communicate effectively with your team, team manager and business customers.
- Contribute and be accountable to your development activities and workload management.
- Produce and maintain program code (mostly PL/SQL), Oracle Forms/Reports and documentation.
- Understand, design, build and test change requests as per demands of the projects and releases.
- Troubleshoot and resolve issues.
- Assess the root cause of issues and recommend changes.
- Perform unit and integration testing with both IT and business customers as required.
- Provide support during various phases of testing.
- Prepare documentation and instructions for the execution of application programs.
- Reviews requirements with the users and provides time estimates for task completion.
- Work as part of a project team as required.
- Follow IT Controls practices (e.g., IT Governance, Data Privacy) to ensure quality output.
- Follow Systems Development Life Cycle best practices.
- Continual learning and understanding of the application environment, interdependencies, and integrations with other systems.
- Could include data management activities such as designing and building data interfaces and extracts, forms, and reports, and designing logical and physical data models.
- As Senior SA, provide expertise with respect code quality, security, deployment and code management.
- Display certainty in one’s ability to make decisions and perform difficult job tasks and self-assurance in all work relationships.
- Participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews.
Requirements
- A bachelor’s degree or diploma in Computer Science or related technical discipline.
- Ten or more years of progressive experience developing and designing implementations with small to large scale applications with proficiency in Oracle Forms (10g/12c), Oracle Reports, PL/SQL, and SQL.
- Extensive experience creating Oracle applications using Oracle forms and Reports.
- Established Proven ability to work using tools like SQL Developer, TOAD, GitLab.
- Experience with Delivery management tools like ALM, Service Now and Jira is highly preferred.
- Exceptional consultation skills are critical, with the ability to convey technical ideas to both technical and non-technical audiences.
- Demonstrated technical leadership on projects/large initiatives in a highly complex and integrated application architecture would be highly beneficial.
- Completion of Oracle PL/SQL Developer Certified Associate would be considered an asset.
- Experience with services and integration of Mid-Tier applications with Oracle databases.
- Demonstrated skills in performance Tuning and optimizing Forms Performance, SQL, PL/SQL code to reduce execution time or improve efficiency.
- Relevant experience in Implementation, Development projects related to Oracle PL/SQL based Enterprise Applications.
- Strong knowledge in complex queries and sub queries is a must.
- Strong experience with Oracle functions, procedures, triggers, packages & performance tuning.
- Knowledge in UNIX & Shell Scripting.
- Familiarity with RESTful web services and API integration.
- Good understanding of Agile development methodology would be an asset.
- Experience with developing Oracle Reports and tuning reports would be highly beneficial.
- Experience following a full lifecycle SDLC process, including creating technical designs, build and unit testing for sophisticated requirements.
- Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.
Benefits
- diversity and inclusion initiatives
- opportunities for career growth
- health coverage
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Business Strategy Analyst in Sensor Tower's Innovation & Strategy team managing client engagements. Focused on delivering high - impact data solutions and consulting projects for strategic clients.
Commissions Inquiry Analyst resolving challenging commission inquiries at Avant. Collaborating with teams to ensure accuracy and clarity in commission processes while maintaining positive relationships.
Payment Variance Analyst ensuring integrity of reimbursement for medical services at Tufts Medicine. Identifying, analyzing payment variances, recovering underpayments, and collaborating with hospital departments.
Associate Data Recon Analyst at LPL Financial supporting mutual fund and alternative investment data. Responsible for data accuracy, customer support, and collaboration with cross - functional teams.
Senior Analyst managing Workday HCM configurations and supporting HR - related business processes. Ensuring data integrity, optimizing performance, and mentoring team members in Workday best practices.
Behavior Analyst at Bierman Autism Centers overseeing client programming and ensuring clinical quality. Focus on research and collaborative learning while working with children.
Systems Design Analyst at Ford delivering vehicle software update solutions. Collaborating with diverse teams on end - to - end software delivery mechanics for OTA and dealership environments.
Resource Planning Analyst focusing on sustainable forest management strategies. Collaborate for timberland operations optimizing planning, analysis, and financial insights.
Planning and Logistics Analyst analyzing data to ensure timely product availability and cost efficiency. Managing logistics processes and inventory to support operational success across teams.