Consultant Tail Vendor Tranche 4

Pittsburgh, PA, United States (On\-site) Contract (5 months 1 day) Published 12 hours ago technical documentation dependency management Business Analysis SQL defect management project management oracle database agile methodology Quantitative Analysis * Drive performance analysis and optimization of SQL queries Oracle Snowflake troubleshoot complex data and systems issues and lead root cause analysis for data quality * Partner with technology and business stakeholders to define requirements functional specifications and operational architecture for strategic global programs Provide input to data strategy and actively influence software development process improvements **Key Responsibilities:** * Analyze optimize and benchmark SQL queries across Oracle and Snowflake diagnose and resolve highly complex performance and data quality issues through rigorous root cause analysis * Collaborate with Universal Client Manager technology teams to define specifications design documents and functional use cases for system enhancements and integrations * Elicit challenge and prioritize business requirements using standard processes and templates translate requirements into clear functional designs user stories and use case documentation * Develop project scope objectives constraints and assumptions for large strategic multiyear initiatives ensure alignment to business outcomes and operational architecture * Provide consultation to IT and business management oning technology to business opportunities plan and guide implementation of cross functional applications and systems * Participate in and provide guidance on technical design reviews test planning and user documentation ensure end to end traceability from requirements through testing and release * Manage scope changes and dependencies using formal requirements management principles including change control traceability and stakeholder signoffs * Gather and analyze quantitative and qualitative data to develop recommendation