Data Warehouse Developer Job Description
Data warehouse developer
provides management for the development team in architecting, designing, building and enhancing data warehousing, data mart and big data services.
Data Warehouse Developer Duties & Responsibilities
To write an effective data warehouse developer job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop ETL using Informatica PowerCenter
2 years of experience developing MS SQL Server programming solutions
Develop reports the business can use to run their business more effectively
Bridge the gap between business and data by working cross-functionally with other teams
Monitor and maintain the health of data supporting your business function
Extract insights from data exploration tasks to inform the business on new opportunities
Speak to the validity of results in large meetings and quantify with tangible evidence
Help train team members
Design performant technical solutions
Work with project managers to achieve milestones and delivery
Data Warehouse Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse Developer
List any licenses or certifications required by the position: ITIL, EPICS, MCSE, BI, IAT, MCSD, MCSA, TM1, SAP, CBIP
Education for Data Warehouse Developer
Typically a job would require a certain level of education.
Employers hiring for the data warehouse developer 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, Information Systems, Engineering, Technical, Information Technology, Business, Design, Software Engineering, Management Information Systems
Skills for Data Warehouse Developer
Desired skills for data warehouse developer include:
Data access using web services
Field of BI and DWH concepts
Relational data modeling
SQL and data warehousing
Data warehousing and demonstrated experience in designing dimensions for efficient slicing and dicing
Microsoft BI technology
Stored procedures
Healthcare revenue cycle management
Informatica
SQL
Desired experience for data warehouse developer includes:
3+ years of Hadoop experience is required
Should have approx
Continuously develop expertise in the data and data models within the data warehouse, understanding of supported business domains
Load and validate dimensions and measures via SSIS
Perform all application unit and system testing
Create data dictionary’s and proper documentation on the data warehouse (Oracle DB)
Data Warehouse Developer Examples
1
Data Warehouse Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for a data warehouse developer. 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 developer
- Provide leadership and direction for the resolution of complex technical issues
- Review and direct vendor teams in the conversion of business requirements into technical specifications and/or implementation plans
- Advise management on project scheduling, technical recommendations and vendor selections
- Work with cross functional teams during project life cycle from inception to post production support
- Develop and maintain OBIEE solutions
- Develop and maintain data models and solution architecture
- Design reporting architecture and approach
- You will performing critical & non-critical support activities to ensure production stability
- You will provide a quick and professional analysis/trouble shooting tor production related escalation
- You will work with partner teams (Application support, Infra, DBA, Service desk, Monitoring) to provide support for tickets pertaining to all production outstanding issues
Qualifications for data warehouse developer
- OBIEE 11g or 12c
- 5 years’ experience in Data Warehouse, ETL and BI solutions development including 2 years in OBIEE
- Solid understanding of dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions
- Experience with SybaseIQ is required in support of general DBA functions
- Ability to document business processes and data flows as they relate to technology system use - applications, COTS, upstream/downstream
- 8+ years of Data Warehouse/OLTP Architecture, Modeling and Development
2
Data Warehouse Developer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a data warehouse developer. 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 developer
- Provides technical expertise in SQL Server Information Services and assumes a senior role in systems integration efforts
- Provides expertise in the use of DBMS tools such as Microsoft SQL Server, ETL tools such as Microsoft SSIS and Microsoft DTS, business intelligence tools such as Microsoft Analysis Services and Microsoft Reporting Services
- You will work on adhoc requests and other reporting as and when required
- You will provide excellent and quality on call support when needed
- You will adhere to process laid down for production operation
- You will design and development of short/long term development tasks/CRs for production environments
- You will design and development of tasks to enhance performance
- You will provide remote technical support to customers
- You will be challenged with designing and developing new software applications
- You will have the opportunity to work with the industry that has the most advanced technologies
Qualifications for data warehouse developer
- Review and approve project designs including data mappings, data models and ETL
- Analyze, design, and build dimensional and relational data models and logical data specifications
- Partner with Data Governance / Data Management business partners in the development and maintenance of enterprise data architectures
- Participate in architecture forums and present design/changes for upcoming projects
- Participate in technical forums and get all desired approvals before code migrations to production
- Integrate multiple and complex data sources including transactional and non-transactional, structured and unstructured
3
Data Warehouse Developer Job Description
Job Description Example
Our growing company is hiring for a data warehouse developer. 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 developer
- Manages end-user accounts and accessibility
- Be responsible for development and support of enterprise level applications using Business Objects
- Work with enterprise wide business and IT senior management to understand reporting and data analysis needs
- Be principally responsible for designing Business Objects universe layer for business intelligence solutions
- Have mastery level understanding of Business Objects security administration
- Have expert level knowledge of Business Objects universe configuration (parameter settings, ) and universe design aspects (resolving loops, contexts, aliases, cardinality, ) Experience with SAP Information Design Tool
- Work interactively with both technical and non-technical staff to build Business Objects universe layer that adheres to underlying data model and effectively delivers data to end users
- Have extensive experience in working within a Business Intelligence environment and knowledge of data warehouse modeling and design
- Stay abreast of releases / patches for Business Objects
- Understand logical and physical data modeling and methods for optimizing the Business Objects universe against the physical model
Qualifications for data warehouse developer
- Viewed as functional expert and leader in programming/ analysis within KP
- Some scripting skills(shell or perl)
- Previous experience supporting a data warehouse optimized for a Business Intelligence environment preferred
- Previous Teradata database experience preferred
- Previous Oracle 10 or 11 database experience
- Proficiency with stored procedures and SSIS packages
4
Data Warehouse Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for a data warehouse developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehouse developer
- Architect data in the cloud (open to cloud platform)
- Own and drive the technical design, development, and day-to-day support of the Data Warehouse and associated ETL processes
- Support ongoing data quality and data integrity initiatives through audit, balance, and control procedures, alerts and reports, and automated recovery
- Designs, develops, extends, and maintains Data Warehouses and Data Marts
- Provides expert level application and data analysis for data warehouse and systems integration projects
- Designs and codes ETL processes and constructs OLAP data sources
- Works closely with Applications Architect and Project Managers to ensure proper architecture design and compliance with database and development standards
- Implements and deploys phases of business intelligence and systems integration projects
- Advises/recommends project and activities as related to system/architectural direction and strategy
- Assist with identifying required data in various source environments identifying data quality gaps
Qualifications for data warehouse developer
- Ability to adhere to coding standards and participate in peer code reviews
- ETL design concepts and monitoring
- Eight or more years in database/data warehouse development experience
- Strong understanding of database structures/Data Modeling, theories, principles and practices
- You will be required to work effectively with remote teams as the role will need you to have constant communication with the global development teams across New York, London, Montreal, Budapest and Mumbai
- Minimum 5 years of system development experience
5
Data Warehouse Developer Job Description
Job Description Example
Our growing company is looking to fill the role of data warehouse developer. 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 developer
- Develops the scripts used to load data into the data warehouse
- Develops scripts and programs to extract data from source systems
- Develops the scripts necessary to incrementally evolve the data warehouse data model
- Creates project requirements documents
- Creates technical project documentation
- Creates Business Objects universes
- Creates LogiAnalytics reports
- Performs production support of data warehouse and BI related systems
- Provide weekly progress reports of work performed
- Work with the project team to assist in other aspects of the project
Qualifications for data warehouse developer
- Understanding of Informatica Powercenter 9.x a plus
- Extensive experience with Oracle database environments leveraging databases, tables/views, stored procedures, agent jobs
- SQL Server 2012 and Visual Studio 2012, one year
- Expertise with SSRS, SSIS, SSAS
- Expertise in .NET technologies (VB, C#, ASP)
- Ability to execute assigned tasks with a high degree of independence based on verbal or written requirements