Heitmeyer Consulting
Lead Business Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Lead Business Systems Analyst to support an Enterprise Data Warehouse (EDW) in a hybrid location (Columbus, OH). Contract duration is 3+ months, with a pay rate of "unknown." Key skills include SQL, Snowflake, and data mapping.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 27, 2026
🕒 - Duration
3 to 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Columbus, Ohio Metropolitan Area
-
🧠 - Skills detailed
#Stories #Business Analysis #Data Analysis #Scala #Data Mapping #AWS (Amazon Web Services) #Leadership #Data Warehouse #Agile #PySpark #Spark (Apache Spark) #AWS S3 (Amazon Simple Storage Service) #S3 (Amazon Simple Storage Service) #EDW (Enterprise Data Warehouse) #Snowflake #DataStage #Data Modeling #ERWin #Tableau #Python #SQL (Structured Query Language)
Role description
Lead Business Systems Analyst (EDW)
Summary
We are seeking a Lead Business Systems Analyst to support anEnterprise Data Warehouse (EDW). This role partners with business and Agile teams to translate data needs into scalable solutions, enabling the bank to leverage data as a strategic asset. You’ll drive requirements, data mapping, and backlog management across modern EDW technologies including Snowflake, IBM InfoSphere DataStage, Python/PySpark, Infogix, and Tableau.
Location: Hybrid – Columbus, OH (4 days onsite)
3+ month contract with potential to extend/convert
Key Responsibilities
• Act as liaison between business, Product Owner, and Agile team.
• Gather and document requirements, including source-to-target data mappings.
• Create and refine Epics, Features, and User Stories; manage and groom the backlog.
• Facilitate backlog refinement, define acceptance criteria, and support estimation.
• Partner with teams to resolve blockers, manage risks, and ensure delivery readiness.
Qualifications
Required:
• Bachelor’s degree
• 7+ years as a BSA in a data warehouse environment
• 3+ years of SQL for data analysis
Preferred:
• Financial services experience
• Expertise with Snowflake, AWS S3, and data modeling tools (e.g., Erwin)
• Strong data mapping and EDW best practices experience
• Proven leadership, communication, and problem-solving skills
Lead Business Systems Analyst (EDW)
Summary
We are seeking a Lead Business Systems Analyst to support anEnterprise Data Warehouse (EDW). This role partners with business and Agile teams to translate data needs into scalable solutions, enabling the bank to leverage data as a strategic asset. You’ll drive requirements, data mapping, and backlog management across modern EDW technologies including Snowflake, IBM InfoSphere DataStage, Python/PySpark, Infogix, and Tableau.
Location: Hybrid – Columbus, OH (4 days onsite)
3+ month contract with potential to extend/convert
Key Responsibilities
• Act as liaison between business, Product Owner, and Agile team.
• Gather and document requirements, including source-to-target data mappings.
• Create and refine Epics, Features, and User Stories; manage and groom the backlog.
• Facilitate backlog refinement, define acceptance criteria, and support estimation.
• Partner with teams to resolve blockers, manage risks, and ensure delivery readiness.
Qualifications
Required:
• Bachelor’s degree
• 7+ years as a BSA in a data warehouse environment
• 3+ years of SQL for data analysis
Preferred:
• Financial services experience
• Expertise with Snowflake, AWS S3, and data modeling tools (e.g., Erwin)
• Strong data mapping and EDW best practices experience
• Proven leadership, communication, and problem-solving skills
