Senior Business Technical Analyst
Job Description
The MCD IT Business Intelligence Operations team has an exciting opportunity for a Business Analyst / Business Technical Analyst. With supervision this position defines the business requirements and creates 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.
Responsibilities
The ideal candidate 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 managing QA processes including creating test strategy and test plan documents as well as executing tests and working with external QA vendors. The candidate must be a highly organized self-starter who thrives in a fast-paced and rapidly changing environment.
Minimum Requirements
Required Experience
·Minimum of 3-6 years working in a data warehouse environment
·Bachelor’s degree - Business or IT
·Ability to work on multiple simultaneous projects
·Excellent communication skills
·Must have the ability to work independently and within a team environment.
·Experience working in a client-facing role with the ability to build strong relationships
·Ability to read, develop and test advanced SQL statements
·Data modeling experience
·Experience preparing advanced report designs
·Strong problem-solving 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
·Demonstrated ability to adhere and promote standard business analyst tools, procedures and SDLC best practices
Preferred Skills and Experience:
·Teradata
·MicroStrategy
·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
·Strong problem-solving skills and ability to focus on details as well as the big picture
·Excellent verbal and written communication skills and the ability to communicate technical information to non-technical audiences
BA/QA
·Experience working in a data warehouse environment
·Strong background in writing SQL code
·Experienced in working with data models to understand data relationships and to aid in creating SQL queries
·Experienced in working with business users to gather and document requirements
·Ability to translate business requirements into technical specifications
·Experienced in writing test plans and scripts
·Highly experienced in Excel
QA
·Experience working in a data warehouse environment
·Strong background in writing SQL code
·Experience in working with data models to understand data relationships and to aid in creating SQL queries
·Experience in writing test plans and scripts
·Experience in executing test scripts, including documentation of test results
·Experience in defect management/resolution, including documentation of defects and regression testing
·Highly experienced in Excel