Lead end-to-end data conversion projects: analyze and profile legacy data, develop mappings and ETL/ELT transformations, validate and load data, resolve quality issues, coordinate cutovers, mentor juniors, and leverage generative AI to accelerate delivery.
We’re looking for a Senior Systems Analyst to lead complex data conversion efforts for our customers. In this role, you’ll lead the end-to-end data conversion lifecycle, working directly with customers to analyze, map, transform, validate, and load data from their legacy systems into Bridgeway’s software platform.
This hands-on, customer-facing role requires strong cross-functional collaboration, real-time problem solving, data mapping and transformation expertise, and the ability to drive migrations through a successful go-live.
Responsibilities:
- Lead full-cycle data conversions for multiple large-scale projects
- Partner with customers and internal teams to analyze and profile legacy data, document source-to-target mapping requirements, and apply technical skills and AI-assisted development to transform and load data into Bridgeway’s platform
- Collaborate with Business Analysts and other Professional Services teams to understand business requirements, provide data analyses to assist with the configuration of our software, and accurately map data to meet customer needs
- Analyze, transform and validate large, complex datasets using advanced SQL
- Build and execute ETL/ELT processes
- Develop data mapping logic, transformation rules, and validation strategies
- Identify and resolve data quality issues through profiling, cleansing, and root cause analysis
- Work with multiple file formats (CSV, Excel, Fixed Width) 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
- Leverage generative AI tools such as Claude and Copilot to streamline workflows, enhance productivity, improve solution quality, and accelerate delivery of business outcomes
Requirements:
- 5+ years of experience in data conversion, warehousing, systems analysis, or ETL/ELT-focused roles
- Proven ability to manage multiple, large conversion efforts at once
- Advanced SQL skills - complex queries, joins, performance tuning (SQL Server, ANSI SQL, Python preferred)
- 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
- High attention to detail and a problem-solving mindset
- Exposure to AI for data analysis, validation, or development
- Databricks, Snowflake, or similar, a plus
- Experience with ETL tools similar to SSIS, Talend, or Informatica, a plus
- Experience using generative AI tools such as Claude and Copilot to improve productivity and deliver high-quality outcomes
- Bachelor’s degree in Computer Science, Data Analytics or a related field
Bridgeway is an equal opportunity employer.
Similar Jobs
Beauty • Robotics • Design • Appliances • Manufacturing
Manage day-to-day relationships with key retail partners to drive revenue and profit. Develop and execute omni-channel promotional and joint business plans, launch new products, negotiate agreements, analyze POS and sales data, forecast stock levels, and identify competitive threats. Collaborate with cross-functional teams (marketing, supply chain, category, finance) to increase market share.
Top Skills:
ExcelOutlookPowerPointWord
Beauty • Robotics • Design • Appliances • Manufacturing
Manage day-to-day relationships with assigned retail partners to drive revenue and profit. Lead promotional, marketing and joint business plans, pitch and launch new products, negotiate agreements, analyze POS and sales data, produce forecasts and reports, and coordinate cross-functional teams to grow market share.
Top Skills:
ExcelOutlookPosPowerPointWord
Beauty • Robotics • Design • Appliances • Manufacturing
Manage SharkNinja's Walmart national account to drive revenue, margin, distribution and digital goals. Build strategic plans, lead cross-functional teams, manage promotions, forecasting and supply chain coordination, analyze POS and trends, and execute omni-channel strategies to grow market share and profitability.
Top Skills:
ExcelOutlookPowerPointRetail LinkScintilla
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
