Business Systems Analyst Lead, Data Warehouse

Huntington - Columbus, OH

Full-time

Hybrid - Columbus, OH

Repair and Maintenance

About the position

Huntington Bank is seeking a Lead Business Systems Analyst (BSA) to join their Enterprise Data Warehouse (EDW) team. This role focuses on ensuring quality data across the enterprise by building data integrity controls that support critical business processes. The Lead BSA will collaborate with various business and technology teams to understand their control needs and assist vendors in creating necessary documentation. The position requires a strong understanding of data as a strategic asset and a commitment to continuous improvement.

Responsibilities

• Serve as a liaison and knowledge source with stakeholders, product owners, and team members.
• Prioritize and sequence scope for the vendor SOW while coordinating across application teams.
• Coordinate with the Platform Administration team and impacted application teams for control build, warranty support, and a build to run transition.
• Create standards and best practices for control documentation.
• Communicate standards and ensure compliance.
• Review documentation for completeness and accuracy.
• Participate in the identification, quantification, and mitigation of project risks and issues.

Requirements

• Bachelor's Degree
• 7+ years of experience as a Business Systems Analyst in a Data Warehouse environment.
• 5+ years of experience creating source to target mappings.
• 1+ years of experience using SQL to create ad-hoc queries and analyze data.

Nice-to-haves

• Understanding of enterprise data warehousing best practices and standards.
• Strong data mapping experience creating source to target mappings.
• Detail-oriented and highly motivated with strong organizational, analytical, and problem-solving skills.
• Ability to effectively prioritize and execute tasks and handle multiple projects simultaneously.
• Excellent verbal and written communication skills.
• Experience leading other BSAs on a project team.
• Experience in the financial services (banking) industry.
• Experience with data governance and data management approaches, including data quality.
• Experience with building data integrity controls using custom build or vendor packages (Infogix, Data360, etc).
• Experience in data modeling activities in Erwin or other modeling tools.