Primary Responsibilities

• Pull, validate, and analyze data for ad-hoc business requests and strategic initiatives.
• Translate business requirements into SQL queries, reports, and analytical outputs.
• Develop, maintain, and troubleshoot SQL queries, stored procedures, views, and functions.
• Identify relationships between tables and data sources within complex database environments.
• Investigate data discrepancies, perform root-cause analysis, and recommend solutions.
• Work directly with business stakeholders to clarify requirements and communicate findings.
• Support reporting, dashboard development, and ongoing analytics initiatives.
• Document business logic, data definitions, and analytical processes.

Required Qualifications

• 5+ years of SQL development and data analytics experience.
• Advanced SQL skills, including complex joins, CTEs, temporary tables, subqueries, window functions, stored procedures, and query optimization.
• Strong understanding of relational databases, data modeling, and table relationships.
• Experience working with large, complex databases and limited documentation.
• Ability to independently determine data requirements and develop solutions to answer business questions.
• Strong analytical, problem-solving, and communication skills.
• Demonstrated ability to learn new business processes and data structures quickly.

Preferred Qualifications

• Power BI
• SSRS
• Data Warehousing
• Azure SQL / Azure Data Factory
• Python

Success Factors

The successful candidate can receive a business question with limited direction, identify the appropriate data sources, determine table relationships, leverage existing database objects when appropriate, develop SQL solutions, validate results, and communicate findings without requiring detailed technical guidance.

About Resident Interface

Resident Interface is the industry leader in delinquency management for the rental housing market. Through our brands Possession Partner (Evictions), Resident Advocate (Pre-Collections), and Hunter Warfield (Collections) we deliver a unified platform that helps property owners and managers recover revenue, stay compliant, and protect their communities.

With over 40 years of experience, $billions recovered nationwide, and operations across all 50 states, Resident Interface combines technology, transparency, and expertise to transform the way property owners manage delinquencies from the first missed payment to final resolution.

Learn more at www.residentinterface.com