Job Description & Details
This is a heavy-duty legacy modernization role centered around untangling the LARS legacy system. If you like detective work, untangling undocumented data models, and setting up data governance from scratch, this gig will keep you thoroughly occupied.
What You'll Actually Be Doing
Your day-to-day will be split between deep SQL querying, reverse-engineering old database structures, and dealing with ServiceNow tickets. You'll spend a lot of time mapping how legacy fields feed into APIs, certificates, and extracts while coordinating with external vendors on the upcoming data migration. Expect to build and maintain a centralized data dictionary while continuously running validation checks to catch anomalies before they break downstream systems.
The Core Tech Stack
You need absolute fluency in Advanced SQL for data profiling and integrity validation, paired with advanced Excel capabilities like complex lookups, pivot tables, and basic modeling. Because this role bridges legacy systems and modern architectures, your ability to read messy schemas, write clean documentation, and communicate data risks to non-technical stakeholders is just as critical as your database chops.
Interview Expectations
Since this is an in-person interview process, be prepared for a whiteboard session where you'll likely be asked to write a complex SQL query involving multiple joins, subqueries, and window functions to identify data anomalies in a messy dataset. They will also drill into your experience with legacy migrations—expect them to ask how you handle undocumented field dependencies and how you convince stubborn business units to adopt new data governance standards.
Application Advice
To get past the ATS for this role, ensure your resume heavily emphasizes terms like "data mapping," "SQL-driven data profiling," "legacy system modernization," and "data dictionary." Don't just list technologies; write out specific achievements where you audited a messy database, cleaned up systemic data issues, and successfully collaborated with vendors on a migration pipeline.