Senior Data Analyst
Main Digital - Mc Lean, Virginia, us, 22107
Work at Main Digital
Overview
- View job
Overview
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 mortgage or securities data, and the ability to work across technical and business teams to ensure data continuity and readiness. They should reside in the local Tysons Corner area and be comfortable going onsite up to 3 days a week as needed.
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. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Analyst Industries Business Consulting and Services, IT Services and IT Consulting, and Financial Services Referrals increase your chances of interviewing at Main Digital by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Paid paternity leave Tuition assistance Disability insurance Student loan assistance Paid maternity leave Get notified when a new job is posted. Sign in to set job alerts for “Senior Data Analyst” roles.
Tysons Corner, VA $140,000.00-$170,000.00 1 day ago Washington, DC $45,000.00-$55,000.00 3 weeks ago Senior Analyst, Marketing & Business Analytics
Arlington, VA $121,000.00-$144,000.00 1 day ago Data and Analytics Associate / Senior Analyst - Portfolio Management & Business Analytics Group
Senior Benefits Data & Operations Analyst
Washington, DC $85,100.00-$127,700.00 1 week ago Senior Analyst, Loan & Data Administration
District of Columbia, United States $85,000.00-$95,000.00 2 days ago Senior Business Analyst (Infrastructure)
Bethesda, MD $97,000.00-$120,150.00 6 months ago Senior Business Systems Analyst - Operations
Prince William County, VA $76,069.50-$104,676.00 1 week ago Senior Data Analyst (TRICARE Encounter Data)
Business and Data Analyst - Requires DHS Public Trust
Tysons Corner, VA $140,000.00-$170,000.00 1 day ago Washington, DC $129,000.00-$169,000.00 2 weeks ago Manager Data Analyst - Retail Bank, Small Business Bank
Bethesda, MD $90,000.00-$135,000.00 1 month ago Business Data Analyst IV - Lead Analyst, Ownership Verification
Tysons Corner, VA $140,000.00-$170,000.00 1 day ago Sr. Manager, Data Analyst - Small Business Bank
McLean, VA $115,000.00-$151,500.00 2 weeks ago Laurel, MD $90,000.00-$230,000.00 6 days ago Business Analyst - AI & Data Analytics Focus
Business Analyst (Technical Writing & Azure Data Focus)
Business Development Intelligence Analyst (BDIA)
Lead – Platform Development for Data Storage, Analysis and Reporting, World Bank Third Party Monitoring (Proposal Position), Various Locations
Lead – Platform Development for Data Storage, Analysis and Reporting, World Bank Third Party Monitoring, Various Locations
Washington, DC $110,000.00-$140,000.00 2 weeks ago Senior Business Systems Analyst, Quote to Cash
Washington, DC $135,300.00-$200,400.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr