Reporting Analyst I

Vanderbilt Mortgage•Maryville, TN

21h•Hybrid

About The Position

At Vanderbilt Mortgage, we believe homeownership makes lives better. For over 50 years, we’ve been committed to making homeownership more attainable for families across the country by providing mortgage solutions that unlock the freedom of home. As a national housing lender, we specialize in financing new and pre-owned manufactured and modular homes. With a diverse range of loan products, a reputation for world-class customer service and a coast-to-coast presence, Vanderbilt continues to be a leader in the industry. Our strength is our people—which is why we prioritize investing in our Team Members through opportunities for growth, a healthy work-life balance, and meaningful recognition of their contributions. Whether just starting out or bringing years of experience, Vanderbilt empowers our Team Members with the tools and training to build a successful career and reach their full potential. POSITION TITLE: Reporting Analyst I ( Non – LO – No Consumer Contact) JOB STATUS: Full Time/Salary DEPARTMENT: Business Analytics REPORTS TO: Reporting Analyst Lead TRAVEL REQUIRED: None WORK SCHEDULE: Hybrid - 2 days in-office, 3 days remote after training. PAY: The expected hiring range for this position is from $66,495 to $83,115 plus additional bonus opportunity. The stated hiring range is based on experience, qualifications, and other relevant factors. Final compensation decisions will take into account a variety of considerations, including individual skills, internal equity, and organizational needs. JOB SUMMARY: The Reporting Analyst I develops various reporting and analytic solutions that present information for decision-making opportunities . This role reports to the Business Analytics Manager and utilizes data from a variety of sources to provide an excellent customer experience by ensuring accurate and timely reports.

Requirements

Education: Bachelor’s degree or equivalent experience required, preferably in Business Analytics, Finance, Accounting, Statistics, or related field.
Experience: 0-2 years of related experience
Must have working knowledge of all Microsoft Office applications, and basic visual design principles.
Strong Excel knowledge required including financial formulas and pivot tables.
Ability to understand query definitions and relational database structure.
Possess analytical skills as well as abstract reasoning, strong math, and experience with Tableau, SSRS, or SSMS is a plus.
Proficient understanding of business fundamental including accounting and finance
Ability to communicate effectively and efficiently via phone, email, and person to person.
Must be able to multi-task, work independently and manage time effectively.
Great attention to detail and organizational skills.
Ability to work in a team environment.
Must be able to remain in a stationary position 75% of the time.
Will be constantly operating a computer and other office productivity machinery, such as a telephone, calculator, copy machine, and computer printer.
Will be communicating via phone, Teams, and Zoom.
Must be able to exchange accurate information at all times.
Must be able to identify and assess account status and determine appropriate process.
Will constantly work in a state-of-the-art indoor temperature controlled, sealed window office environment.

Nice To Haves

Possess analytical skills as well as abstract reasoning, strong math, and experience with Tableau, SSRS, or SSMS is a plus.

Responsibilities

Reporting and Dashboard Solutions Creates and produces visually appealing forecasts, reports, and ad hoc requests adjusting style, logic and data as needed.
Meets with internal customers to develop project scope for analytic and research requests; works with the team to support, prioritize and plan projects.
Works with various stakeholders to develop dashboards by leveraging centrally managed reporting tools, such as Tableau and Structured Query Language (SQL) Server Reporting Services.
Collects, aggregates, and analyzes data from multiple internal and external sources to drive insights into business performance.
Produces actionable reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems.
Ensures compliance with deliverable reporting requirements by performing quality data audits and analysis.
Consults with end users on self-service analytics including direct line support and training while providing a solid understanding of business needs.
Monitors latest trends in User Experience / User Interface (UX/UI) and developments in the economy to enhance analysis.
Production Support and Maintenance of existing reports, dashboards, and other solutions Assists with project requests for ad hoc reporting, queries, and self-service guidance.
Troubleshoots any issues that surface and works with appropriate teams to implement solutions.
Gathers and queries data for leadership.
Research Data Structure Explores data needed for automated reports and dashboards to determine which fields are needed in the enterprise data warehouse.
Works with Data Engineers to get data normalized and ready for reporting.
Researches and analyzes data structure to understand how data comes together to produce needed data points.
Other duties as assigned

Benefits

Medical and Dental Plan with Prescription Coverage and Vision.
Competitive benefits including 401(K) includes 100% company match of the first 4%.
Paid time off days (PTO), maternity/paternity leave, and holidays.
Community involvement including Volunteer Paid Time Off (VTO).
Tuition Assistance for your first degree
Enjoy coming “home” to our brand new, state-of-the-art Home Office equipped with onsite fitness facility with full gym, workout classes, volleyball and basketball courts, ping-pong, disc golf course, and onsite restaurant.
Wellness programs that focus on emotional, social, spiritual, intellectual, environmental, physical, and financial well-being.
Collaborative and energetic work environment.
Professional development and promotional opportunities.
Competitive bonus programs.