Sr Data Integrations Analyst - Charlotte

Job#: 3017956

Job Description:

Apex Systems, a World-Class Technology Solutions Provider, is seeking applicants for the below position on behalf of our client. Please apply if interested and qualified. Please note that only qualified candidates will be contacted.

Position: Sr. Data Integrations Analyst

Location: 3 days on-site in Charlotte, NC | 2 days remote

Duration: Up to 24 months

Type: W2 contract, paid hourly. No C2C, 1099, or third-party submissions will be accepted. Only direct W-2 candidates will be considered.

Pay Rate Range: W2 $65-75/hr, negotiable based on experience

Industry: Banking

Job Description

Sr Data Integrations Analyst will support data integration of nCino and Blast loan origination systems. The ideal candidate has strong data profiling experience, understands data quality controls, and can translate findings into actionable insights. Experience with nCino or commercial lending systems is a strong plus.

Must Have

5-7+ years of experience in data analysis, data integration, or related roles.

Extensive SQL experience across multiple platforms

Ability to read, interpret, and analyze complex SQL (no coding required, but must understand logic deeply).

Database skills - Oracle, Teradata, SQL Server.

Strong understanding of data models, schemas, primary keys, joins, and relational database concepts.

Experience with performance tuning or understanding query performance considerations.

Experience with data profiling, data mining, and data reconciliation.

Ability to trace data flows across systems and identify where data breaks or changes.

Strong understanding of data quality controls (null checks, constraints, keys, validation rules).

Experience analyzing production issues and performing root-cause analysis.

Preferred Skills

Experience with nCino (major plus, especially with integrations).

Background in banking, lending, or commercial loan systems (not required but beneficial).

Prior Wells Fargo experience is a significant plus.

Experience with Copilot or AI-assisted analysis tools (daily usage).

Soft Skills

Highly curious about how things work.

Excellent communication skills and ability to work with diverse technical and business partners.

Strong problem-solving skills and ability to identify the right contacts and navigate complex organizations.

Ability to escalate appropriately and identify risks.

Day-to-Day

The analyst will work closely with technology teams, product owners, and business partners to identify data attributes, understand data flows, reconcile discrepancies, and support both project-based integrations and production issues. This role requires someone who is naturally curious, highly detail-oriented, and comfortable navigating large datasets and complex SQL logic (including multi-thousand-line queries).

Data mining, profiling, scrubbing, and mapping across multiple systems and databases.

Analyze complex SQL queries (including 4,000+ line scripts) to understand logic, data flows, and transformations.

Investigate data quality issues-identify root causes, trace data lineage, and determine why fields are missing, incomplete, or inconsistent.

Perform data reconciliation between systems (e.g., iHub, LIQ, nCino, other internal platforms).

Conduct data discovery and mapping exercises to understand how fields translate across systems and ensure alignment.

Work with product owners, ABOs, tech teams, and system partners to gather answers, validate assumptions, and resolve issues.

Support production issues by logging in, analyzing data discrepancies, and determining what changed and why.

Document findings and provide recommendations for remediation or process improvements.

Apex Benefits Overview

Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a retirement plan (401k or local country equivalent) program. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.