49 applicants

Company

Original Job Post

Lument · 2 days ago

Analyst, Quality Assurance

Dallas, TX

Full-time

Hybrid

Entry Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Commercial Real EstateFinance

Insider Connection @Lument

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Assist with the collection and reconciliation of data from operations and maintain servicing and asset management metrics and Key Performance Indicators (KPIs).

Develop and execute database queries and conduct data analysis.

Design, architect, implement, and support Microsoft Power BI & SSRS solutions and create visualizations and reports for requested projects.

Conduct unit testing and troubleshooting.

Work with stakeholders to understand data needs throughout LSAM to translate business needs to technical specifications.

Assist in data collection and reporting for rating agencies with respect to statistical reporting and annual reviews.

Assist in assessments of business units and functions, including vendors performing outsource functions, for accuracy and compliance.

Work with the Lender Technology team to assist in testing and act as a liaison within the business unit with respect to testing and prioritization of system enhancements and deficiencies.

Participate in special projects at the direction of the Associate Director.

Provide regular status updates to manager regarding any outstanding items or deadlines.

Develop and update technical documentation.

Work professionally and harmoniously with team and coworkers.

Travel Requirements – Provide %.

Other projects and duties as assigned.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Microsoft excelBi technologiesSql queriesSql server reporting servicesSql server integration servicesSensitive information handlingHigh-performance teamAdjusting prioritiesProblem-solvingFocusProactive attitudeAttention to detail work well under pressureMultitaskingHandling sensitive information communicationOrganizationInterpersonal skillsFlexibility learn quicklyWorking independentlyTeamwork

Required

An Associate or Bachelor's degree preferred in Accounting, Finance, Real Estate, Mathematics, Statistics, Data Analytics or Information Systems.

Advanced analytical and problem-solving skills.

Proficiency in Microsoft Excel required.

0-3 years’ experience with Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI, Tableau)

0-3 years’ experience of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)

Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

Position requires focus and attention to detail.

Proactive attitude and willingness to take initiative to seek out additional tasks and responsibilities.

Ability to work well under pressure, adjust to varied workloads, multitask, and handle sensitive/confidential information.

Excellent communication and organization skills

This position requires access to sensitive and confidential information. It is expected that this information remains confidential both internally and external to the company.

relevant systems or software

Excellent organizational, communication, presentation, and interpersonal skills

Ability to plan, organize, and prioritize assignments, and to meet critical and established deadlines; Ability to manage multiple assignments and transactions simultaneously

Demonstrated ability to maintain confidentiality and to use discretion in the performance of daily activities

Ability to learn quickly and demonstrated ability to work independently and as part of a high-performance team

Flexibility and ability to work under pressure with tight deadlines and constant interruptions; Ability to adjust priorities in a changing environment