Data Warehouse Job Description
Data warehouse
provides insights by analyzing historical data from databases (Redshift, SQL Server, Oracle DW, and Salesforce).
Data Warehouse Duties & Responsibilities
To write an effective data warehouse job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse job description templates that you can modify and use.
Sample responsibilities for this position include:
Works with Requirements Analyst, Data Architect, Data Modeler and the ETL Team to translate Business Rules into Technical Requirements for ETL processes
Create SIT test cases/SQL queries and scripts/test data /Test execution
Performs integration of clinical data from desperate data sources, for clinical trials, using Extract Transform and Load (ETL) tools
Design ETL architecture and approach
Develop reports using BusinessObjects and Tableau
Provide Production Support of the Data Warehouse the ETL jobs used to support the Data Warehouse and FRB
Enhance the existing SSIS framework to be more robust and flexible
Development, management and Datawarehouse solution monitoring for the big Telco company
Solves problems proactively
Provide leadership and technical expertise to enable effective Business Intelligence and Data Warehouse (BI/DW) strategies and goals in a global implementation of BI Applications
Data Warehouse Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse
List any licenses or certifications required by the position: AWS, PMI, CBAP, PMP, MCDBA, MCSE, IAT, ISTQB, ISEB, MCSD
Education for Data Warehouse
Typically a job would require a certain level of education.
Employers hiring for the data warehouse 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, Information Technology, Education, Engineering, Business, Technical, Information Systems, Science, Technology, Mathematics
Skills for Data Warehouse
Desired skills for data warehouse include:
SQL
Cloud Computing
S3
VPC and Redshift
Relational databases
Data warehousing
Informatica
Tableau
Oracle
ETL
Desired experience for data warehouse includes:
Experience with databases, preferred Teradata
Experience with reporting/ad-hoc analysis tools, preferred MicroStrategy
Development of test plans and scenarios
Writing test cases and test documentation
Data layer testing
Proficiency in at least one scripting language (Python, Perl, R, C Sharp, Java)
Data Warehouse Examples
1
Data Warehouse Job Description
Job Description Example
Our company is hiring for a data warehouse. 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
- Design and implement ETL procedures for intake of data from both internal and external sources
- Treasury/BTS
- Analyze and troubleshoot erroneous results, determines the root causes, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defects
- Defines data models and develops data structures for clinical trials
- Ensures data consistency across clinical trials as appropriate
- Performs integration of clinical data from desperate data sources for clinical trials
- Ensures consistent data structures are available across clinical trials as appropriate
- Supports post-production database change activities
- Defines data models and develops data structures based on appropriate industry standards
- Ensures data model consistency across clinical trials as appropriate
Qualifications for data warehouse
- Greater customer focus and expanded market share
- Better operational performance and execution
- Increased employee alignment and accountability
- Proactive' management vs
- 1+ years of relevant database development experience in SAP/Sybase 15.5 or higher
- Provide inputs to Solution Architect in the development of project initiation documents, including the definition of objectives, scope, approach, and deliverables
2
Data Warehouse Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of data warehouse. 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
- The Data Warehouse Developer will help review existing data sources, databases, table structure, and dashboards/reports (major in Tableau)
- Implement the design and support the Tableau teams with data integration and performance
- Translates Business Rules and Requirements into analytical models
- Analyze, document and communicate source system data structures explicit and implicit dependencies within and between data sources
- Ability to drive the Source to Target Mapping Specifications process
- Drive the understanding/validation of data
- Discover/Mitigate/Validate problematic data and communicate with Source Teams and Data Warehouse Team
- Develop Data Migration solutions for disparate data sources
- Define and communicate cleaning and filtering requirements on data sources
- Identify integration points of new data sources with existing data and define integration mappings
Qualifications for data warehouse
- Gains a quick understanding of the core of an issue
- Excellent SSIS development skills and experience
- Excellent batch programming skills and experience
- Ability to think independently and serve as both technical data analyst/ programmer business analyst
- Hadoop/Hive experience is a bonus
- Hands-on experience with SQL and querying multi-dimensional databases testing
3
Data Warehouse Job Description
Job Description Example
Our growing company is looking for a data warehouse. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data warehouse
- Advises and recommends best practices for design, development, and testing of ETL processes
- Under direction of the reporting manager aligns the ETL environments with operational and business needs and strategies
- Data Assurance of the Model including, data quality, load metrics and ETL Rules
- Gauges the effectiveness and efficiency of existing systems
- Migrate user guide document to project/system wiki page (Confluence) and maintain content in accordance with functionality releases
- Be responsible for the development and maintenance of the database infrastructure needed for successful analytic processing, providing data interfaces with external databases, and report production
- Thoroughly assess the business needs behind the requests for new programming functionality
- Conduct technical analytic work
- Design an architecture that supports reuse, improved performance, data governance/standards, and removes latency
- Manage data integration, operations, and governance
Qualifications for data warehouse
- Excellent SQL development skills and experience
- Proficiency in at least one non SQL-based programming language (C#, Java, Python, Javascript)
- Strong SAS and/or SQL skills required on a Windows and/or Unix platform
- 2+ years as Data warehouse developer or tester or 3+ years as a ETL developer/tester ( Must have)
- Solid hands on QA test experience with DW/relational database including designing , creating and executing complex SQL queries
- Must have 4+ years of experience with data integration using Informatica power center or similar tools
4
Data Warehouse Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of data warehouse. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data warehouse
- Implement business rules via T-SQL, middleware, and other technologies
- Knowledge of MS SQL server, query, reporting and OLAP tools
- Assists in providing timely and accurate user support for all aspects of data warehouse and CRM usage, maintenance and integration
- Designs and develops complex/ technical data warehouse architecture and Business Intelligence (BI) products incorporating industry/ company best practices
- Researches changes in technology and industry standards
- Enhance interdepartmental relationships with users throughout the organization to provide a more technical perspective in the development of BI solutions
- Assist with the design of technical and functional requirements for data integration projects
- Interact with business users and decision support staff as part of the support work for error resolution and design enhancements
- Assist in the development of reporting and analytics solutions for the data warehouse
- Assist the Senior Data Warehouse Engineer on their day to day activities, including development of business intelligence reporting and analytic solutions
Qualifications for data warehouse
- Must have 4+ years of experience in the design of EDC, IRT and/or ePRO systems, or 6+ years of experience in a similar technical or clinical development environment
- Expert understanding of clinical data management
- Must have expert level experience with data modeling concepts
- Expert understanding of FDA expectations and guidelines related to applications used in clinical research
- Experience with Oracle Life Science Data is desired
- Deep experience in information systems, or related field
5
Data Warehouse Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of data warehouse. 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
- Work as a part of an Agile team to implement product enhancements
- Support the MI Manager and wider MI team reporting requests
- Develop procedures and oversee good practice to ensure accurate and timely maintenance
- Ensure any data changes are validated, documented and implemented
- Monitor and audit the integrity of data changes that have been made
- Implement and / or oversee any corrective actions or exceptions
- Review the output of periodic and ad-hoc reporting or data extraction requests
- End to end database and process development
- Act as a point of contact for data requests, maintenance and subject matter expertise
- Work closely with operational managers and other parts of the PCSE
Qualifications for data warehouse
- 3+ years coding in SQL
- Knowledge of Big data systems - Hadoop , pig, hive, shark/spark a big plus
- Improved financial results
- Industry experience from core industries
- Experience with MS Visual Studio, .NET, C#, ASPX and web services development
- Prior database administrator experience to provide routine maintenance such as recalculating statistics, log space clean out, index rebuilds, and performance tuning