Summary: With some supervision, responsible for the sourcing of data into the Enterprise Data Warehouse. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Also responsible for managing database utilities, maintains relationships between the database users and applications, and maintains databases across multiple platforms. Responsible for development, modification, and maintenance of ETL processes for EPIC Clarity and Business Intelligence environments. Responsible for all facets of data management including analysis, creating extracts, scripts, scheduling, packages, mapping, monitoring, administration, upgrades and documenting specifications based on business needs. Sets and monitors standards and maintains database support tools, tables and dictionaries, and recovery and backup procedures. Collaborates with technology/infrastructure staff to identify data relationships and functional requirements. Analyzes and resolves issues related to information flow and content.
Education: Bachelors Degree (or foreign equivalent) in Engineering, Information Services, Computer Science, or related field.
Licensure/Certification: Microsoft Developer certification a plus but not required.
Experience: 1-2 years of professional experience Microsoft SQL Server SSIS development preferred. This experience will be from a data warehouse/Business Intelligence team creating ETL processes. Experience creating and loading dimensional database models in SQL Server. Experience implementing ETL data quality improvement processes. Must have good verbal and written communication skills. Must have problem solving and time management skills. Must be available and accessible 24/7/365. Preferred Qualifications Possesses a deep understanding of data warehouse design architecture MS SQL Server database features and ETL tools and best practices. Understanding of EPIC healthcare data or experience with healthcare provider data captures a plus.
Location: Parkview Health · IS Business Intelligence
Schedule: Full Time Benefit Eligible, Days, M-F