Business Analyst with SQL

i-softcorp is seeking a Senior Technical Business Analyst to bridge business stakeholders and data engineering teams. The role focuses on translating business requirements into scalable Medallion architecture data solutions, documenting data lineage and mappings, validating data quality, and using Snowflake and AI tools for analysis and process improvement.

Responsibilities:

• Act as the primary liaison between business stakeholders and the data engineering team, ensuring requirements are understood, documented, and delivered accurately
• Translate business requirements into scalable data solutions aligned with Medallion architecture principles (bronze, silver, gold layers)
• Lead requirements gathering sessions with business and technical stakeholders, converting ambiguous needs into clear, actionable specifications
• Develop and maintain source-to-target mapping documentation for data pipelines and models
• Analyze and document data lineage to support transparency, governance, and troubleshooting across the data ecosystem
• Partner closely with Data Architects on data modeling decisions, ensuring models reflect business needs and support downstream analytics
• Define and validate data quality rules, and support ongoing data validation efforts
• Write and run Snowflake queries to validate data, troubleshoot issues, and support root-cause analysis
• Leverage AI tools to accelerate data discovery, metadata analysis, and requirements gathering, and to continuously improve team processes and ways of working
• Quickly develop domain and business knowledge to understand the data environment and speak credibly to both business and engineering audiences