Data & Reporting Sr Associate - CRE Servicing - Remote US

SitusAMC; Carson City (NV); Remote; USD 100,000 - 140,000; Full time

Benefits offered by this job

Discretionary bonus

Paid time off

401K plan

Medical/dental/vision coverage

Job summary

SitusAMC is seeking a senior-level reporting and BI professional to lead the ongoing delivery of enterprise reporting. You will design and implement data extracts, complex t-SQL, and SSRS-based reports, collaborating with business and IT stakeholders to provide actionable insights.

Mentorship of junior staff and adherence to SDLC are key components of the role. The role supports a global BI strategy, with an emphasis on accuracy, timely delivery, and data accessibility across the organization

Qualifications

• College degree or equivalent combination of education and experience.
• 5+ years in reporting, analytics, or related field; 1+ year in a mentorship role.
• Expertise building t-SQL statements and SSRS reports is required.
• Experience with agile methodologies and SDLC.
• Knowledge of CRE loan servicing and Enterprise! (PNC/Midland CRE Servicing) is a plus.
• Strong written and oral communication, time management, and analytical skills.

Responsibilities

• Partner with business and technology teams to expand the reporting platform.
• Follow the software development lifecycle for the reporting platform.
• Create complex t-SQL statements, stored procedures, and data queries.
• Build reports, data extracts, and visualizations.
• Mentor and review junior staff work to ensure quality.
• Contribute to various other duties as assigned by management.

Skills

t-SQL

SSRS

Mentorship

Data visualization

Analytical thinking

Time management

Communication

Education

Bachelor’s degree or equivalent

Tools

SQL Server

Job description

SitusAMC is where the best and most passionate people come to transform our client’s businesses and their own careers. Whether you’re a real estate veteran, a passionate technologist, or looking to get your start, join us as we work together to realize opportunities for everyone, we proudly serve.

At SitusAMC, we are looking to match your unique experience with one of our amazing careers, so that we can help you realize your potential and career growth within the Real Estate Industry. If you are someone who can be yourself, advocate for others, stay nimble, dream big, own every outcome, and think global but act local – come join our team!

This role is responsible for the building and ongoing delivery of SitusAMC’s enterprise reporting strategy. The position builds the processes involved in reporting and may mentor staff. They build the technology to disperse critical information and insights to the organization and clients. Working closely with business leaders, vendors and client service managers, the position captures business requirements, creates and administers reports, and reviews others ensure a quality product. This role will have robust and demonstratable experience expanding and building a global Information Technology-based reporting and business intelligence platform, preferably in commercial real estate industry. This role may build and mentor other report developers to extract critical information from operational systems and data lakes, expanding the availability of data and information throughout the organization. They will partner closely with other Data, Reporting, and Analytics teams to insure the efficient, accurate and relevant presentation of information.

Essential Job Functions:

• Partner with business and technology team members to expand the reporting platform.

• Follow the software development lifecycle of the reporting platform.

• Create complex t-SQL statements and stored procedures and queries to extract data.

• Build reports, data extracts, and visualizations.

• Mentor, review, improve and ensure junior staff quality of work.

• Prompt and regular attendance is required.

• Other activities as may be assigned by your manager.

Qualifications/ Requirements:

• College degree or equivalent combination of education and experience.

• Experienced professional with 5+ years of industry and/or relevant experience, typically with 1+ years in an Associate level role or external equivalent.

• 5+ years of reporting experience preferred, with 1+ years in mentorship role.

• Expertise building t-SQL statement is required.

• Expertise in SSRS is required.

• 2+ years commercial real estate required.

• Experience with agile methodologies and SDLC.

• Experience with CRE loan servicing and Enterprise! (PNC/Midland CRE Servicing)

• Strong time management and communication skills (written and oral).

• Strong analytical ability, good judgment; strategic and multidimensional thinker.

• Detail oriented, organized; prompt and regular attendance is required.

• Continuous learner; excitement in personal growth and development.

• Strong commitment and dedication to the position and a team player.

#LI-Remote #LI-AS1

Note: This job description is not intended to be all inclusive or exclusive. At any time, employees may perform other related duties as required to meet the ongoing needs of the organization and participate in additional trainings. SitusAMC does not accept unsolicited resumes from staffing agencies, search firms or any third parties. Any unsolicited resume submitted to SitusAMC in any manner will be considered SitusAMC property, and SitusAMC will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

The annual full time base salary range for this role is

$100,000.00 - $140,000.00

Specific compensation is determined through interviews and a review of relevant education, experience, training, skills, geographic location and alignment with market data. Additionally, certain positions may be eligible to receive a discretionary bonus as determined by bonus program guidelines, position eligibility and SitusAMC Senior Management approval. SitusAMC offers PTO and paid holidays, the terms of which are set forth in the program policies. All full time employees also are eligible to participate in various benefit plans, including medical, dental, vision, life, disability insurance and 401K; in each case in accordance with the terms of the applicable plans.

Pay Transparency Nondiscrimination Provision (https://go.situsamc.com/rs/962-QMP-613/images/pay-transp_%20English_formattedESQA508c.pdf?version=0)

SitusAMC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Know Your Rights, Workplace Discrimination is Illegal (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)