Data Warehousing Job Description
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:
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:
Desired experience for data warehousing includes:
Data Warehousing Examples
Data Warehousing Job Description
- 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
- 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
Data Warehousing Job Description
- 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
- 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)
Data Warehousing Job Description
- 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
- 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
Data Warehousing Job Description
- 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
- 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)
Data Warehousing Job Description
- 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
- 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