Talent.com
No longer accepting applications
Business Systems Analyst / Data Analyst (MBS Data & Data Lineage)

Business Systems Analyst / Data Analyst (MBS Data & Data Lineage)

Main DigitalMc Lean, VA, US
30+ days ago
Job type
  • Full-time
  • Permanent
Job description

WHO ARE WE LOOKING FOR?

We are seeking a highly analytical and detail-oriented Data Analyst to join a critical modernization initiative for a leading mortgage provider. This is a unique opportunity to support one of the industry's most transformative projects as it moves from legacy platforms to modern data architecture. The ideal candidate has strong SQL skills, experience with tracing data lineage between systems and working with mortgage or securities data (MBS), and the ability to work across technical and business teams to ensure data continuity and readiness.

  • This position requires the candidate to work onsite in Tyson's Corner, VA up to 3x days a week. For those not local to the area, you must be open to traveling to this area twice a month for up to 3 days a week as needed.
  • Candidates must be authorized to work in the U.S. (U.S. Citizens, U.S. Permanent Residents, or individuals with a valid EAD only. We are unable to provide visa sponsorship or work authorization in the future.)

WHAT YOU'LL DO :

Reporting to our Resource Manager, as a Full-Time Specialist on our team, you will play a key role in tracing and analyzing data from both legacy and modern systems, enabling stakeholder readiness and continuity through the transition. You will validate data transformation logic, support internal teams with new data schemas, and communicate technical insights in a clear and actionable manner. Your work will directly impact the successful adoption of a next-generation data platform for a top-tier financial institution.

QUALIFICATIONS :

  • Strong SQL skills for data querying, transformation, and validation
  • Advanced Excel skills for data analysis and reporting
  • Experience with loan data, GSEs, or mortgage-backed securities (MBS)
  • Proven ability to communicate clearly with technical and non-technical stakeholders
  • Strong analytical mindset and attention to detail
  • Experience working in fast-paced, enterprise environments
  • Experience supporting data transformation or migration projects
  • Familiarity with XML and JSON data formats is preferred.
  • Proficiency in Python and scripting for data manipulation is preferred.
  • RESPONSIBILITIES :

  • Analyze and interpret data across legacy and modern repositories
  • Perform forensic data analysis to trace lineage and understand transformation logic
  • Translate and document data transformation logic for accuracy and transparency
  • Write, optimize, and explain complex SQL queries for data extraction and validation
  • Utilize Excel and scripting tools (e.g., Python) to manipulate and automate data processes
  • Interpret structured data formats, including JSON and XML
  • Support internal teams (e.g., Finance) with new data schema adoption
  • Collaborate cross-functionally with product, engineering, and data teams to align data requirements
  • WHAT WE OFFER :

    Celebrated by Inc. 5000 for our rapid growth and award-winning workplace, Main Digital invites you to be a part of our collaborative and forward-thinking team. As a Certified Women-Owned Small Business, we champion diversity in tech. Our diverse teams combine management consulting expertise, innovative digital design, and advanced product engineering. Driven by our six core values, we lead in intelligent automation, platform technologies, and Agile methodologies to create unparalleled digital experiences. Join us as we empower people to create new possibilities through process and technology, reimagining the ways of work and enhancing experiences with digital transformation.

    Ready to innovate? Explore a career offering competitive compensation, comprehensive benefits, and extensive development opportunities. Apply today and shape the future with us!

    Main Digital is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation because of age, race, color, national origin, ancestry, religion, sex, sexual orientation (including transgender status, gender identity or expression), pregnancy (including childbirth, lactation, and related medical conditions), reproductive health decisions, marital status, personal appearance, matriculation, political affiliation, credit information, employment status, physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status, status as a victim or family member of a victim of domestic violence, a sexual offense, or stalking, homeless status, or any other status protected by federal, state, or local laws.

    Create a job alert for this search

    System Analyst • Mc Lean, VA, US

    Related jobs
    • Promoted
    Business System Analyst with Asset Management

    Business System Analyst with Asset Management

    AHU Technologies, Inc.Washington, DC, United States
    Permanent
    Possession of a Bachelor's degree from an accredited college in Business Administration, Finance, Engineering, Information Technology, or other related field, or. Seven (7) years of experience in IT...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Oracle E-Business Suite Business / Systems Analyst

    Oracle E-Business Suite Business / Systems Analyst

    Johns Hopkins Applied Physics LaboratoryLaurel, MD, United States
    Permanent
    Are you a problem solver who enjoys bridging business needs and technical solutions in enterprise financial systems?.If so, we're looking for someone like you to join our team at APL.In this role, ...Show moreLast updated: 8 hours ago
    • Promoted
    Senior Business System Analyst

    Senior Business System Analyst

    AHU Technologies, Inc.Washington, DC, United States
    Permanent
    Business analysis and process mapping Maintain comprehensive business process flow diagrams (i.Collaborate with Product Owners to understand business processes, watch demonstrations and using a san...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Senior Business Systems Analyst

    Senior Business Systems Analyst

    CACI InternationalWashington, DC, United States
    Full-time
    Senior Business Systems Analyst.Job Category : Information Technology.Minimum Clearance Required to Start : Secret.Percentage of Travel Required : Up to 10%. CACI looking for an experienced Business Sy...Show moreLast updated: 8 hours ago
    Business Systems Analyst (Med) - TS clearance required to apply; Washington DC

    Business Systems Analyst (Med) - TS clearance required to apply; Washington DC

    Bow Wave LLCWashington, DC, USA
    Full-time
    Quick Apply
    Minimum five (5) years experience.Lead collection, capture, and management of mission user needs from prioritization.Facilitate the gathering of business focused requirements to support a product t...Show moreLast updated: 30+ days ago
    • Promoted
    Business System Analyst

    Business System Analyst

    Apex SystemsAlexandria, VA, United States
    Temporary
    For immedaite response, please send to [email protected] : WORD Resume, desired hourly / salary rate, and best time to speak!. Position : TS / SCI Business Systems Analyst / Data Analyst.Location : Alexandr...Show moreLast updated: 9 days ago
    • Promoted
    Data Analyst - Enterprise Systems & Business Intelligence

    Data Analyst - Enterprise Systems & Business Intelligence

    Kda Consulting IncHerndon, Virginia, United States
    Full-time
    We’re seeking a mission-aligned, strategically-minded Data Analyst to support enterprise-wide visibility and decision intelligence across business, engineering, operations, cost, performance, and s...Show moreLast updated: 30+ days ago
    • Promoted
    Business Analyst

    Business Analyst

    Trilyon, Inc.McLean, Maryland, USA
    Full-time
    For over 16 years Trilyon has been a leader in global workforce solutions specializing in Cloud Technology AI / ML Software Development Technical Writing and Digital Transformation.We partner with to...Show moreLast updated: 2 days ago
    • Promoted
    Systems Analyst III

    Systems Analyst III

    Meta Force Technology Staffing LLCReston, Virginia, USA
    Full-time
    Reston only - hybrid 4 days onsite 1 day offsite per week.We are hiring a Business / Data Analyst to join our data warehouse team. The analyst is expected to work alongside business users / business ...Show moreLast updated: 1 day ago
    Business Analyst (Hybrid)

    Business Analyst (Hybrid)

    SiloSmashersArlington, VA, USA
    Full-time
    Quick Apply
    DHS suitability clearance, as required by federal contract.The Business Analyst will support DHS CISA by gathering, analyzing, and documenting business and technical requirements to improve process...Show moreLast updated: 30+ days ago
    • Promoted
    Business Analyst

    Business Analyst

    TradeJobsWorkforce22207 Arlington, VA, US
    Full-time
    ESSENTIAL JOB FUNCTIONS Analyzes global markets for IT Services, servers, storage, backup, IT security, productivity software, remote monitoring services, hyperconvergence and IoT.Studies SMB and m...Show moreLast updated: 30+ days ago
    • Promoted
    Business Systems Analyst - Mid

    Business Systems Analyst - Mid

    AmentumWashington, DC, United States
    Full-time
    As a Top Secret cleared Business Analyst for this program, you will be working in an organization that's mission is to develop and operate the best possible software for critical national security ...Show moreLast updated: 13 days ago
    • Promoted
    IT Business Analyst

    IT Business Analyst

    Kanak Elite Services IncTriangle, Virginia, USA
    Full-time
    I am reaching out to share an excellent career opportunity for the role of.Lead Oracle Cloud Tax / OneSource Consultant.If you are interested then please share your updated resume at.Oracle Cloud Tax...Show moreLast updated: 2 days ago
    • Promoted
    Software Engineer / Data Management Analyst

    Software Engineer / Data Management Analyst

    DCS CorporationFort Belvoir, Virginia, US
    Full-time
    DCS is seeking a data management analyst to support an Army project management office at Fort Belvoir, Virginia.This position supports a fast-paced program office with the collection, evaluation, a...Show moreLast updated: 23 days ago
    • Promoted
    Senior Business Analyst - Operations - Remote

    Senior Business Analyst - Operations - Remote

    SentaraWoodbridge, VA, United States
    Remote
    Full-time
    Sentara is hiring for a Senior Business Analyst - Operations - Remote!.This position is responsible for the implementation and support of quality initiatives within assigned areas.Provides subject ...Show moreLast updated: 25 days ago
    • Promoted
    Business System Analyst - Master

    Business System Analyst - Master

    AHU Technologies, Inc.Washington, DC, United States
    Permanent
    Business System Analyst - Master.Hybrid position - local candidates only.Formulates and defines systems scope and objectives based on both user needs and a thorough understanding of business system...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Specialist IS Business Systems Analyst - Product Team

    Specialist IS Business Systems Analyst - Product Team

    AmgenWashington, DC, United States
    Full-time
    Join Amgen's Mission of Serving Patients.At Amgen, if you feel like you're part of something bigger, it's because you are. Our shared mission-to serve patients living with serious illnesses-drives a...Show moreLast updated: 6 hours ago
    • Promoted
    BusinessData Analyst

    BusinessData Analyst

    KMM Technologies, Inc.Reston, Virginia, USA
    Full-time
    We are hiring a Business / Data Analyst to join our data warehouse team.The analyst is expected to work alongside business users / business or data or systems analyst / developers and report directly...Show moreLast updated: 3 days ago