Sr Business Systems Analyst - Reporting

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.