Lead end-to-end data migration projects, collaborating with customers to analyze, map, transform, and validate data for successful go-live outcomes.
We’re looking for a Senior Systems Analyst to lead complex data migration efforts for our customers. In this role, you’ll own the end-to-end migration lifecycle – working directly with customers to analyze, map, transform, and validate data as it moves from legacy systems into Bridgeway’s platform.
This is a hands-on, customer-facing role for someone who is comfortable solving problems in real time and driving migrations to a successful go-live.
Responsibilities:
- Lead full-cycle data migrations across multiple customer projects (discovery → mapping → transformation → validation → go-live)
- Act as the primary technical contact for customers, guiding data strategy, surfacing risks, and managing expectations
- Collaborate with Business Analysts and other Professional Services teams to understand data requirements, provide data analyses to assist with the configuration of our software, and accurately map data to meet customer needs
- Analyze and validate large, complex datasets using advanced SQL
- Build and execute ETL/ELT processes (SSIS, Talend, Informatica, or similar)
- Develop data mapping logic, transformation rules, and validation strategies
- Identify and resolve data quality issues through profiling, cleansing, and root cause analysis
- Work across file formats (CSV, Excel) to support data exchange
- Plan and execute cutover activities, including go-live coordination and validation sign-off
- Partner with internal teams to troubleshoot issues and ensure accurate data delivery
- Mentor junior team members and contribute to improving migration processes and standards
Requirements:
- 5+ years of experience in data migration, warehousing, systems analysis, or ETL-focused roles
- Bachelor’s degree in Computer Science or a related field
- Advanced SQL or Python skills (complex queries, joins, performance tuning)
- Hands-on experience with ETL/ELT tools (SSIS preferred)
- Experience with scripting (Python or PowerShell) for automation
- Proven ability to manage multiple migrations at once without dropping the ball
- Strong customer-facing communication skills—you can explain technical issues without hiding behind jargon
- Use and understanding of data dictionaries, source to target mapping, and relational database concepts required
- High attention to detail and a problem-solving mindset
- Exposure to AI for data analysis, validation, or development a plus
- Databricks, Snowflake or similar a plus
Bridgeway is an equal opportunity employer.
Similar Jobs
eCommerce • Healthtech • Kids + Family • Retail • Social Media
The Staff Product Manager will own a major consumer surface or core customer journey at Babylist, defining product strategy, ensuring quality, and leading execution while promoting AI-native workflows and innovation.
Top Skills:
AIProduct Management
eCommerce • Healthtech • Kids + Family • Retail • Social Media
The role involves leading product management efforts at Babylist, focusing on AI-enabled product development, owner of customer journeys and product features, and driving measurable impact by blending strategic thinking with practical execution involving AI.
Top Skills:
AICoding ToolsLlms
.png)
Healthtech • Pharmaceutical • Telehealth
The role involves creating performance-driven paid social content, owning creative processes, analyzing data for design improvement, and collaborating with a copywriter to deliver effective ads across platforms.
Top Skills:
After EffectsFigmaIllustratorPhotoshopPremiere
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
