Note: The job is a remote job and is open to candidates in USA. Bridgeway Benefit Technologies is seeking a Senior Systems Analyst to lead complex data conversion efforts for their customers. In this hands-on, customer-facing role, you will manage the end-to-end conversion lifecycle, ensuring successful data migrations and collaborating with various teams to meet customer needs.
Responsibilities
- Lead full-cycle data conversion 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
- Leverage generative AI tools such as Claude and Copilot to streamline workflows, enhance productivity, improve solution quality, and accelerate delivery of business outcomes
Skills
- 5+ years of experience in data conversion, warehousing, systems analysis, or ETL-focused roles
- Proven ability to manage multiple, large conversion efforts at once
- Advanced SQL skills (complex queries, joins, performance tuning)
- Hands-on experience with ETL/ELT tools (SSIS 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
- Bachelor's degree in Computer Science or a related field
- Exposure to AI for data analysis, validation, or development a plus
- Databricks, Snowflake or similar a plus
- Experience using generative AI tools such as Claude and Copilot to improve productivity and deliver high-quality outcomes
Company Overview