Business Intelligence/DW Technical Consultant

ROSS; Old Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

Join a leading business intelligence firm known for its innovative analytics solutions. In this role, you'll leverage your programming and analytical skills to develop core application components, focusing on BI and ETL processes. You'll work collaboratively with clients and internal teams, ensuring that solutions meet business needs while maintaining high quality standards. This position offers a dynamic environment where you can grow your expertise and mentor others, all while contributing to impactful projects that drive change in the industry. If you're passionate about technology and eager to make a difference, this opportunity is for you.

Qualifications

• Minimum 3 years of applications development consulting experience.
• Proficiency in SQL and Java, with knowledge of ETL software.

Responsibilities

• Translate client business requirements into technical solutions.
• Participate in application design and architecture.

Skills

SQL

Java

ETL Software

Data Warehousing

Oracle

DB2

Microsoft SQL Server

Unix Shell Scripting

BI Tools

Problem-solving

Tools

Cognos

Hyperion

SAS

Business Objects

MicroStrategy

Job description

Our client is a leader in business intelligence and analytics. Their software provides one integrated process for analyzing data from every source and gaining the predictive power to drive change at every level. This is your chance to join this great organization which has been included on Fortune's list of the "100 Best Companies to Work For" for seven straight years.

You will provide programming and analysis expertise for applications on multiple projects concurrently. You’ll interact with other consultants, group managers, and with external customers.

Travel requirement is up to 25%.

You will:

Understand and translate client’s business requirements into workable technical solutions.

1. Participate in application design and architecture.
2. Plan and develop core application components, with an emphasis on BI and ETL.
3. May write new or revised programs using techniques such as: Web, SCL, Frames, Object Oriented Techniques, or data management as applicable.
4. Install and configure technology and solutions.
5. Complete all levels of application testing and QA.
6. Prepare all required documentation (specifications, design, system, training, user).
7. Install and configure our client's software as required.
8. Ensure up-to-date knowledge in industry business and technology solutions, through self-motivated approach to continuous learning.
9. Provide presentations, internally and/or with clients, as required.
10. Mentor other consultants as required.
11. Other duties as assigned.

You have:

1. Minimum 3 years applications development consulting experience with external clients, in competitive situations (independent software vendor company or Big4 consulting).
2. Knowledge of and experience with:
1. Databases including one or more: Oracle, DB2, Microsoft SQL Server, Informix, Sybase.
2. A breadth of operating systems (Windows, Unix, Linux, mainframe) and platforms (IBM, Sun, HP, Windows).
3. Client server, and multi-tier environments.
4. Connectivity issues and protocols.
5. Job scheduling and event/exception management.
6. Security, file systems, and common network practices.
7. One or more of: BEA Weblogic, Websphere, J2EE, web development.
8. Metadata management and XML.
9. ETL software (any flavour such as Informatica, AbInitio, etc).
3. Proficiency in SQL and Java.
4. Data Warehouse/Mart knowledge and experience is preferred, including knowledge of common industry approaches including star schema and ‘corporate information factory’.
5. Knowledge of Unix shell scripting.
6. Experience with BI products and tools (e.g., Cognos, Hyperion, SAS, Business Objects, Information Builders, MicroStrategy, CRM, etc).
7. Demonstrated excellent problem-solving skills.
8. Excellent written, verbal and interpersonal communication skills.
9. Ability to work independently and with a team.

If you're not interested, but know someone who is, please help a current or former colleague in their career development by referring them. In addition, we're happy to give you a $750 referral fee. Click http://www.getROSS.com/referral_fee.php for more details.

Click here to apply online