Business Technical Analyst
The MCD IT Business Intelligence Operations team has an exciting opportunity for a Sr Business Technical Analyst. With supervision this position defines the business requirements and builds process and data models for technology solutions that meet the business needs. Bridges the gap between the business customer and the technology solution providers by translating business needs to technical solutions throughout the lifecycle of the product. Coordinates and/or executes plans to ensure that technical solutions meet the needs of the business. Key customers include users of the I/S solution, the project development team and project sponsors.
You will have extensive experience in a data warehouse environment facilitating requirements gathering sessions, documenting requirements, analyzing and evaluating possible solutions to meet requirements. Experience in leading QA processes including creating test strategy and test plan documents as well as executing tests and working with external QA vendors. The candidate will be a highly organized self-starter who thrives in a dynamic and fast-paced environment.
- Teradata
- MicroStrategy
- Tableau
- DataStage
- RedShift
- Confluence
- Jira
- Excel
- AWS Cloud
- Ability to grasp technical concepts quickly.
- Ability to adapt to and understand new products and applications
- Ability to understand & analyze complex data concepts and calculations
- Excellent verbal and written communication skills and the ability to communicate technical information to non-technical audiences
- BA/QA
- Strong background in writing SQL code
- Leading individual(s) or sub project tasks affecting single or multiple business and IT departments
- Evaluating project impact through consultation with the business
- Supporting and performing testing as necessary to ensure original requirements are met
- Experience in gathering end user requirements and documenting accordingly
- Ability to translate business requirements into technical specifications
- Experienced in writing test plans and scripts
- Proficient in Excel
- Extensive experience in writing SQL code
- Experience in building test plans and scripts
- Experience in executing test scripts
- Experience in defect management/resolution
- Strong experience in Excel/Jira and Confluence
- Minimum of 2-5 years working in a data warehouse environment
- Bachelor’s degree - Business or IT
- Ability to work on multiple simultaneous projects
- Strong communication skills
- You can work independently and within a team environment.
- Previous experience in a client-facing role with ability to build rapport
- Ability to read, develop and test advanced SQL statements
- Data modeling experience
- Experience preparing advanced report designs
- Strong analytical skills and ability to focus on details as well as the big picture
- Experience identifying project tasks and providing estimates for those tasks
- Experience in executing training strategies
- Proven ability to adhere and promote standard business analyst tools, procedures and SDLC/AGILE best practices
- Utilize project management skills to ensure work streams are properly identified and prioritized, resources utilized, time lines met and provide consistent status updates.
- Serve as functional business area team’s main point of contact for IT with any critical system performance issues. Communicate issues impacting daily operations to the business team and provide updates on resolution.
- Review current business processes to determine where automation / improvements will drive efficiency.
- Partnering with cross channel teams to identify opportunities and supporting the development of new sustainable solutions.