Senior Data & Reporting Architect - Remote

SitusAMC; Concord (NH); Remote; USD 100,000 - 140,000; Full time

Job summary

SitusAMC is seeking a skilled Senior BI Developer to lead the building and delivery of our enterprise reporting strategy. You will design and administer reports, work with data lakes, and mentor junior staff to ensure high-quality output across a global BI platform.

Responsibilities include expanding the platform with business partners, creating complex t-SQL and SSRS reports, and ensuring timely delivery while adhering to SDLC.

Qualifications

• College degree or equivalent combination of education and experience.
• 5+ years of reporting experience; 1+ years in Associate level or external equivalent.
• 5+ years of reporting experience preferred, with 1+ years in mentorship.
• Expertise building t-SQL statements is required.
• Expertise in SSRS is required.
• 2+ years commercial real estate experience required.
• Experience with agile methodologies and SDLC.
• Experience with CRE loan servicing and Enterprise! (PNC/Midland CRE Servicing).
• Strong time management and communication skills.
• Detail oriented; prompt and regular attendance.
• Continuous learner; excitement in personal growth and development.
• Strong commitment and dedication to the position and a team player.

Responsibilities

• 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.

Skills

5+ years reporting experience

Mentorship experience

Time management

Analytical ability

Detail oriented

Strong communication

Education

College degree or equivalent

Tools

t-SQL

SSRS

Enterprise! CRE Servicing

Job description

SitusAMC is seeking a skilled Senior BI Developer to lead the building and delivery of our enterprise reporting strategy. You will design and administer reports, work with data lakes, and mentor junior staff to ensure high-quality output across a global BI platform.

Responsibilities include expanding the platform with business partners, creating complex t-SQL and SSRS reports, and ensuring timely delivery while adhering to SDLC.