Cornerstone Capital Bank logo
Cornerstone Capital Bank

Enjoy a new online banking experience with the same exceptional customer service you expect from Cornerstone companies.

Senior Loan Boarding Data Analyst

Data AnalystData AnalystFull TimeRemoteSeniorTeam 51-200H1B No SponsorCompany SiteLinkedIn

Location

Colorado

Posted

2 days ago

Salary

$70K - $100K / year

Seniority

Senior

Bachelor Degree5 yrs expExperience acceptedEnglishSQL

Job Description

Senior Loan Boarding Data Analyst

Cornerstone Capital Bank

• Independently review and interpret company policies to make decisions on matters of regulatory compliance, investor guidance, and customer impact in regard to loan boarding and servicing transfers • Independently work with stakeholders including the Executive, Product, Data and Design teams to support their boarding data needs to ensure Cornerstone’s ability to perform loan servicing • Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes • Manage incoming loan transfers and origination processes including process documentation (i.e. checklists, transfer instructions, etc.) • Responsible for exercising discretion in mapping, coding, and formatting data system files and customer information for loan boarding processes • Develop loan boarding applications for data integrity and timing purposes • Oversee third party vendors integral to loan-boarding processes • Perform project management role • Perform other job-duty-related issues as assigned

Job Requirements

  • Bachelor’s Degree Preferred in Computer Science, Management Information Systems and/or Business Administration, or equivalent years of experience
  • Minimum of 5 years of experience in database administration, information technology, database architecture, or a related field
  • Exceptional experience with managing loan origination boarding and bulk service transfer processes
  • Ability to act independently in decision making
  • Ability to multitask, attention to detail and prioritize a diverse workload with time-sensitive deadlines
  • Ability to perform change management duties
  • Strong time and organizational management skills a must
  • Exceptional interpersonal skills in addition to verbal/written communication in a clear, concise, and professional manner
  • Experience with the Microsoft suite of products including Excel, Access, Word, Visio, and SQL Server Management Studio
  • Experience with Black Knight’s MSP Servicing system and LoanSphere Loan Boarding application
  • Strong command of SQL and SQL server tools to identify, document, and develop edit-check queries and reports
  • Travel: Up to 25% out-of-town required

Benefits

  • Competitive salary
  • Full benefits package
  • Potential for performance-based bonus

Related Categories

Related Job Pages

More Data Analyst Jobs

AppZen logo

GTM Systems & Analytics Manager

AppZen

Our patented AI software is purpose-built for finance to deliver autonomous AP and expense audit for modern teams.

Data Analyst2 days ago
Full TimeRemoteTeam 201-500H1B Sponsor

• Own day-to-day administration, configuration, and optimization of Salesforce CRM • Translate business requirements into scalable Salesforce solutions (objects, fields, flows, validation rules, automation) • Build and test enhancements in sandbox environments and manage releases to production • Design and improve GTM workflows (lead routing, pipeline stages, forecasting logic, approvals) • Ensure data integrity, governance, and system scalability as the business grows • Partner with RevOps, Sales, and Marketing to continuously improve system usability and adoption • Identify gaps in current GTM systems and proactively implement improvements • Support tooling and system integrations across the GTM tech stack • Partner with stakeholders to standardize and scale processes across Sales and Revenue teams • Partner with Finance and GTM leadership to deliver insights that inform decision-making

New York
$160K - $190K / year
H1 logo

Principal Analyst, Data Integration

H1

H1 is a software company on a mission to democratize global healthcare information for life sciences, health systems, academic medical institutions, and payors.

Data Analyst2 days ago

• Own the end-to-end process of evaluating, scoping, and onboarding new data sources into H1's platform. • Lead structured evaluation of new data sources from scratch — assessing schema, coverage, freshness, legal constraints, and fit against H1's product needs before any engineering work begins. • Own field mapping from source to H1's bronze/silver/gold layers, producing data dictionaries, entity definitions, and structural guidance for downstream teams. • Partner with engineering and Data Lake to define ingestion requirements, entity resolution rules, and refresh cadences for new sources. • Gather requirements from client-facing teams and translate them into integration specifications; serve as the authoritative voice on what a new source can and cannot deliver before product commitments are made. • Shepherd each source end-to-end: scoping → QA → entity matching → product launch, including product QA and communicating source capabilities and limitations to product and enablement partners. • Work with the Insights team to develop new taxonomies and QA mechanisms for novel data types. • Define acceptance criteria and lead QA validation including field-level fill rates, count comparisons, and cycle-over-cycle anomaly detection. • Investigate and resolve data quality issues post-integration, coordinating with DART and engineering as needed. • Hand off to the maintaining team with complete mapping documentation; you own onboarding, not ongoing maintenance. • Produce and maintain documentation other people actually use — across scoping assessments, field mapping specs, and post-mortems.

United States
$145K - $170K / year
Full TimeRemoteTeam 501-1,000Since 1956H1B Sponsor

• Support the execution of analytics initiatives across Technical Operations. • Identify opportunities for operational improvements, cost optimization, and performance tracking. • Develop and maintain dashboards and reporting solutions, ensuring data accuracy, usability, and alignment with business needs. • Generate actionable insights and support the creation of presentations and business cases for stakeholders. • Work with business and IT teams to extract, transform, and analyze data from multiple sources. • Participate in cross-functional projects, supporting deliverables, timelines, and coordination across teams. • Assist in the development and standardization of KPIs, metrics, and reporting frameworks.

Massachusetts
$89K - $148K / year
Mastercard logo

Senior Analyst, Legal Compliance (Data Analysis)

Mastercard

Founded in 1966, Mastercard is a worldwide transaction, payment-processing, and consulting company best known for its line of personal and business credit cards. As an employer, Ma

Data Analyst2 days ago
Full TimeRemoteTeam 38,800Since 1966

Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Senior Analyst, Legal Compliance (Data Analysis) Who is Mastercard? Mastercard is a global technology company in the payments industry. Our mission is to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all. Overview Mastercard is committed to protecting our network from being used to facilitate money laundering and terrorist financing. The Global Anti Money Laundering (AML) Financial Intelligence Unit (FIU) has implemented a customer monitoring program to meet regulatory obligations, support internal stakeholder investigations and to ensure that customers have robust programs in place to meet Mastercard requirements. The FIU is responsible for large-scale data analysis, alert dispositioning, and ad-hoc investigations using AML typologies, rules, and internal data sources to monitor customer behavior and support compliance investigations. The Senior Analyst, Legal Compliance, reports to the Director, Legal Compliance. This position is highly data-driven and supports the FIU by conducting AML-related activities through advanced data extraction, manipulation, and analysis as part of the transaction monitoring and investigation lifecycle. Working under general supervision, the analyst will leverage strong analytical and technical skills, particularly SQL and Excel, to analyze very large datasets, identify patterns, assess risk factors, and document findings through clear investigative narratives. Role• Conduct AML transaction monitoring, AdHoc investigations, and research via deep data analytics across large datasets covering multiple regions and countries.• Extract, query, and prepare data from internal databases (e.g., Oracle, data warehouse tables, system applications) to support investigations.• Utilize SQL and advanced Excel (Power Pivot, pivot tables, formulas) to analyze datasets that may include tens of millions of records.• Apply data mining techniques to identify behavioral patterns, anomalies, relationships, and meaningful insights within complex data sets.• Summarize analytical findings, trends, and red flags in clear written investigative narratives and reports.• Continuously develop technical and analytical expertise through training, self-study, and exposure to evolving AML typologies and data methodologies. All About You Experience:• Bachelor's degree required, or equivalent data analytics, banking/financial operations, payments industry, risk management or compliance related experience.• Familiarity with AML, BSA, USA PATRIOT Act and OFAC controls and requirements.• ACAMS certification preferred. Knowledge / Technical Skills (Key Emphasis):• Advanced Microsoft Excel skills are required, including Power Pivot, pivot tables, and complex formulas.• Strong understanding of data extraction, cleaning, manipulation, and summarization methodologies.• Hands-on experience with SQL (or similar languages), including modifying existing queries/scripts to extract data for specific investigations.• Proven ability to analyze large, complex datasets, identify trends, and translate data into defensible conclusions.• Experience working with compliance, risk, or investigative data is a plus. Personal Attributes:• Ability to proactively manage time and prioritize assignments to meet target dates and deadlines, while delivering thorough, accurate and quality work product.• Ability to quickly learn and apply payments industry terminology and AML-specific data context.• Strong attention to detail with the ability to produce accurate, high-quality analytical reports under deadlines.• Ability to work independently, thrive in fast paced and dynamic environment, and consistently meet established deadlines.• Ability to clearly explain and defend analytical conclusions verbally and in writing.• Ability to remain flexible in a demanding work environment while adapting rapidly changing priorities.• Availability to work in a hybrid model, with a requirement to be in the office 3 times per week. Corporate Security Responsibility Every person working for, or on behalf of, Mastercard is responsible for information security. All activities involving access to Mastercard assets, information, and networks come with an inherent risk to the organization and therefore, it is expected that the successful candidate for this position must:• Abide by Mastercard's security policies and practices.• Ensure the confidentiality and integrity of the information being accessed.• Report any suspected information security violation or breach.• Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines. Corporate Security Responsibility All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must: - Abide by Mastercard's security policies and practices; - Ensure the confidentiality and integrity of the information being accessed; - Report any suspected information security violation or breach, and - Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines. #BI-Hybrid

Brazil