Reporting Analyst III
for each heading. Use - for lists. Use
for prose.
We must preserve all substantive info, not invent. Remove boilerplate: EEO, inclusion, etc. Also remove "Represents basic qualifications..." etc. Also remove "careers.cnb.com accepts applications..." etc. Also remove "About Us" maybe? The "About Us" paragraph is substantive? It describes company; could be considered About the role? Might be considered extra but it's substantive about company. The instruction: preserve ALL substantive information; do not invent or summarize away detail. So we should keep the About Us paragraph. Where to place? Could be part of About the role or separate section? There's no heading for About Us in posting, but it's after WHAT'S IN IT FOR YOU? It's a paragraph about company. Could be included under About the role as additional prose. Or we could create a section "About the Company" but not in allowed headings list. The allowed headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we should stick to those. So we can put the About Us paragraph under About the role as prose.
We need to not repeat job title as heading. So no heading for REPORTING ANALYST III- US Mortgage Banking.
We need to include Pay section with compensation range. Benefits section with list.
We need to not include Schedule.
We need to not include Skills unless present; there is no explicit Skills section, but we could embed skills in Requirements. Better to not create Skills heading.
We need to ensure we don't create empty sections.
Let's extract content:
About the role (WHAT IS THE OPPORTUNITY?):
"Partners with reporting manager and respective Line of Business (LOB) management to identify, prioritize, track and execute strategic initiatives. Provides analysis on key trends and proposes business solutions related to processes, efficiencies and staffing. Focus on providing value-added analysis and recommendations to support business growth. Responsibilities include developing and tracking of key statistical information and performance metrics, organizing and presenting data to management and managing multiple projects end to end."
Also About Us paragraph: "Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us."
We could combine.
Responsibilities (WHAT WILL YOU DO?):
List items:
- Data Analytics and modeling; establish baseline metrics and analytics, collaborate with Business Operations and the leadership team to track and report all key performance indicators against annual, quarterly and monthly goals.
- Establish and maintain management dashboards, regional reports, and executive review documents that will drive business outcomes.
- Monitor existing KPI metrics, developing new metrics, identity correlations and root causes
- Design and build visualization dashboards to accelerate information-to-action at scale
- Performing regular system audits to ensure complete and accurate reporting of data/metrics
- Support quarterly, annual planning activities
- Develop programs, methodologies, and reports for analyzing and presenting data
- Act as a SME for BI tools as well as delivering training to team members on the usage of these tools
- Contribute and prepare presentations for internal audiences
- Invent new ways to define and measure program effectiveness and organizational productivity
We need to preserve each as list items.
Requirements/Qualifications (WHAT DO YOU NEED TO SUCCEED?):
Required Qualifications:
* Bachelor's Degree or equivalent
* Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst
* Minimum 3 years in the Mortgage Industry
Additional Qualifications:
- Capacity to work independently with little to no supervision
- Experience in the financial services industry is a plus
- Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach
- Demonstrated ability to direct initiatives with successful results
- MS SQL and other related Business Intelligence tools
- Excellent verbal and written communication skills
- Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required
- Strong leadership and organizational skills
- Ability to work independently, as well as in a team environment
- Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc
- Previous experience with reporting tools preferred
- Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred
We could combine into Requirements section (maybe also Qualifications). Since we have both Required and Additional, we could put all in Requirements (or Qualifications). The instruction: Use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have both Requirements and Qualifications if we have content. But we might combine to avoid thin sections. However we have both required and additional qualifications; we could split: Requirements for required qualifications, Qualifications for additional qualifications. That seems reasonable.
Thus:
Requirements
- Bachelor's Degree or equivalent
- Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst
- Minimum 3 years in the Mortgage Industry
Qualifications
- Capacity to work independently with little to no supervision
- Experience in the financial services industry is a plus
- Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach
- Demonstrated ability to direct initiatives with successful results
- MS SQL and other related Business Intelligence tools
- Excellent verbal and written communication skills
- Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required
- Strong leadership and organizational skills
- Ability to work independently, as well as in a team environment
- Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc
- Previous experience with reporting tools preferred
- Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred
Benefits section: from WHAT'S IN IT FOR YOU? Benefits and Perks list:
- Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
- Generous 401(k) company matching contribution
- Career Development through Tuition Reimbursement and other internal upskilling and training resources
- Valued Time Away benefits including vacation, sick and volunteer time
- Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs
- Career Mobility support from a dedicated recruitment team
- Colleague Resource Groups to support networking and community engagement
Also there is a line "Get a more detailed look at our Benefits and Perks." That's like a link; we can drop as boilerplate? It's not substantive; it's a call to action. Might be considered boilerplate; we can drop.
Pay section: Compensation Starting base salary: $87,027 - $138,965 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
We should include that as prose under Pay heading.
Schedule: not present, so omit.
Now we need to output only HTML fragment, no html/body tags, no markdown.
Let's construct:
About the role
Partners with reporting manager and respective Line of Business (LOB) management to identify, prioritize, track and execute strategic initiatives. Provides analysis on key trends and proposes business solutions related to processes, efficiencies and staffing. Focus on providing value-added analysis and recommendations to support business growth. Responsibilities include developing and tracking of key statistical information and performance metrics, organizing and presenting data to management and managing multiple projects end to end.
Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us.
Responsibilities
- Data Analytics and modeling; establish baseline metrics and analytics, collaborate with Business Operations and the leadership team to track and report all key performance indicators against annual, quarterly and monthly goals.
- Establish and maintain management dashboards, regional reports, and executive review documents that will drive business outcomes.
- Monitor existing KPI metrics, developing new metrics, identity correlations and root causes
- Design and build visualization dashboards to accelerate information-to-action at scale
- Performing regular system audits to ensure complete and accurate reporting of data/metrics
- Support quarterly, annual planning activities
- Develop programs, methodologies, and reports for analyzing and presenting data
- Act as a SME for BI tools as well as delivering training to team members on the usage of these tools
- Contribute and prepare presentations for internal audiences
- Invent new ways to define and measure program effectiveness and organizational productivity
Requirements
- Bachelor's Degree or equivalent
- Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst
- Minimum 3 years in the Mortgage Industry
Qualifications
- Capacity to work independently with little to no supervision
- Experience in the financial services industry is a plus
- Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach
- Demonstrated ability to direct initiatives with successful results
- MS SQL and other related Business Intelligence tools
- Excellent verbal and written communication skills
- Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required
- Strong leadership and organizational skills
- Ability to work independently, as well as in a team environment
- Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc
- Previous experience with reporting tools preferred
- Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred
Benefits
- Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
- Generous 401(k) company matching contribution
for prose. We must preserve all substantive info, not invent. Remove boilerplate: EEO, inclusion, etc. Also remove "Represents basic qualifications..." etc. Also remove "careers.cnb.com accepts applications..." etc. Also remove "About Us" maybe? The "About Us" paragraph is substantive? It describes company; could be considered About the role? Might be considered extra but it's substantive about company. The instruction: preserve ALL substantive information; do not invent or summarize away detail. So we should keep the About Us paragraph. Where to place? Could be part of About the role or separate section? There's no heading for About Us in posting, but it's after WHAT'S IN IT FOR YOU? It's a paragraph about company. Could be included under About the role as additional prose. Or we could create a section "About the Company" but not in allowed headings list. The allowed headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we should stick to those. So we can put the About Us paragraph under About the role as prose. We need to not repeat job title as heading. So no heading for REPORTING ANALYST III- US Mortgage Banking. We need to include Pay section with compensation range. Benefits section with list. We need to not include Schedule. We need to not include Skills unless present; there is no explicit Skills section, but we could embed skills in Requirements. Better to not create Skills heading. We need to ensure we don't create empty sections. Let's extract content: About the role (WHAT IS THE OPPORTUNITY?): "Partners with reporting manager and respective Line of Business (LOB) management to identify, prioritize, track and execute strategic initiatives. Provides analysis on key trends and proposes business solutions related to processes, efficiencies and staffing. Focus on providing value-added analysis and recommendations to support business growth. Responsibilities include developing and tracking of key statistical information and performance metrics, organizing and presenting data to management and managing multiple projects end to end." Also About Us paragraph: "Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us." We could combine. Responsibilities (WHAT WILL YOU DO?): List items: - Data Analytics and modeling; establish baseline metrics and analytics, collaborate with Business Operations and the leadership team to track and report all key performance indicators against annual, quarterly and monthly goals. - Establish and maintain management dashboards, regional reports, and executive review documents that will drive business outcomes. - Monitor existing KPI metrics, developing new metrics, identity correlations and root causes - Design and build visualization dashboards to accelerate information-to-action at scale - Performing regular system audits to ensure complete and accurate reporting of data/metrics - Support quarterly, annual planning activities - Develop programs, methodologies, and reports for analyzing and presenting data - Act as a SME for BI tools as well as delivering training to team members on the usage of these tools - Contribute and prepare presentations for internal audiences - Invent new ways to define and measure program effectiveness and organizational productivity We need to preserve each as list items. Requirements/Qualifications (WHAT DO YOU NEED TO SUCCEED?): Required Qualifications: * Bachelor's Degree or equivalent * Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst * Minimum 3 years in the Mortgage Industry Additional Qualifications: - Capacity to work independently with little to no supervision - Experience in the financial services industry is a plus - Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach - Demonstrated ability to direct initiatives with successful results - MS SQL and other related Business Intelligence tools - Excellent verbal and written communication skills - Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required - Strong leadership and organizational skills - Ability to work independently, as well as in a team environment - Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc - Previous experience with reporting tools preferred - Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred We could combine into Requirements section (maybe also Qualifications). Since we have both Required and Additional, we could put all in Requirements (or Qualifications). The instruction: Use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have both Requirements and Qualifications if we have content. But we might combine to avoid thin sections. However we have both required and additional qualifications; we could split: Requirements for required qualifications, Qualifications for additional qualifications. That seems reasonable. Thus:
Requirements
- Bachelor's Degree or equivalent
- Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst
- Minimum 3 years in the Mortgage Industry
Qualifications
- Capacity to work independently with little to no supervision
- Experience in the financial services industry is a plus
- Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach
- Demonstrated ability to direct initiatives with successful results
- MS SQL and other related Business Intelligence tools
- Excellent verbal and written communication skills
- Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required
- Strong leadership and organizational skills
- Ability to work independently, as well as in a team environment
- Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc
- Previous experience with reporting tools preferred
- Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred
About the role
Partners with reporting manager and respective Line of Business (LOB) management to identify, prioritize, track and execute strategic initiatives. Provides analysis on key trends and proposes business solutions related to processes, efficiencies and staffing. Focus on providing value-added analysis and recommendations to support business growth. Responsibilities include developing and tracking of key statistical information and performance metrics, organizing and presenting data to management and managing multiple projects end to end.
Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us.
Responsibilities
- Data Analytics and modeling; establish baseline metrics and analytics, collaborate with Business Operations and the leadership team to track and report all key performance indicators against annual, quarterly and monthly goals.
- Establish and maintain management dashboards, regional reports, and executive review documents that will drive business outcomes.
- Monitor existing KPI metrics, developing new metrics, identity correlations and root causes
- Design and build visualization dashboards to accelerate information-to-action at scale
- Performing regular system audits to ensure complete and accurate reporting of data/metrics
- Support quarterly, annual planning activities
- Develop programs, methodologies, and reports for analyzing and presenting data
- Act as a SME for BI tools as well as delivering training to team members on the usage of these tools
- Contribute and prepare presentations for internal audiences
- Invent new ways to define and measure program effectiveness and organizational productivity
Requirements
- Bachelor's Degree or equivalent
- Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tool or as a Business Analyst
- Minimum 3 years in the Mortgage Industry
Qualifications
- Capacity to work independently with little to no supervision
- Experience in the financial services industry is a plus
- Demonstrated ability to translate business requirements into solutions utilizing a customer-friendly approach
- Demonstrated ability to direct initiatives with successful results
- MS SQL and other related Business Intelligence tools
- Excellent verbal and written communication skills
- Demonstrated ability to manage multiple projects and priorities and work in a fast paced environment required
- Strong leadership and organizational skills
- Ability to work independently, as well as in a team environment
- Proficiency with Microsoft Office software, including Word, Excel, Access, PowerPoint, etc
- Previous experience with reporting tools preferred
- Previous experience with Mortgage, Consumer, or Commercial sales origination platforms/systems preferred
Benefits
- Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
- Generous 401(k) company matching contribution