Business Warehouse Support Analyst Job in Vancouver, British Columbia Canada
On behalf of our client in Burnaby, Ignite Technical Resources is looking for a Business Warehouse Support Analyst. This will be a long-term contract position.
The BW Analyst will be working alongside the development and project management teams to provide support and expertise on the Business Warehouse Platform.
REQUIREMENTS:
- Provide technical support and development expertise for Business Warehouse Platform including Integrated Planning (BI IP).
- Cross module reporting in the areas of HR, Payroll, Time Entry, Benefits, Personnel Administration, Organization Management, Finance, Controlling, Funds Management, Asset Accounting, Project System, Plant Maintenance and Real Estate.
- Deliver reports through the portal using web templates.
- Support multi-cubes to consolidate information across modules.
- Assist with the management of departmental budget process using the BI-IP solution.
- Provision of data to Business Objects reports which sources data through BEx queries.
- Administration of the extraction, transfer and load processes of data from the ERP system to the BW system.
- Design, create, maintain and monitor InfoPacks and DTPs.
- Design, create, maintain, schedule and monitor process chains.
- Runtime analysis of BW processes.
- Analysis of background jobs, debugging of DTP requests, BW statistics, and SQL trace analysis.
- On demand and periodic preventative refresh of cubes and PSAs.
- Optimize the performance of cubes, DSOs and DTPs to service business requirements.
- Activate BW Content.
- Monitor query usage by end users.
- Develop BEx reports. Develop web templates using Web Application Designer.
- Expertise in ABAP development is helpful, but not mandatory.
- Clarify the master data set up, configuration and integration strategies to develop tightly integrated solutions.
- Facilitate workshops, document any required changes, confirm scope, prepare documentation to support changes and execute on requirements.
QUALIFIATIONS:
- BS degree and 8+yrs of experience, or MS and equivalent professional work experience
- 4+ years of experience coding and administrating an ETL tool such as BusinessObjects Data Integrator/Services (BODI), Informatica, or Ascential
- 4+ years of experience with database modeling for the purpose of reporting, including relational and dimensional modeling exposure
- Expert SQL skills (Oracle PL/SQL or MS TSQL), including stored procedure programming
- Experience in systems analysis is required
- Foundational knowledge in Windows 2003/2008 Server, MS SQL Server tuning, MS Analysis Services, TCP/IP, and x86 hardware
- Prior experience with a BI tool (implementation, reporting, administration) such as OBIEE, Cognos, BusinessObjects, Brio, or Crystal is desirable
- Prior experience with developing ETL standards is desirable
- Data Quality and Profiling exposure is desirable
- Basic project management skills
- Excellent written and verbal communication skills
If you meet the required criteria and are interested in the above position, please submit a Word version of your resume HERE!
**Due to the volume of resumes, only those candidates being considered will be contacted.
Ignite. Wired for people.
We get it.
We get technology. We get people. We get you don’t want cyborgs taking over the office and running the show. When there‘s a problem, everyone wants the right person for the job. The kind of person who is brilliant, efficient, technically savvy and who can communicate with everyone else. We know these kinds of people.
Ignite Technical Resources is a Vancouver-based Information Technology resourcing firm built around three principles: speed, efficiency and quality. We provide highly trained and qualified technical consultants to your organization as a flexible work force option. Our consultants will help you through workload fluctuations and can manage outsourced projects of any size.
You have greater day-to-day issues to manage. Ignite will solve your immediate IT needs with little delay or effort. It’s what we do best.
We’re wired for people.
Follow Ignite on Twitter @ignitetechnical and become a fan on Facebook for up-to-date information about our company including job postings! To see other IT job postings, visit our Website!
Open all references in tabs: [1 - 4]