Data Warehousing Job Description
Data warehousing
provides technical leadership in the areas of design and implementation of Ratings Integrated Data Facility with modern AWS cloud technologies such as S3, Redshift, EMR, Hive, Presto and Spark.
Data Warehousing Duties & Responsibilities
To write an effective data warehousing job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehousing job description templates that you can modify and use.
Sample responsibilities for this position include:
Develops resource and staffing plans for the area
A leader within the Service Delivery team, responsible for ensuring stability of BMO’s mission critical IT Data Warehousing Infrastructure technology and services
Design, develop, and implement data models for enterprise level applications and systems
Act as a resource for users and team members to solve reporting questions, problems and new change requests
Designing and developing BI objects (facts, dimensions, hierarchies)
Creating various documents, case studies, demos, presales presentations, proposals in order to support the consulting sales representatives
Identifies opportunities for reuse of data across the enterprise
Gathers data and reporting requirements
Provides support, escalation response to production problem issues/errors
Produce source documentation needed to complete project configuration management plans for SysMan capabilities at Tier 0 level of SysMan hierarchy
Data Warehousing Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehousing
List any licenses or certifications required by the position: AWS, API, PMP, CE, SQL, MCSA, CBAP, BABOK
Education for Data Warehousing
Typically a job would require a certain level of education.
Employers hiring for the data warehousing job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Engineering, Technical, Information Systems, Information Technology, Education, Computer Engineering, Technology, Mathematics, Business
Skills for Data Warehousing
Desired skills for data warehousing include:
Cloud Computing
S3
VPC and Redshift
DevOps
High-performance databases
Highly secured workloads
Machine Learning
Serverless
Tools and frameworks
Ability to articulate examples of workflows and processes associated with that experience
Desired experience for data warehousing includes:
Report/analytics development experience (incl
Some ETL experience (preferably in Datastage, Informatica or other purpose built tool)
Data modeling ability
Experience in designing data warehouses for capital markets or like areas is highly desirable
Strong experience developing packages with MS SQL, PL/SQL, SSIS for data extract, reporting and data transformation
Experience with DB2 store procedures and DB2 SQL
Data Warehousing Examples
1
Data Warehousing Job Description
Job Description Example
Our company is looking for a data warehousing. 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 warehousing
- Analyze the input/output processes and working parameters for hardware/software compatibility
- Coordinate design of subsystems from Theaters and integration of total system with the Army Cyber Command
- Support SysMan Enterprise technologies to automatically and persistently consolidate asset data
- Sustain and provide configuration management of SysMan Enterprise environment
- Sustain integration of single sign-on for authentication and authorization at various tiers
- Support the Government in quantifying requirements and by recommending selection criteria used to sustain and maintain the Army Enterprise SysMan standard configuration at the Data Centers and Data Center COOP site, Theater NOSCs, Functionals, NEC/NEC equivalent, and Tactical
- Develop requirements traceability matrix with appropriate graphical designs supporting all LOMs, relationship to SysMan design, engineering, implementation, capability delivery requirements, and platform integration into Army physical and logical environments
- Develop Enterprise dashboards depicting/displaying IAVMs and certain system configuration items for user community and Current Operations Fusion Cell
- Provide Tier III support for engineering and program-level issues submitted to the SysMan Program and issues elevated by system administrators
- Provides administrative and technical leadership for the Data Warehousing and Business Intelligence
Qualifications for data warehousing
- Java and application design
- Experience in Data Warehousing and ETL Technologies
- Strong knowledge/experience in SDLC methodologies
- Experience with Business Intelligence tools such as Oracle Business Intelligence, Business Objects, Cognos, MicroStrategy, a plus
- 6-8+ years of experience in in database or systems analysis required, experience in the securities or financial services industry is a plus
- Ten (10) years of data warehouse report development experience using BI Tools INCLUDING eight (8) years of complex SQL reporting experience, four (4) years in OBIEE AND two (2) years with ETL Tools preferably ODI AND
2
Data Warehousing Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data warehousing. 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 warehousing
- Responsible for determining the user data and analytics requirements and delivers solutions that support those needs
- Responsible for planning, designing, implementing and supporting the development of the Enterprise Data Warehouse
- You will lead and manage the customer (internal/external) during the scoping timeline and activities to achieve effective solution closure and serve as a trusted advisor
- You will know your customer - understand pain points, business and IT needs, market trends, competitors
- You will ensure with stakeholders (Business, IT, Network, Vendors) that the solution and architecture address business needs and provide real business value
- You will manage the Scoping process, budget, and timeline
- You will work on large challenging and complex programs
- You will be able to work with and lead the best and brightest minds to collaborate across accounts/regions to provide a single voice
- You will have the opportunity to lead and work with the industry most advanced technologies
- Subject matter expert (SME) in applications’ capabilities and features for users, owners, and administrators of solutions
Qualifications for data warehousing
- Ability to work independently and assume full responsibility for delivering projects on time
- Excellent interpersonal skills and a demonstrated ability to work effectively as part of a team, establishing and maintaining strong relationships with peers and with management outside of the department
- Experience implementing and supporting MDM solutions in domains, preferably Customer & Product
- Strong knowledge of MPP Analytical appliances in a Data Warehousing environment
- Set-up of study specific application areas and work areas
- Experience with relational databases and big data infrastructures (Hadoop, SPARK)
3
Data Warehousing Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of data warehousing. 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 warehousing
- Provide technical input to requirements
- Provide technical analysis and recommendations
- Develop/contribute to Technical Project Plan
- Create / Contribute to design
- Conduct or participate in design Reviews
- Interface with RAVE, the primary EDC system
- Work in concert with a Data Warehouse Architect to design star schemas over varied sources of data which meet the business imperatives
- Design and develop an ETL process to incorporate source data into the Enterprise Data Warehouse
- Support of nightly ETL job stream, including some after-hours support as needed
- Work closely with the Business Intelligence team to ensure business reporting requirements are supported by the Data Warehouse
Qualifications for data warehousing
- 7+ years experience within subject matter
- Data Warehousing / SANs certification
- 7+ years in Subject Matter
- Computer software used to manage projects
- Principles and practices of technical problem solving
- Team dynamics and team building
4
Data Warehousing Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of data warehousing. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehousing
- Utilize an IDE to ensure all code is stored in the appropriate source control system
- Participate in offered training opportunities conduct self-lead training over relevant topics
- Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system.Works with Business Analysts to gain an understanding of functional requirements
- Works with Business Analysts to develop implementable technical designs
- Analyzes requirements, design and develop prototype and work with the users/business analyst to fine tune the data warehouse and make recommendations.Participates in peer/code/design reviews to verify that quality standards and functional/technical requirements are met
- Design, code, test and implement moderately complex programs
- Act as a hands on technical integrator with various BI/DW tools
- Familiarity with the SDLC
- Define and deliver the Data warehousing and BI technology strategy, reference architectures, design patterns and standards by closely collaborating with the AVP for OIR, and other internal and external technology partners
- Be involved with institutional data governance and assure important issues reach conclusion so projects can move forward
Qualifications for data warehousing
- Understand highly complex information technology systems and methodologies
- Legacy application change management
- Possesses strong strategic and tactical skills excellent written and oral communication skills
- Development and documentation abilities paired with very good communication & technical documentation skills, ability to understand and document complex data flows as part of business / production processes
- Fluency in either German or English
- Current/active Secret/SSBI clearance (IT Level I (in accordance with AR 25-2) SECRET SSBI)
5
Data Warehousing Job Description
Job Description Example
Our growing company is hiring for a data warehousing. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehousing
- Enable consistent delivery of high value projects within given timelines and allocated budgets
- Be accountable for delivering technical solutions based on business partners‘ requirements that empower business owners in nimble institutional decision-making
- Lead a team of technical staff and developers responsible for delivering and managing highly scalable data warehousing and business intelligence solutions
- Mentor and train the data warehouse delivery team to ensure that BI solutions adhere to predefined BI governance processes, coding standards, enterprise level data models, data security, and data quality standards
- Coordinate with data custodians on data sources to help ensure accurate ETL processes
- Act as a point of contact by seeking to understand needs, providing information, responding to inquiries, investigating and resolving problems
- Collecting and documenting the functional and non-functional requirements, feasibility analysis, IT development planning, execution and control
- Cooperation with customers in the design and construction of architectures based on or related to Business Intelligence and Big Data
- Work with a team in the design and implement of Java application(s) solutions supporting a next generation of data warehouse systems
- Work closely with development, support, DBA and business teams
Qualifications for data warehousing
- Current IAT III cert (CISA, GCIH, GCED, CISSP (or Associate), CASP) required at start date
- Microsoft Certified Solutions Associate (MCSA) SQL, or higher CE certification required within six (6) months of start date
- 5 or more years of related experience including SQL programming, documentation, maintenance, upgrades and troubleshooting highly preferred
- 9 or more years documented experience in Healthcare IT
- Minimum 5 year of Data Warehousing
- 7+ years of experience in Data Warehouse technologies