Informatica Developer II

Data Warehouse Developer II

Remote – Boston, MA

Role Summary

The Data Warehouse Developer 2 is a mid-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.

Responsibilities:

• Serve as a key contributor on data and information centric initiatives including data warehouse structure, ETL processes, and external data interfaces.
• Serve as a key 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 key 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.

Requirements:

• 3+ years of Data Engineering, Data Warehouse, and/or Database development experience
• Proficiency with ETL process

Nice to have:

• Experience with Informatica PowerCenter preferred
• 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