Data Warehouse Manager Job Description
Data warehouse manager
provides reporting to the client as needed to increase client's ability to manage their business effectively and efficiently.
Data Warehouse Manager Duties & Responsibilities
To write an effective data warehouse manager job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse manager job description templates that you can modify and use.
Sample responsibilities for this position include:
Work collaboratively with Strategy teams to compile audience profiles, campaign goals, insights, and measurement plans
Create simple, easy-to-follow reports and dashboards that key department heads will utilize on a regular basis to make informed business decisions
Provides after hours and weekend support
Ensures adoption of enterprise and department processes and procedures
Manage the status of the overall program and effectively communicate and manage all opportunities and risks
This is role is the CIDW PMO
Lead the creation of roadmaps, financials, and requirements
Work closely with the InfoSec team to ensure the best practices are being followed and that the DW is as secure as possible
Manage multiple offshore Project Managers to deliver capabilities/projects/data sets/reports that have been prioritised by the Business Product Owner
Own DW project resourcing and execution
Data Warehouse Manager Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse Manager
List any licenses or certifications required by the position: PMP, CBIP, ITIL, CSPO, PMI, ISTQB, ISEB
Education for Data Warehouse Manager
Typically a job would require a certain level of education.
Employers hiring for the data warehouse manager job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Technology, Technical, Math, Computer Engineering, Computer Information Systems, Writing, Technical Management
Skills for Data Warehouse Manager
Desired skills for data warehouse manager include:
SQL
Ability to implement application software within an organization in order to help end-users perform specific tasks
Ability to leverage that information in creating customized customer solutions
Ability to manage an organization's architectures
Ability to manage the processes
Ability to use this information to simplify information systems and make sound business decisions
Ability to utilize business processes and technologies for gathering
Altering and protecting organizational data
Analyzing
But a distinct advantage
Desired experience for data warehouse manager includes:
Experience managing projects using Scrum and Kanban
Experience with security technologies around cloud solutions, preferably AWS
Experience with Jira and GIT
Experience with budgeting and financial tracking
7+ years of consulting experience (client-facing) related to data integration/ETL and data warehousing implementation
Experience with additional Business Intelligence and analytics tools a plus, but not required (Cognos, Business Objects, Tableau)
Data Warehouse Manager Examples
1
Data Warehouse Manager Job Description
Job Description Example
Our company is growing rapidly and is looking for a data warehouse manager. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse manager
- Understand BI requirements
- Manage daily activities of BI/DW Business Analysts and Developers in locations worldwide
- Hands-on work of complete life cycle of application development
- Work closely with business and functional areas to gather requirements and identify feasible and cost effective solutions to implement
- Design the common data architecture asset including framework, principle, guideline and template to guide the delivery team realize an optimized solution
- Design the detailed data architecture includes data governance, master data strategy, master data management, data quality, data modeling, ETL approach, data storage etc
- Design optimal data warehouse and analytics solution to fulfill the business/technical requirement
- Develop business intelligence and data management solution plan
- Identify the gap between business requirement and data architecture and propose solution to resolve or shorten the gap
- Shaping and leading large-scale analytics project full lifecycle implementation activities
Qualifications for data warehouse manager
- Experience with data modeling tools such as Erwin, Embarcadaro
- Familiarity with statistical modeling tools by SPSS or SAS
- Bachelor’s Degree in Computer Science, Engineering or similar required
- Significant experience with project management of a data warehouse
- Ability to perform information management assessments (review of needs, data quality, data security, ) and create detailed strategy and roadmaps surrounding data warehousing, integration, and/or analytics
- Demonstrable experience in the delivery of enterprise scale Oracle/Informatica/OBIEE DW/BI solutions in Financial Services organisations
2
Data Warehouse Manager Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of data warehouse manager. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse manager
- Represent the architecture design efforts to Manager and C-level executive
- Establishing acceptance of designs with client executives
- Cultivating client relationships and driving revenue acquisition
- Act as a resource to major projects, providing subject matter expertise and technical direction to more junior technical staff
- Prepare and present technical concepts to internal I.T
- Provides the Business Glossary for the enterprise
- Mentor and coach experienced database administrators entry-level database administrators
- Business development planning
- Reviewing on-going capability enhancement requests and working with capability teams to sequence the delivery of these appropriately in system roadmaps 12 to 24 months out
- Leading application development and support vendor identification, evaluation, and selection to staff project delivery roles that meet delivery standards across quality, throughput, and budgetary/return-on-investment goals
Qualifications for data warehouse manager
- Demonstrated expertise in BI/DW, data modeling, transformation, data analysis and tools, ideally with Cognos and Oracle
- CMMI SDLC Project Lifecycle
- Knowledge of source control tools
- Organizes and coordinates the roll-out of software releases between the platform and operational architects and development staff
- At least 7 years of Data Development experience in Data Warehousing environment
- At least 2 years of hands-on experience with BI tools
3
Data Warehouse Manager Job Description
Job Description Example
Our company is looking to fill the role of data warehouse manager. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data warehouse manager
- Partnering with enterprise architects to deliver technical innovations in support of emerging business needs and progressing these ideas from concepts to experiments to scaled models with focus on flexibility, reuse, and overarching extensibility
- Provides leadership and direction for large data warehouse implementations and/or large healthcare system implementation efforts and ensures project and organizational objectives are accomplished
- Plans, directs and oversees project activity
- Assigns, directs and manages resource teams and team leads
- Provides input to, reviews and approves Project Management Plans and Project Schedule, project deliverable templates and other project documentation
- Ensures completion of project deliverables, reviews and approves project deliverables
- Implements and continually improves processes for delivering data warehouse solutions
- Reviews and resolves project issues, escalates issues as necessary
- Determines resource allocations required to meet project demands, adjusts resource plans and resource assignments as needed to adapt to project changes, ensures staffing levels align with project schedule and budget
- Collaborates and communicates with other managers to ensure project success
Qualifications for data warehouse manager
- EDW experience
- Experience with data modeling, Teradata, performance, and/or capacity planning capabilities
- 5 or more years of experience in a leadership role with direct reports and people management responsibilities
- Bachelor's or advanced degree in IT, Computer Science, business or related field
- Prior IT experience implementing large scale Data Warehouse systems or other large program implementation
- 7 or more years of experience in business process and/or technology implementation
4
Data Warehouse Manager Job Description
Job Description Example
Our innovative and growing company is hiring for a data warehouse manager. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data warehouse manager
- Participates in risk identification, evaluation, strategy, action plans, and mitigation activities
- Effectively communicates with, and develops/maintains excellent working relationships with a diverse group of internal and external stakeholders to ensure project status and strategic direction is shared and project-related interests are met
- Produces documentation of standards and processes governing DW delivery best practices
- Oversees project execution- ensures delivery success
- Coordinate development activity along with project due dates to ensure on time delivery
- Provide leadership to requirements gathering, analysis/review meetings
- Identify, lead and drive analysis of outstanding issues and ensure proper resolution and communication amongst stakeholders
- Prepares or oversees the preparation of preliminary user requirements , support/modifications and documentation materials for all division systems
- Provides leadership and direction for data warehouse development activity and ensures project and organizational objectives are accomplished
- Assigns work and directs the managers and leads of resource teams that are responsible for delivering DW changes and enhancements
Qualifications for data warehouse manager
- Hands on experience with modeling tools, a plus
- At least seven years Data Warehousing and Business Intelligence experience
- 5 or more years of experience at a manager level or above delivering global IT capabilities for a multi-national company with annual budgetary responsibilities
- 7 or more years of experience at a manager level in a multi-channel brand business environment
- Multiple years of experience with delivering Data Warehouse capabilities by applying system and delivery lifecycle methods and approaches
- Excellent communication (written and verbal) skills, tailoring communications to fit various audiences and levels and seeking the audience's point of view, perspective and needs throughout the communication process
5
Data Warehouse Manager Job Description
Job Description Example
Our company is searching for experienced candidates for the position of data warehouse manager. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse manager
- Ensures completion of assigned project deliverables, reviews and approves project deliverables
- Determines resource allocations required to meet project demands, adjusts resource plans and resource assignments as needed to adapt to project changes, ensuring staffing levels align with project schedule and budget
- Actively engages in leadership decisions that are impactful to the project and ensures overall project success
- Participates in the overall functional design of all system components, functional procedures, program applications, software engineering, and functional documentation
- Presents the DW technical solution to the client, both business and technical audiences
- Works with third party vendors, data sharing partners, and infrastructure teams to integrate the DW solution
- Actively engages in risk identification, evaluation, strategy, action plans, and mitigation activities
- Actively engages in planning, designing, developing, testing, and implementing system enhancements and functionality modifications
- Manages system configuration activities and the integration of system components
- Establishes the System Release schedule
Qualifications for data warehouse manager
- Excellent vendor management skills including contract management, negotiations, resource management
- 5 years' proven success as a manager responsible for Delivery and Operation of Data Warehouse and/or similar sized and complex health care systems, and reporting and/or analytic solutions for large implementation projects
- 5 years' in-depth understanding of Data Warehouse and healthcare systems, reporting and analytic solution development best practices and similar system application development best practices (SDLC methodology)
- 5 years’ experience planning and directing large scale software development activities and managing implementation teams
- Excellent interpersonal skills and the ability to collaborate with technical teams, project management, client management and customer stakeholders
- 3 years' Health and Human Services project experience