BI/DW development, collaborate with business analysts and stakeholders to understand the requirement.
Create time estimates for development tasks, work with BI team members to establish best patterns, practices, and standards as new technology arises.
Collaborate with other technology departments to define development and production infrastructure needs and best practices.
Create technical documentation and code comments based on industry standards.
Define and develop software unit tests and test plans based on business requirements.
Design comprehensive BI solutions, translating complex requirements into an optimal BI design
Develop, test, implement, and optimize scheduling for ETL jobs as described in the Technical Specification
Design and implement security solutions within the BI/BW environment
Review and understand reporting requirements to model the BI/DW solution
Create BW extracts and transformations for the new reporting targets
Define and capture metadata and rules ETL associated with ETL processes
Performance tuning and analysis including identifying and troubleshooting poorly performing queries and providing performance improvement recommendations
Collaborate with the business subject matter experts, business analysts, functional leads, architects and technical leads from other disciplines to come up with end-to-end solutions to meet the assigned business requirements