Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Business Intelligence Analyst

Ross Mortgage Corporation

Business Intelligence Analyst

Troy, MI
Full Time
Paid
  • Responsibilities

    The Business Intelligence Analyst is responsible for creating data and reporting solutions to support company needs. The Business Intelligence Analyst is responsible for maintaining accurate data in the mortgage processing, accounting, and loan origination systems, creating reports on production, performance, profitability and ad-hoc reports as needed. Responsibilities: KEY RESPONSIBILITIES: • Maintain and create reports from the Loan Origination System (LOS) and related reporting tools. • Maintain and create reporting data from the accounting system and related reporting tools. • Continually be improving data visualization and analysis. GENERAL REQUIREMENTS: • Excellent designer of programming solutions. • Knowledge of commonly used terminology, concepts, practices, and procedures within the mortgage industry. • Friendly presence and helpful attitude; interpersonal skills and ability to work well with others. • Good verbal and written communication skills. • Problem-solving skills: ability to visualize a problem or situation and think abstractly to solve it. • Creativity and the ability to think around problems and come up with creative solutions is helpful. • Ability to work with or without direct supervision. Qualifications: • Expertise with relational database management, and specifically SQL to include SSMS. • Advanced skills in Microsoft Excel, Pivot Tables, VLOOKUP and Power Query. • Experience with Flow, PowerApps and Power BI. • Proficiency with the Office 365 Suite. • Experience with API programming. • At least one (1) year of experience with an analytical programming language. • Ability to work independently in a fast-paced environment, under minimal supervision, and have strong time management and organizational skills. • Ability to strive for excellence. • Ability to demonstrate a high degree of professional behavior including punctuality, attendance, responsiveness and dependability. Compensation: $55,000 - $80,000

    • Key Responsibilities: • Maintain and create reports from the Loan Origination System (LOS) and related reporting tools. • Maintain and create reporting data from the accounting system and related reporting tools. • Continually be improving data visualization and analysis.General Requirements: • Excellent designer of programming solutions. • Knowledge of commonly used terminology, concepts, practices, and procedures within the mortgage industry. • Friendly presence and helpful attitude; interpersonal skills and ability to work well with others. • Good verbal and written communication skills. • Problem-solving skills: ability to visualize a problem or situation and think abstractly to solve it. • Creativity and the ability to think around problems and come up with creative solutions is helpful. • Ability to work with or without direct supervision.

  • Industry
    Financial Services