Data Warehouse Project Manager

CATCH Intelligenceis 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…