Lead the design, development, and analysis of data architecture and warehousing projects to meet analytic business needs and improve performance.
Collects and analyzes complex end-user requirements and evaluates the feasibility of these requirements from a technical perspective. Identify strategies for gathering data from operational databases and 3rd party vendors for inclusion in the warehouse.
Leads the design and creation of physical and logical data models (dimensions, schemas, hierarchies, data elements and marts). Identifies industry or business specific normalization standards.
Designs and implements complex level database solutions and enhancements to ensure an improvement in system reliability and performance. Execute and monitor ETL jobs
Provides mentoring and performs complex quality audits of processes in order to verify data integrity. Creates test scripts to identify and address data inconsistencies
Identify and develop new material to meet internal documentation needs and standards.
Proactively identify problems and facilitate process improvement activities. Provide root-cause analysis for any BI related issue and provide recommendations.
Identify tasks and resources; Establish timelines; Manage and prioritize tasks; Communicate status follow-up items; Collaborates with other departments; Ensure successful completion of tasks and projects
Provide leadership, training, and mentoring opportunities to staff on the effective use of reporting tools, data structure and content, report tuning, etc. Provide leadership in improving the quality and efficiency of departmental work processes.
Perform other duties, tasks, or special assignments as needed.
The Data Warehouse Developer contributes to the design, development, and analysis of data architecture and warehousing projects to meet analytic business needs and improve performance. A Data Warehouse Developer integrates disparate data sources, moves data from source to target systems, creates custom extracts for external vendors, designs and creates physical and logical data models which includes normalizing and conforming data using industry or business specific standards.
Carle Foundation Hospital