Sr Business Systems Analyst - Reporting

Join a winning team of innovative thinkers, seasoned mortgage professionals, and financial experts. Build your career at Planet—recognized as a Top Mortgage Employer by National Mortgage Professional.

Job Summary

The Sr Business Systems Analyst - Reporting assists leadership with the analytic and reporting efforts of the company’s internal and external businesses including business systems analysis writing requirements, technical skills (using SQL/ PBI), and communication with business leadership and development team. Assists in efforts of establishing procedures and best practices around process flow and data governance, as well as technical documentation.

Essential Duties and Responsibilities

• Works closely with management, and end-users to create and validate business requirements, and process flows to support delivery of effective Power BI dashboards and SSRS reporting and Python data modeling solutions. Facilitates meetings and design sessions for new reports and dashboards. Leads initiatives on project proposals, including scope definition, objectives, deliverables, and alignment with organizational goals.
• May prepare data mapping documents, perform logical comparisons to identify the delta or analyze data to support the technical requirements for reports and dashboards using SQL Server. Performs read/write of queries to find data fields and/or anomalies within the SQL Server data warehouse to support technical requirements.
• Owns and maintains all workflow processes for team and respective business units. This includes analysis of processes, workflows, and maintaining team SLA’s.
• Takes point on implementation of SCRUM/Agile practices and procedures. This includes analyzing processes, identifying areas for improvement and provide recommendations to fill in gaps and improve business processes and workflow. Owns and maintains all meetings/rituals for workflow process.
• Leverages advanced knowledge/works independently and is responsible for conducting in depth analysis to identify trends, insights, and opportunities that inform strategic decisions-making through data insights. This includes collaboration with cross-functional teams to proactively identify business challenges and propose data driven solutions
• Performs miscellaneous duties as assigned.

Position Requirements

Education

• Bachelor’s degree in business, computer science, information systems or analytical techniques or equivalent related work experience required.
• High School diploma required

Experience

• Minimum five (5) years of experience working with Microsoft SQL Server and T-SQL.
• Minimum of five (5) years of experience with data warehouse development
• Minimum of three (3) year experience in data integration and validation.
• Minimum of two (2) years of experience in PowerBI
• Minimum of two (2) years of experience in a BSA roll
• Minimum of two (2) years of experience in Project Management

Functional/Technical Skills

• Knowledge of best practices when dealing with relational databases.
• Strong analytical, problem-solving and project management skills.
• Collaborate with team members to identify and prioritize/reprioritize work to meet aggressive deadlines.
• Strong leadership and mentoring abilities
• Proficient at writing ad-hoc SQL Queries and Stored procedures.
• Working knowledge of Microsoft SQL Server, SSRS, SSMS, Power BI and T-SQL.
• Prior experience working within a mortgage servicer or originator preferred.

Environmental/Physical Demands

Work is typically performed in a standard office environment. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to sustain predictable work attendance, communicate with others, frequently required to stand, walk, sit, and use arms, hands and fingers to reach, handle or touch. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus. Pursuant to the Americans with Disabilities Act, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This job description is not designed to cover or contain a comprehensive listing of all activities, duties or responsibilities that are required of an employee. The Company reserves the right to amend or modify this document at any time and without notice.

Benefits

Our benefits package includes 3 comprehensive Cigna or Kaiser medical plans, dental, and vision insurance. We provide short term and long-term disability insurance, basic life insurance, 401(k), and 11 employer paid holidays. In addition, we offer supplemental benefits to include life insurance, critical illness and accident plans.

Planet Home Lending does not accept unsolicited resumes or candidate submissions from recruiters or employment agencies. In the absence of an enforceable, fully executed agreement for a specified position, Planet Home Lending has no obligation to pay any compensation or recruiter fee of any kind. In the event a recruiter, agency or other similar third-party submits a resume or candidate without a valid binding agreement, Planet Home Lending explicitly reserves the right to pursue and hire those candidate(s) without any obligation or compensation to the referring party. Any unsolicited resumes, referrals, or candidate submissions, including those communicated to a member of the Human Resources team or a hiring manager, shall be deemed the property of Planet Home Lending. If you or your agency would like to be considered as a future recruiting partner, please email HR-Recruiting@planethomelending.com.