Job Closed
This listing is no longer active.
The connected foundation for your go-to-market engine.
Sales Operations Reporting Analyst
Location
California
Posted
110 days ago
Salary
$65.1K - $74K / year
Seniority
Mid Level
Job Description
Sales Operations Reporting Analyst
Default
• Support the Sales and Sales Operations Departments with reporting and business insight for use across all sales channels. • Develop, test, and implement standardized reporting utilizing Tableau, CRM Dynamics, Business Intelligence (BI), and Excel. • Troubleshoot dashboards/reports, verify overall data quality, and apply adjustments to close reporting gaps. • Calculate sales accruals and commissions on a monthly basis, update and provide statements to sales associates, and ensure payouts are timely and accurate. • Troubleshoot sales associates' issues with commission calculations, ensure solution and communicate directly with the manager and sales representative. • Enable new insights for the field to action, while partnering with the BI and Finance teams to drive growth initiatives.
Job Requirements
- Bachelor's degree preferably in Business Administration, Finance, Accounting, Statistics, or Information Systems preferred.
- 2-3 years' experience utilizing Tableau building robust dashboards and reports including but not limited to calculated fields, data visualizations (maps/graphs), conditional formatting, advanced filtering, etc.
- Advanced proficiency in Excel with 3+ years' experience working with large data sets utilizing pivot tables, v lookups, If statements, complex formulas, etc.
- Experience with SAP ERP and CRM preferred
- 2-3 years' experience reporting and analyzing data to drive key business insights
Benefits
- medical/dental/vision benefits
- 401K match
- annual performance bonus
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Analyst Jobs
Public Trust Eligibility Required About Aretum Aretum is a mission-driven organization committed to delivering innovative, technology-enabled solutions to our customers across defense, civilian, and homeland security sectors. Our teams work at the intersection of strategy, technology, and transformation, helping agencies solve their most critical challenges. We believe in investing in our people and creating a culture where collaboration, inclusion, and professional growth are at the forefront. Job Summary Aretum is seeking a detail-oriented and motivated Sr. FOIA Analyst to join our team. As a Sr. FOIA Analyst at Aretum, you will play a crucial role in supporting the Freedom of Information Act (FOIA) program and ensuring compliance with FOIA regulations and guidelines. Due to the nature of our work as a federal consulting organization, employees may be expected to handle Controlled Unclassified Information (CUI) and must adhere to applicable safeguarding and compliance requirements. Responsibilities - Review and analyze FOIA requests to determine if they meet the requirements for processing - Conduct research and gather information from various sources to support FOIA requests - Prepare written responses to FOIA requests, ensuring accuracy and compliance with FOIA regulations - Coordinate with internal teams and subject matter experts to gather and review responsive documents - Track and monitor FOIA requests, ensuring timely responses and adherence to established deadlines - Provide guidance and training to staff regarding FOIA regulations, policies, and procedures - Stay updated on changes in FOIA regulations and guidelines, and recommend process improvements to enhance efficiency and effectiveness of the FOIA program - Manage and maintain FOIA tracking systems and databases
Investor Reporting Analyst II – Private Investors
LoanCareLoanCare is a leading national provider of full-service subservicing and interim subservicing to the mortgage industry and has offered its expertise and best practices in providing servicing solutions for others since 1991. At the present time, LoanCare subservices over 1.8 million loans in 50 states. LoanCare has a seasoned loan servicing team with senior managers averaging nearly 30 years of experience in the mortgage and financial services industry.
• Complete mortgage accounting activity reports for moderately complex agency, guarantor, investor, trustee, and client portfolios. • Utilize basic understanding and knowledge of SQL coding to analyze servicing, reporting, remittance, and reconciliation data. • Remit payments according to agency, guarantor, investor, trustee, and client guidelines. • Calculate and initiate moderately complex wire transfer amounts with limited assistance from management. Determine appropriate funding source with limited assistance. • Reconcile LoanCare mortgage accounting records against agency, guarantor, investor, trustee, and client records. Perform more complex pool to security reconciliations for MBS remittance type investors with limited assistance from management; initiate required cash adjustments. • Independently research and resolve outstanding custodial, clearing and portfolio reconciling items as well as cashbook deviations within the specified timelines. • Forecast principal and interest advances using specified pooling and servicing agreement. Proactively manage custodial account balances to prevent overdrafts. Respond to inquiries regarding advance components and resolve discrepancies with assistance from management as needed. • Complete assigned individual and MSP tasks timely and accurately with limited assistance from management. • Independently coordinate with operational business units, clients and investors to resolve basic and complex reporting and remittance discrepancies. Respond independently to investors, clients, and internal business partner inquiries regarding assigned portfolio with limited assistance. • Independently upload basic and more complex MSP transactions as required; input transactions manually as needed. Enter/update pool header records utilizing existing templates for upload of the associated transaction code to MSP; initiate automated loan transfers; refer any output errors to management for resolution. • Identify required procedure updates and refer to management for action. Participate in process improvements within Investor Reporting and participate in enhancement testing. • Assist in training and provide assistance to junior analysts. • Develop and maintain knowledge of subservicing activity as it pertains to subservicing agreements. • Respond to more complex Dynamics ticket requests with limited assistance from management. • All other duties as assigned.
Investor Reporting Analyst II – GNMA
LoanCareLoanCare is a leading national provider of full-service subservicing and interim subservicing to the mortgage industry and has offered its expertise and best practices in providing servicing solutions for others since 1991. At the present time, LoanCare subservices over 1.8 million loans in 50 states. LoanCare has a seasoned loan servicing team with senior managers averaging nearly 30 years of experience in the mortgage and financial services industry.
• Complete mortgage accounting activity reports for moderately complex agency, guarantor, investor, trustee, and client portfolios. • Utilize basic understanding and knowledge of SQL coding to analyze servicing, reporting, remittance, and reconciliation data. • Remit payments according to agency, guarantor, investor, trustee, and client guidelines. • Calculate and initiate moderately complex wire transfer amounts with limited assistance from management. Determine appropriate funding source with limited assistance. • Reconcile LoanCare mortgage accounting records against agency, guarantor, investor, trustee, and client records. Perform more complex pool to security reconciliations for MBS remittance type investors with limited assistance from management; initiate required cash adjustments. • Independently research and resolve outstanding custodial, clearing and portfolio reconciling items as well as cashbook deviations within the specified timelines. • Forecast principal and interest advances using specified pooling and servicing agreement. Proactively manage custodial account balances to prevent overdrafts. Respond to inquiries regarding advance components and resolve discrepancies with assistance from management as needed. • Complete assigned individual and MSP tasks timely and accurately with limited assistance from management. • Independently coordinate with operational business units, clients and investors to resolve basic and complex reporting and remittance discrepancies. Respond independently to investors, clients, and internal business partner inquiries regarding assigned portfolio with limited assistance. • Independently upload basic and more complex MSP transactions as required; input transactions manually as needed. Enter/update pool header records utilizing existing templates for upload of the associated transaction code to MSP; initiate automated loan transfers; refer any output errors to management for resolution. • Identify required procedure updates and refer to management for action. Participate in process improvements within Investor Reporting and participate in enhancement testing. • Assist in training and provide assistance to junior analysts. • Develop and maintain knowledge of subservicing activity as it pertains to subservicing agreements • Respond to more complex Dynamics ticket requests with limited assistance from management • All other duties as assigned.
Role Description The Part-time Faculty member is a faculty position with non-exempt status in the School of Business. This non-tenure track part-time faculty position is expected to provide academic instruction to degree, certificate, and non-degree learners. The primary responsibility of this role is teaching, with a focus on delivering high-quality, engaging learning experiences within the faculty member's area of expertise and specialization. This position may be performed remotely. Remote employees are expected to be available during scheduled course hours and to maintain reasonable availability for student communication. The University will not supply equipment for part-time faculty; employees are responsible for having the necessary technology and a workspace suitable for participating in virtual meetings and facilitating online instruction without significant interruption. To teach at Excelsior is to embrace teaching excellence and deliver outstanding instruction to our non-traditional students. Faculty empower students in gaining knowledge and skills needed to become highly effective leaders in their professions. Faculty embrace diverse ideas, promote critical thinking and solution-finding, and help students challenge their own thinking and form connections between research and practice. They are deeply engaged in teaching and guiding students. Excelsior’s faculty create a vibrant online learning community through meaningful presence in courses. Our faculty demonstrate commitment to student success by supporting university engagement and retention initiatives, supporting struggling students, and collaborating with their faculty program director and the support staff to ensure students have access to all available services and supports. All public administration instructors must be committed to Excelsior’s mission and CARES Credo and be familiar with university support services. Excelsior University values students, instructors, employees, and all members of its world-wide community, and actively develops practices and policies that promote diversity and inclusion in the workplace. Diversity involves recognizing and respecting the richness of ethnic and cultural traditions, and the value of different perspectives related to gender, age, disability, sexual orientation, religion, family status, employee tenure, and more. Inclusion is about leveraging these differences and maximizing individual contributions in a way that enhances organizational effectiveness. At Excelsior, each staff and faculty member contribute to the student experience. Even those of us who may not interact with students are vitally important to creating a positive and successful outcome. The guiding principles, collectively known as Excelsior CARES, shape the environment in which we work and set the standard to which we hold ourselves. Each Excelsior employee is Compassionate, Agile, Respectful, and committed to Excellence and Service. Essential Duties and Responsibilities - Teach courses as assigned and advance student learning through dedicated, exemplary instruction in accordance with established course outlines, University standards, and external benchmarks of quality. - Deliver instruction consistent with the approved course design, syllabus, and learning outcomes established for each course. - Maintain consistent, timely, and professional communication with students throughout the term, including feedback on assessments and responsiveness to student inquiries. - Participate in course-level data collection and reporting as required, including the assessment of student learning outcomes. - Adhere to all policies specified in the Faculty Handbook, Faculty Playbook, and Teaching Checklist. - Collaborate with the Department Chair and instructional support staff as needed to ensure course quality and student success. - Other duties may be assigned. Qualifications - Graduate degree in the relevant discipline or a closely related field required; doctoral degree preferred. - Candidates with a master's degree and significant, documented industry experience and/or relevant professional certifications will be considered. - Experience teaching at the undergraduate and/or graduate level preferred, with comfort across multiple instructional modalities (online, hybrid, in-person). - Demonstrated subject matter expertise through professional experience, scholarship, or practice within the relevant field. - Commitment to student success and academic excellence. - Willingness and ability to be on camera through recordings and live interactions with students. - Willingness and ability to contribute some nights as required for synchronous components in some courses. Requirements - A flat rate of $1000 per credit for a section of at least 10 undergraduate students or 8 graduate students. - Low enrolled courses will be paid on a directed study rate ($250/student for undergraduate courses and $300/student for graduate courses) based on the number of students enrolled in the course section at the close of late registration.


