Data Warehouse Developer III

Description:

The Data Warehouse Developer III is a senior level technical position responsible for designing and maintaining the Business Intelligence infrastructure for the enterprise, including the data warehouse, reporting tools, data integration tools, clinical quality, and clinical analytic tools.
Key Functions/Responsibilities:
· Serve as a senior contributor on data and information centric initiatives including data warehouse
structure, ETL processes, and external data interfaces.
· Serve as a senior contributor on the overall design and implementation of the BI infrastructure
including evaluation and recommendation of software tools, definition of hardware requirements,
and system configuration.
· Serve as a senior contributor on the development of reporting models that define relationships
between tables in the data warehouse and simplify the report development process.
· Interact with the other departments to understand and identify data needs and requirements and
work with other members of the IT organization to deliver warehouse and reporting solutions to
address those needs.
· Interact with data analysts in IT and other departments to understand the documentation and
training requirements needed to efficiently utilize the BI infrastructure including the development
and maintenance of an enterprise metadata repository.
· Provide second level support of production BI environments.
· Perform design and code reviews for data warehouse developers, report developers, and data
analysts.
· Monitor performance of all warehouse and reporting systems; provide ongoing performance
tuning, review logs, clean temp files and all other administrative issues required to ensure
applications and databases are performing efficiently
Education Preferred/Desirable:
· Master's degree in Information Technology, Computer Science or related field.
Experience:
· A minimum of five years hands-on experience working with database and warehouse
technologies and architectures; including both logical and physical designs, data mart creation,
ETL tools, loaders and development and reporting tools is required. This experience should
include influencing global data architecture directions and defining major data architecture related
technology standards.
· A minimum of four years of experience with Informatica Power Center ETL tool.
· A minimum of five years hands-on experience in various data definition and modeling projects
and demonstrated capabilities in carrying best practices and common objects/components to
other projects is required.
· A minimum of four years of experience developing stored procedures in an RDBMS system,
preferably Microsoft SQL Server.
· Must have excellent SQL skills.
Experience Preferred/Desirable:
· Experience with development processes and production release management; application and
database tuning and interdependencies on operating system configuration is highly desired.
· Experience with health care related data highly desired.
· Multiple years of experience with Microsoft SSIS ETL tools