Business/Data Analyst

 Interview: Phone and F2F

VW Credit 

Description:

Must have good comm skills and strong DW experience


POSITION PURPOSE:
 
The Business Systems Analyst (BSA) is an integral role responsible for supporting one or more key business functions through the successful implementation of technical solutions.  This person will provide expert level business knowledge while performing detailed requirements gathering and definition, process analysis/improvement, IT system analysis and design, user acceptance facilitations, vendor system evaluations, strategic vision, and best practice recommendations.
 
The position serves as a senior liaison between the business and IT groups.  The BSA works on large, complex projects that have enterprise-wide impact and may require subject matter expertise of multiple areas and processes.  This person can work simultaneously as a project team member on several projects to facilitate solutions involving multiple sites and/or business areas. The BSA also helps to coach and mentor the Business Analyst staff.
 
POSITION RESPONSIBILITIES:
 
Consult with the business to identify and document the business partner's functional and data requirements based on a business process description to ensure that the final deliverable coincides with the context of the business operations
Utilize structured interview techniques to identify, analyze and document business requirements and priorities
Document objectives, use cases, requirements and specifications
Produce and maintain diagrams of business processes and system workflows
Create documentation describing solutions to achieve requirements according to established guidelines and standards
Evaluate the design of existing systems, identify obstacles or flaws and lead research to identify effective solutions
Assist the Project Manager with business owner relations
Act as a liaison between business users and technical teams
Leverages an understanding of multiple data structures and sources to perform complex data analysis using advanced data extraction and analytical tools and techniques
Facilitate the design of complex solutions
Participate in and support the full project life cycle (initiation, planning, requirements, analysis, design, development, quality assurance, user-acceptance testing, deployment, and production support)
Work with the Project Manager to analyze, plan, communicate and coordinate assigned projects in areas such as feasibility, package review, time and cost estimation, work plan creation and management, business requirements, testing, documentation, training and implementation
Develop strategic partnerships with IT and business management
Develop an understanding of the business units' goals and processes
Provide functional support for assigned applications and/or products
Assist in the development and execution of test plans
Produce project documentation according to approved guidelines and standards
Address and escalate issues promptly and properly
Analyze trends and make recommendations to identify process improvement opportunities through the use of technology
Conduct and coordinate reviews of completed analysis projects
Occasional travel may be required
Perform other duties as required
REQUIRED QUALIFICATIONS
 
Education
 
B.S., B.A. in Marketing, Management, Business Administration, Accounting, Finance or Computer Science, or equivalent job experience.
Experience
 
Strong experience with business system analysis in a complex data warehousing environment running on UNIX or Windows platform.
Comprehensive knowledge of and experience in creating and executing SQL queries across various RDBMS platforms for the purpose of data analysis.
Demonstrated success in the probing, collection and documentation of functional and technical requirements
Full software development life cycle experience required, preferably in multi-tier, database environment (Oracle or SQL)
Possesses extensive knowledge and experience in leveraging both IT solutions and business process improvements
Intermediate knowledge of data governance, integrity, quality and audit functions (such as UNIX security, Informatica Metadata Manager, etc.)
Demonstrated knowledge of project management life cycle and hands-on experience and proficiency using full project life-cycle methodologies and tools
Behavioral traits that exhibit team orientation, leadership, interpersonal communications, flexibility, positive attitude, adaptability, customer-supplier responsiveness, systemic thinking and appreciation for detailed work
Strong analytical skills, creativity and a working understanding of Information Systems
Strong knowledge of MS Office Suite products
Solid data warehouse requirements-gathering experience
Experience in financial services operations with a strong, well-rounded automotive business background is preferred
Intermediate knowledge of data extraction techniques and applications
Skills
 
Ability to work across multiple organizations
Ability to work on several projects simultaneously
Ability to communicate effectively with team members, peers, and senior management
Ability to think in a creative and innovative manner to create appropriate and efficient solutions
Ability to lead a team in defining effective technical solutions to business requirements, and collaborate with business partners in defining future innovations
Ability to Project Manage smaller projects
Excellent interpersonal communication skills (both written and verbal); ability to communicate and present to a wide variety of audiences, both business and technical
Above average technical skills to facilitate communication with the technical team members and data analysis
Solid prioritization and project management skills including schedule development, assessment, and management reporting
Ability to build relationships and partnerships, achieving results through influence, persuasion and the leveraging of these relationships
Positive customer service orientation and responsiveness
Certified Business Analysis Professional (CBAP) preferred
Key Skills:
 
Significant experience gathering requirements for Data Warehouses or Operational Data Stores
Working knowledge of data warehousing concepts
Strong SQL skills and past experience creating complex queries against Oracle and SQL Server databases for analyzing and profiling source data
Familiarity/past experience with ETL tools, preference on Informatica PowerCenter
Experience with gathering requirements for business intelligence reports (less critical, but nice to have)
Understanding of/past experience using business intelligence tools, preferably BusinessObjects (less critical, but nice to have)