LakeForestRecruiter Since 2001
the smart solution for Lake Forest jobs

Reporting Analyst - SQL, SSRS, Power BI

Company: loanDepot
Location: Lake Forest
Posted on: August 5, 2022

Job Description:

loanDepot, America's lender, matches borrowers through technology and high-touch customer care with the credit they need to fuel their lives. We take the responsibility of being the second largest non-bank lender seriously. loanDepots long term commitment begins at origination continuing with long term support through our in house servicing teams. Our loanDepot servicing division puts our customers first, promotes teamwork & provides our employees with the fuel needed to succeed in their careers. Come join us!loanDepot We are Americas Lender.Position Summary:Responsible for developing customized reports by sourcing the data from various databases according to a specific requirement from the Business Analysts or directly from the business partners specific to our Heloc product. Maintains a strong understanding of relational database such as SQL, has experience with various reporting delivery platforms and has strong acumen to data integrity/accuracy. Creates and distributes business reports using reporting tools such as Microsoft SQL Server Reporting Services or other similar tools from the various servicing data sources. Ensures the performance of all duties in accordance with the companys policies and procedures, all U.S. state and federal laws and regulations, wherein the company operates.Responsibilities: Works collaboratively with Business Analysts or with business units to understand requirements, develop reports, perform user tests and deploy final reports to production environment. Researches data sources and resolves data load/data transformation from different data sources. Designs and develops automated reports; provides various ad-hoc reporting as needed. Tests and validates reports to resolve any performance issues. Creates and maintains documentation for reports or processes for the benefit of users inside and outside the department. Reviews error logs for various reporting processes, troubleshoots and resolves reporting issues. Communicates and provides regular updates on development status to the business units. Continuously looks for ways to optimize report processes, increase efficiency/productivity and minimize errors and failures. Monitors the reporting function for procedural changes to ensure that information presented and the criteria to build it are relevant and current. Develops standardized reports; works with reporting staff to deploy, schedule, and set-up report distribution in SSRS. Clarifies reporting requirements and report specifications with Business Analysts. Conducts peer reviews on coding for accuracy and improvements. Provides assistance and cross training to new team members; fill in as back up for other team members as needed.Requirements:Experience working with ELOC/HELOC loans is requiredExperience with Black Knight (BKFS) Suite of Mortgage Servicing Solutions and BKFS data extracts such as Bulk Data Extract (BDE) and/or eCDErequiredAdvanced knowledge of report design, development and deployment. Ability to mine large amounts of data utilizing SQL to present in a user-friendly format Minimum of five (5) + years experience working with Microsoft SQL, SSRS, and/or various reporting tools such as Tableau, Power BI, etc. Experience in working with relational database, including normalization, stored procedures, constraints, query, joins, keys, indexes, views, dynamic SQL, triggers and cursors. Expertise in writing and tuning SQL queries; understand relational database schemas.Preferred experience: Experience with LPS Empower Loan Origination Software Experience with various reporting platforms (e.g. SSRS, Tableau or similar platforms) Bachelors DegreeWhy work for #teamloanDepot: Aggressive earning potential and 401K with robust company match Inclusive, diverse and collaborative culture where people from all backgrounds can thrive Work with other passionate, purposeful and customer-centric people Extensive internal growth and professional development opportunities including tuition reimbursement Comprehensive benefits package including Medical/Dental/Vision Wellness program to support both mental and physical health Generous paid time off for both exempt and non-exempt positionsWe are an equal opportunity employer and value diversity in our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.PM17#LI-JLPI187841050

Keywords: loanDepot, Lake Forest , Reporting Analyst - SQL, SSRS, Power BI, IT / Software / Systems , Lake Forest, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Lake Forest RSS job feeds