[email protected]

Business Analyst

We are looking for an experienced Data Warehouse Business Analyst to work in a dynamic, fast paced environment. The consultant will manage Business Analysis as part of an overall project team, deliver project artifacts, interface with clients, and deliver high quality Business Intelligence solutions.

Requirements and responsibilities include:

- Facilitates discussions with Project Sponsor, Stakeholders and Key Users to gather business and process flow requirements.
- Conducts interviews and work sessions with key users and translates results into the appropriate documentation
- Analyses and documents business processes and formulates the Business Problem definition.
- May document proposed business processes.
- Identifies current systems and tools leveraged by business users.
- Assists the Project Manager in Risk Analysis and mitigation planning.
- Prepares the Business Requirements Document (BRD).
- Participates in the Presentation of Concept to gain acceptance by user population and obtain sign-off from Sponsor and Stakeholders.
- Provides input in the preparation of the target Data Models and performs data analysis.
- Assists the business in finalizing User test cases
- Reviews preliminary Test Plan and makes revisions accordingly.
- Supports the Application Team by being the functional 'go-to' person for resolving business related issues / decisions. Works closely with business stakeholders to resolve issues.
- Leads the preparation, test execution and verification of project components

Required skills:

- Experience as a Business Analyst in an Enterprise level Data warehousing environment
- Ability to quickly understand the business and the related processes
- Client facing skills are a must.
- Risk analysis experience
- Excellent communication skills
- Ability to interact with outside clients and customers
- Ability to work in high-paced outside the box problem solving environment

Senior IT Project Manager

We are looking for experienced, PMI certified Senior Project Manager in the software development area. The ideal candidate will:

• Solid Communication skills and an understanding on mediation and driving to consensus
• Understand the concepts of client management and team building
• Be a team leader in determining customer requirements and translating requirements into operational plans
• Ability to leverage multiple delivery models and geographically dispersed teams
• Determine, monitor and review all project economics to include project costs, operational budgets, staffing requirements, project resources and project risk
• Ensure adherence to customer long-term strategic goals, project charter and contracts
• Meet with customers to review project scope/progress and resolve project issues
• Coach and counsel members of cross-functional teams to accomplish projects, meet established schedules or resolve technical/operational issues
• Develop, propose and negotiate project proposals, quotations and add-ons to leadership and/or the customer
• Be innovative and ready to learn new methods of client breakthrough
• Stay current on emerging technologies and project management techniques

Qualifications

• College/University education and 10 years Project Management work experience or equivalent combination
• Proven track record of managing projects and successfully implementing and managing formal quality processes in projects
• Large project exposure and/or previous consulting experience
• Understands and is able to apply systems development life cycle principles, concepts and techniques on related projects
• Excellent communication (verbal and written), presentation, training and leadership skills
• Experience in the Telecom, Retail or Financial Services is an asset

IT Hiring Trends

A great article from DM Review discusses trends in IT hiring based upon some information from Robert Half.

In the article they highlight a couple things of immediate relevance to Project X.

1. Net hiring growth in Q2 due to business demands.
2. Areas of growth are in common areas with common skill-sets

The second point as indicated is of interest to us as these are not generally the skill-sets we are looking for.  We will be looking for more specific less widely taught skills.  So this means, that if the skills don't exist we are going to have to build them.  And guess what, that is our plan.

Welcome to the new Blog

Project X has been growing as of late and we need some good people.

In an effort to evolve our HR and Recruiting efforts we have launched this blog.  So welcome.  We plan to use this space to talk about general items of interest to people who work in our industry.  Within that realm we will show people what we are about and the opportunities in joining Project X.

Data Warehouse Consultant

Job Duties and Responsibilities

• The Data Warehouse Specialist is responsible for the design, development, performance, documentation, maintenance, support and operation of the Enterprise Data Warehouse; and, the documentation, maintenance, support and administration of Informatica software.
• Implement corporate policy; develop, publish, enforce and maintain standards and procedures.
• Manage the Informatica environment and the granting of access to data; perform administrative functions.
• Participate in EDW scope discussions and comment on feasibility.
• Create and maintain EDW data model and metadata.
• Identify and document data access and usage requirements with access frequencies.
• Participate in the design of Oracle structures.
• Design, develop and test ETL coding specifications, processes and documentation.
• Promote changes via established IT change control procedures.
• Proactively tune to improve performance.
• Plan, test and implement software upgrades; monitor alerts; administer licenses; interface with vendor.
• Remain current with industry, Informatica and Oracle direction; evaluate new technologies and product features; make recommendations as to how client can benefit.
• Coach and oversee Developer tasks.
• Troubleshoot problems; provide problem resolution assistance to IT staff.
• Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff.
• Investigate, identify and document source system data for extraction; design and implement confirmation processes for data loads.
• Monitor daily operation relative to SLA; log issues and ensure resolution.
• Strong analytical and problem-solving skills.
• Ability to multi-task and work at a detailed level in a fast-paced environment.
• Superior working knowledge of PowerCenter and PowerAnalyzer products and coding languages.
• Very good working knowledge of relational database technology, preferably Oracle, and the SQL language.
• Very good knowledge of data modeling in a data warehousing context.
• Good oral and written communication.
• Knowledge of ERWin, ODBC, Java, C/C++, HTML, XML and UNIX.
• Some experience with managing small development projects.
• Availability to carry a 24x7 production support pager on a scheduled basis.

Skills, Education, Knowledge and Experience

• Adaptable and innovative Team Player who collaborates and brings leadership and drives results

• Customer Focus

• Completion of a college or equivalent post secondary degree.

• 5+ years of data warehousing experience.

• 3+ years of ETL design and coding experience.

• 3+ years of SQL coding experience, with DB2, Oracle or Teradata.

• 5+ years of application development experience with at least 2 in a senior capacity.

Nice to have skills

• Teradata, Oracle or DB2
• Understanding of the Capability Maturity Model or ITIL

To apply email your resume to [email protected]
To learn more about Project X visit our Corporate Blog or Website

Data Integration - ETL / ELT

Job Duties and Responsibilities

• Analyze, design, develop, test and document ETL/ELT programs from detailed and high level specifications, and assist in troubleshooting
• Utilize SQL (DB2, Oracle, Teradata), Korn shell, Perl, Java, C or Unix Scripts to perform tasks other than data transformation
• Assist in the requirements analysis and subsequent development and testing
• Conduct unit tests and assist in test preparations to ensure data integrity
• Work with Designers, Business Analysts and other Developers as a team
• Report to and work with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
• Design and implement technical enhancements to the Data Warehouse as required

Skills, Education, Knowledge and Experience

• Solid knowledge and experience with SQL, UNIX, Korn shell, C, RDMS (DB2, Oracle, Teradata) and Data Warehousing
• Understanding data warehouse architecture with a dimensional data model
• Strong analytical skills
• Good communication skills
• Interest and ability to learn new ETL tools
• Computer Science degree or diploma

Nice to have skills

• Experience with any ETL tools such as Informatica, DataStage, MetaStage, Sunopsis and AbInitio
• Data modeling, ERWin
• Java, C++
• Financial, Telco or Retail industry experience

To apply email your resume to [email protected]
To learn more about Project X visit our Corporate Blog or Website