Senior Data Warehouse Developer - Atrium Health IAS Data Warehouse Charlotte FT

Full-time - Mid Level

Charlotte, NC

About the position

Manages all activities related to the development and administration of data warehouse data management process, query and reporting tools, and analytical applications. Analyzes data warehouse/decision support business requirements and associated source systems to design and develop the application architecture and data management architecture. Handles the detailed design specification development, coding, testing, debugging, and documentation associated with implementing and maintaining the analytical applications and data management processes.

Responsibilities

• Develops work plans, estimates tasks, and provides budget input for items related to the development of data warehouse data management processes and analytical applications.
• Provides input into determining project scope and is able to communicate and manage project scope.
• Identifies, defines, documents, analyzes, and obtains customer sign-off on data warehouse/decision support business requirements.
• Analyzes these requirements to establish the application architecture.
• Establishes the data management architecture through an analysis of business requirements, source system data, and source system application architectures.
• Evaluates and approves technical architecture and defines the optimal location and configuration of extract, load, and transformation routines.
• Coordinates development of extract routines with source system team loads.
• Manages data security including data encryption, user and group management, views, and security modes available for the data warehouse and the data access tools.
• Administers the metadata repository, controlling repository entries, updates, and deletions.
• Designs the metadata repository with the application developer.
• Develops procedures for providing customers with central access to refresh status information.

Requirements

• High School Diploma or GED required.
• Bachelor's Degree preferred.
• 4 years experience in designing, implementing, and supporting Data Warehouse/decision support systems.