Data Warehouse Project Manager

CATCH Intelligence User Group

Omaha (NE)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A consulting firm in Business Intelligence seeks a Data Warehouse Project Manager in Omaha, Nebraska. Your role includes leading projects, managing teams, and developing strategies for data warehousing solutions. The ideal candidate has 5+ years of experience, strong knowledge of data models, and agile project management experience. This is a full-time salaried position with competitive benefits.

Qualifications

5+ years of working experience in data warehousing or data architecture environments.
Experience in managing and leading data warehouse projects.
Strong knowledge of data warehouse data models such as Inmon and Kimball.

Responsibilities

Lead Data Warehouse and BI projects, managing project teams.
Facilitate requirements gathering sessions with users.
Develop comprehensive strategies and roadmaps for project implementation.

Skills

Team player

Data analysis

Conflict resolution

ETL architecture knowledge

Strong interpersonal skills

Education

Bachelor's degree in computer science or related field

Tools

SQL Server

Business Objects

Job description

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;
Bachelor*s 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