Data Warehouse Job Description
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:
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:
Desired experience for data warehouse includes:
Data Warehouse Examples
Data Warehouse Job Description
- 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
- 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
Data Warehouse Job Description
- 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
- 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
Data Warehouse Job Description
- 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
- 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
Data Warehouse Job Description
- 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
- 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
Data Warehouse Job Description
- 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
- 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