Lead Business Systems Analyst EDW
Overview
You will own the Enterprise Data Warehouse (EDW) backlog, turning stakeholder needs into technical requirements for analytics and reporting. You will bridge business teams and data engineers, driving delivery of Snowflake, DataStage, and Python/PySpark solutions. You will also coordinate with QA to validate Infogix and Tableau outputs. Your decisions will shape data infrastructure used by executives. This hybrid role in Columbus puts you at the center of enterprise data strategy.
What You'll Do8
- 1Gather and document business requirements for EDW enhancements, translating them into user stories and acceptance criteria.
- 2Own the product backlog, prioritizing features with stakeholders and data engineering teams.
- 3Lead requirements elicitation sessions with business users to define data and reporting needs.
- 4Design data quality checks with Infogix to ensure accuracy of Snowflake models.
- 5Collaborate with developers on Python/PySpark pipelines and DataStage jobs to meet business rules.
- 6Validate Tableau dashboards and reports against requirements, sign off on releases.
- 7Drive data governance by aligning requirements with enterprise data standards.
- 8Support UAT and production rollout, resolving defects and clarifying edge cases.
Requirements8
- 17+ years as a Business Systems Analyst in data warehousing environments.
- 23+ years leading requirements for EDW initiatives with Snowflake and DataStage.
- 3Strong expertise in Python/PySpark for data analysis and validation.
- 4Hands-on experience with Infogix data controls and Tableau reporting.
- 5Proven track record managing complex backlogs and cross-functional stakeholder alignment.
- 6Excellent communication to translate business needs into actionable technical specs.
- 7Bachelor's degree in Information Systems, Computer Science, or equivalent.
- 8Experience in financial services or healthcare data domains preferred.
Salary Insight
Salary not disclosed in listing
Similar open positions
Explore active roles that match your skills and interests.
Tech Tandem Inc
VerifiedBusiness Systems Analyst - EDW (Data Warehouse)
You will own the full requirements lifecycle for the enterprise data warehouse at a major bank, working with business stakeholders to translate needs into technical specifications. You will join a dedicated EDW team, collaborating with data engineers and analytics teams to deliver data solutions. This role stands out as a lead position in a mission-critical data program, requiring deep expertise in SQL and ETL processes.
RICEFW Technologies Inc
VerifiedETL Data Architect Remote Ohio
You will design and implement the enterprise data architecture for a Columbus, Ohio-based organization, ensuring data integrity, scalability, and accessibility across all systems. You will define how data is stored, consumed, integrated, and managed, aligning with business objectives and technology standards. You will leverage modern cloud data platforms, including Snowflake, to support advanced analytics and business intelligence. Working fully remote, you will collaborate via Microsoft Teams with cross-functional teams to drive data strategy. This role offers the chance to own the data landscape end-to-end, from ingestion to consumption, in a data-driven organization.
Robert Half
VerifiedSnowflake Data Engineer, ETL & Pipeline Development
Owning the end-to-end data lifecycle in a lean team, you will design and build scalable pipelines in Snowflake and drive the migration away from legacy SSIS workflows. Reporting directly to business stakeholders, you will partner on architecture decisions and shape the long-term data strategy. With broad exposure across ingestion, modeling, and optimization, you will have immediate impact in a small, collaborative environment. This role stands out for its variety and the chance to modernize a cloud-based data ecosystem.
LTM
VerifiedSystem Management Specialist, ETL & Snowflake
You will own BAU operations and L2/L3 sustain support for the Customer Marketing Data Platform, handling ETL pipelines, Snowflake tasks, and automated monitoring at enterprise scale. You will work within a 24x7 rotational shift model with US EST overlap, partnering with onshore stakeholders during incidents and status reviews. The role demands deep troubleshooting across ServiceNow, AWS Lambda, CloudWatch, and Confluence runbooks, with a focus on proactive incident triage and root cause analysis. You will drive continual improvement of runbooks, SOPs, and KEDB entries, and contribute to problem management and post-incident reviews. This position offers exposure to Snowflake administration, Airflow DAG debugging, and dbt testing, with opportunities to shape the sustain state of a critical data platform.
Advanced Medical Management
VerifiedSenior Data Engineer, Snowflake & dbt
You own the enterprise data platform at Advanced Medical Management, a healthcare management organization serving provider networks. You design, build, and scale the Snowflake warehouse and dbt transformation layer that powers analytics for internal teams and external partners. You work with a small team of BI developers and report to the VP of IT, with direct influence over architecture and tooling. This role stands out because you drive the full lifecycle from data integration to governance, ensuring reliable data for decisions that impact patient care. You also lead the migration of legacy SQL Server processes to modern ELT pipelines on AWS.
STEM Talent Solutions
VerifiedIT Business Analyst JD Edwards EnterpriseOne
Own ETL pipeline development and scaling using Python and Spark. Lead cross-functional collaboration between business and IT teams. Drive system enhancements and implementations. Scale solutions to meet organizational needs. Differentiate by combining technical expertise with domain knowledge.