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. This role involves managing the end-to-end data conversion lifecycle and requires strong collaboration and problem-solving skills to ensure successful data migration into Bridgeway's software platform.
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
Skills
- 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
- Bachelor's degree in Computer Science, Data Analytics or a related field
- 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
Company Overview