Remote BI & Reporting Lead - t-SQL/SSRS Expert

SitusAMC; Helena (MT); Remote; USD 100,000 - 140,000; Full time

Benefits offered by this job

PTO and paid holidays

Medical, dental, vision

401K

Job summary

SitusAMC is seeking a senior Reporting/BI Engineer to lead the building and ongoing delivery of our enterprise reporting platform. You will work with business leaders, vendors and client service managers to capture requirements and produce reports and visualizations.

The role requires 5+ years in reporting, strong t-SQL and SSRS skills, experience with SDLC and agile methodologies, and knowledge of CRE loan servicing.

Qualifications

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

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

Mentorship

Time management

Analytical thinking

Communication

Education

Bachelor's degree or equivalent

Tools

t-SQL

SSRS

Enterprise!

Job description

SitusAMC is seeking a senior Reporting/BI Engineer to lead the building and ongoing delivery of our enterprise reporting platform. You will work with business leaders, vendors and client service managers to capture requirements and produce reports and visualizations.

The role requires 5+ years in reporting, strong t-SQL and SSRS skills, experience with SDLC and agile methodologies, and knowledge of CRE loan servicing.