Job Information Data warehouse/Business Intelligence Analyst Company Information
Contact Name Empower Professionals
Contact Email
Since 06/16/2010
Job Information
Job Type Consultant
Duration 6 months
Category Computer/IT
Career Level
Work Permit
Duration of Position
Posted 07/09/2015
Minimum Education University
Degree Title
Required Travel
Job Status
Job Status Interviewing
Start Publishing 07/09/2015
Stop Publishing 07/09/2024
[VernonHills,United States ]

Interview process will be phone then in person


The DWH/BI Analyst role leads business and functional requirements gathering activities, business solution design and systems analysis. This role also designs, documents, measures and optimizes key business processes. This DWH/BI Analyst is guided by project management methodology in development of requirement specifications for organizational projects. 



  • Collaborate with stakeholders to clarify project requirements and business objectives, establish scope, select appropriate analytical methodologies, set expectations for reporting or analysis deliverables in order to successfully address business issues and acquire commitments.
  • Develop best practices for data loading and extraction into and out of the data warehouse.
  • Plan, design, schedule and coordinate data warehouse analysis, design, development, and deployment.
  • Decompose business problems quickly and work with the project team to determine the root cause and provide solution alternatives.
  • Derive a detailed understanding of the stated business problem and objectives and work with the stakeholder and technical team toward resolution to achieve the objectives.
  • Plan and facilitate requirements gathering utilizing focus sessions, one-on-one interviews, and job shadowing.
  • Utilize advanced modeling techniques to develop high-level system narratives, presentations, storyboards, use cases and user interface prototypes.
  • Work with QA team to develop system test plans, ensure software quality assurance (SQA) standards are achieved, and validate that business goals are accomplished.
  • Serve as a conduit/broker for cross-functional collaboration & knowledge sharing.
  • Perform quantitative & qualitative analysis to help justify the investment necessary to deliver a solution.
  • Gather and prepare supporting analysis and design documentation from a business perspective.
  • Assist with alignment of project objectives and solutions to organizational business strategies and objectives.
  • Act as an active contributor to process improvement by remaining current in software engineering best practices.
  • Serve as an active contributor to company-shared knowledge repositories (wikis, blogs, sharepoint, intranet, etc.).
  • Mentor and educate IT and business colleagues about business analysis discipline and requirements phase within development lifecycle. 
Preferred Skills

Required Skills:

  • 10+ years of IT experience
  • 5 - 7 years of work experience in an analytical Data Warehouse/BI position
  • Working knowledge of data processing fundamentals including entity relationship diagrams, database models, structured application design and IT infrastructure (networking and hardware).
  • Expertise in requirements gathering software, data mining tools, Microsoft Office applications, as well as CA Clarity.
  • Working knowledge of SQL, MDX and/or other database query language(s)
  • Working knowledge of presentation-layer BI applications (e.g. Cognos, Pyramid Analytics)
  • Knowledge of current relational database software and related hardware.
  • Knowledge of data warehousing and modeling methods, techniques, standards and procedures.
  • Knowledge of relational database and query concepts.
  • Skilled in researching and analyzing user data and data warehouse systems.
  • Skilled in organizing and using a data warehouse.
  • Previous work as experience in a business analyst capacity.
  • Demonstrated ability to effectively communicate data warehouse operations to technical and non-technical users.
  • Demonstrated work experience in process definition including facilitation, process documentation, change control, and process improvement.
  • Experience in evaluating information, identifying risks and opportunities, while possessing creative problem solving skills with an understanding of business concepts and models.
  • Proven elicitation and facilitation skills of project and system requirements.
  • Demonstrated negotiation and persuasion skills, with the ability to enable win-win resolutions.
  • Excellent written and verbal and communication skills with the ability to effectively interact with all stakeholders
  • Bachelor’s degree in Business or an IT related field.


Preferred Skills:

  • Masters degree in Business or Advanced Information Technologies
  • Familiarity with cost/benefit and ROI data analysis.
  • Industry Certifications (PMP, CBAP, Six Sigma). 
Share on Google+ Twitter Share on facebook