Data Integration Business Analyst

Role Overview

• Analyzing, designing, and implementing data integration solutions to enhance system efficiency and accuracy
• Enterprise-level planning, coordinating interdependent activities across systems, and guiding senior stakeholders in evaluating options and impacts to support informed decision-making
• Defining and governing data mapping standards, including field-level definitions, transformations, validation rules, and reconciliation requirements
• Documenting and maintaining end-to-end data flows and lineage across integrated systems to support traceability, auditability, and operational support
• Translating business and data strategy into implementation-ready requirements and delivery artifacts (e.g., functional requirements, user stories, data specifications)
• Partnering with technical teams to align integration patterns, delivery approach, and milestones to ensure scalable and repeatable solutions
• Ensuring secure data exchange practices are understood and followed, including requirements for file transfer mechanisms and access controls
• Identifying data risks early and works with stakeholders to define mitigation strategies throughout the integration lifecycle
• Collaborating cross-functionally with business, IT, and compliance teams to ensure data integration solutions adhere to governance, privacy, and regulatory standards
• Driving data quality outcomes by defining acceptance criteria, validation rationale, reconciliation processes, and defect remediation approaches
• Establishing operational readiness for file feeds and integrations, including cutover planning, support models, runbooks, and escalation paths
• Defining monitoring and alerting expectations for inbound and outbound file feeds to proactively identify and resolve failures or delays
• Leading complex troubleshooting and root-cause analysis efforts across teams, driving corrective and preventive actions
• Analyzing recurring issues and trends to recommend and implement continuous improvement opportunities for integration processes
• Providing leadership, coordination, and oversight into the work of other business analysts on large or complex initiatives
• Mentoring junior and mid-level business analysts on integration concepts, analysis techniques, tools, and documentation standards
• Contributing to the evolution of business analysis and data integration best practices, templates, and standards across the organization.

Requirements

• 3-5 years of experience as a Business Analyst, focused on data integration and ETL processes
• Completed a bachelor’s program in a technical discipline or have relevant work experience
• Extensive experience leading complex, cross-system data integration initiatives involving multiple stakeholders and dependencies
• Proven ability to operate as a senior advisor, influencing scope, approach, and outcomes at both program and leadership levels
• Advanced proficiency in SQL and data analysis to validate transformations, identify discrepancies, and support reconciliation and defect analysis
• Dynamic understanding of ETL, file-based integrations, and related tools, with the ability to collaborate deeply with engineering teams
• Working knowledge of data governance concepts, including data quality, metadata, lineage, and documentation standards
• Expert in producing high-quality, clear, and actionable delivery artifacts (e.g., requirements, specifications, process and data flow diagrams)
• Compelling facilitation and communication skills to lead workshops, drive alignment, and resolve ambiguity among diverse stakeholder groups.

Tech Stack

• ETL
• SQL

Benefits

• health, dental and vision coverages starting Day One
• wellbeing programs
• retirement plans with contribution matching
• generous time off
• parental leave
• continuing education
• career growth opportunities
• flexible working arrangements