Senior Associate, Solution Analyst Data Warehousing

Responsibilities: Lead complex requirements analysis and design for data warehousing, integration, and BI initiatives, creating specs, user stories, and mappings Evaluate solution options with stakeholders and propose scalable approaches aligned with enterprise architecture and governance Facilitate cross-functional discovery and design discussions, resolve conflicts, and build stakeholder alignment Coordinate initiatives from intake to delivery, using AI-enabled tools to improve efficiency and manage risks Use SQL and analytics to investigate data issues, assess source systems, and validate transformations Serve as a technical and functional resource for engineering teams and clarify requirements Lead requirements validation and solution acceptance against business objectives Suggest improvements to analysis, requirements management, and delivery processes with AI-assisted methods Provide knowledge sharing and promote consistent team practices

Key requirements: Significant experience in solution analysis or related IT delivery roles, including cross-functional initiatives Advanced ability to translate business needs into functional/technical specs, user stories, and mappings Deep knowledge of data warehousing, data integration, pipelines, and BI with governance considerations SQL expertise for data investigation and transformation validation Ability to assess solution options, dependencies, and approaches to complex problems Experience leading discovery sessions and influencing stakeholder alignment Strong understanding of Agile delivery and backlog management Independent judgment to resolve complex challenges with limited guidance Hands-on experience with AI-assisted development tools like GitHub Copilot or Claude Code Strong analytical, communication, problem-solving, and stakeholder management skills Communication Stakeholder management Collaboration Data warehousing Data integration SQL