Data Warehouse Project Manager

CATCH Intelligence is a Business Intelligence, Reporting, Analytics, and Data Warehouse consulting firm based in the Midwest. We help business transform raw data into information, information into knowledge, and knowledge into plans that drive profitable action! Data Warehouse Project Manager We are looking for a data warehouse project manager to lead Data Warehouse and BI projects, which includes managing the project team, facilitating requirements gathering sessions with business and technical users, reviewing source system layouts and schemas, analyzing the requirements and creating a comprehensive strategy and roadmap to meet our client’s business needs, including project plans, release plans, staffing plans, status updates, change control processes and customer presentations on project and budget status. This individual must have strong, proven data warehouse experience, including taking data warehouse projects from the analysis, envisioning and design phases, to a full lifecycle Data Warehouse implementation. Previous Agile experience is also a requirement for this position. Essential Duties and Responsibilities: Lead activities around requirements gathering, data analysis, profiling, extraction, validation, data modeling transformation and integration with data from multiple disparate sources. Provide means for ensuring data quality and integrity is intact. This position will work closely with clients and end-users to examine existing processes and develop automated solutions, including specifying program and project plans. Must be a team player that integrates well with the CATCH and client teams.

Work with Business users to gather requirements in different forms including: facilitated interview sessions, reverse engineering existing reports, JAD (Joint Application Developer Sessions, etc.).

Act as technical lead to assess client’s current state environment and offer estimates and recommendations for a full data warehouse implementation, including detailed project plans, staffing plans and release plans

Manage both client and internal project teams on long term implementation projects

Provide Data Warehouse and Business Intelligence subject matter expertise and leadership

Previous experience in managing projects with Agile/Scrum methodology

Transform Business requirements into functional Data Warehouse design requirements, including the data warehouse data model (logical and physical)

Ensure common application architectural framework across different subject areas and conformance with best practices

Consult with key individuals across multiple projects regarding the usage and application of Business Intelligence and Data Warehousing architectural standards and processes, including Data Governance processes

Oversee the Design and Develop of logical and physical data models to meet approved business requirements

business and technical SME’s to implement ETL architecture and processes

Work with business and technical SME’s to implement data quality and data governance processes

Evaluate, recommend and implement Business Intelligence Tools to meet technical and business requirements

Work on internal projects with CATCH team

Assist CATCH Project Management team in developing best practices and tools for project execution and management

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Ability to establish and maintain effective working relationships with clients, project team members, supervisors, and employees from other departments.

Prior agile implementation experience for building a Data Warehouse environment is required

Prior experience with evaluating, recommending and implementing Data Warehouse and Business Intelligence Architectures and Tools to meet technical and business requirements is required

Strong knowledge and hands on experience development data warehouse data models - such as Inmon and Kimball is strongly desired.

Strong understanding of logical and physical data models required

Experience at working both independently and in a team-oriented, collaborative environment is essential.

Ability to readily adapt to shifting priorities, demands and timelines through analytical and problem-solving capabilities.

Ability to read communication styles of team members and contractors who come from a broad spectrum of disciplines.

Ability to elicit cooperation from a wide variety of sources, including upper management, clients, and other departments.

Ability to defuse tension among project team, should it arise. Excellent conflict resolution skills is required.

Strong interpersonal skills.

Must be able to learn, understand, and apply new technologies.

Ability to effectively prioritize and execute tasks in a high-pressure environment is crucial.

Strong understanding and experience with designing ETL architectures and development is a strong plus

Knowledge of SQL Server a strong plus

Hands on experience with a Tier I BI tool is desired (experience with Business Objects is a strong plus

Detail oriented with excellent organization and analytical skills

Ability to prioritize work and meet deadlines;

Bachelors degree in computer science, information system, computer engineering or equivalent working experience is required

PMI/PMP certification is preferred but not required

5+ years working experience in data warehousing or data architecture environments

5+ years hands on experience with managing and leading data warehouse projects

Note: This is a full-time salaried position.

If you have the qualification described above, we invite you to learn more about this position with our organization