[Hiring] EPIC Certified ETL Architect @Northeast Georgia Health System

Role Description

ETL Architect is a high-level business intelligence professional that is a key part of the Data and Analytics Team and will be generally responsible for:

• Dimensional model design
• End to end ETL architecture design
• ETL development and implementation of data models
• Development of Data Migration and Data Warehousing solutions
• Requirements analysis and source data profiling
• Identifying data quality issues
• Designing transformation logic to address data quality issues
• Designing for data warehouse/data mart solutions
• Extensive interaction with operational team members and leadership
• Analysis of business data and analytics requirements
• Mentoring of other team members on ETL concepts and strategies
• Keeping the ETL Environments updated periodically

Qualifications

• Epic Revenue or Clinical Data Model or Cogito Project Manager Certificate required (must be obtained within 6 months of date of hire)
• Bachelors Degree in Computer Science or related field, or 11 years progressively responsible experience in the field

Requirements

• A minimum of seven (7) years experience with BI and analytic reporting software applications, strong preference for EPIC, SQL, and Crystal Report Writing
• Prior experience providing production level support and/or development in BI/EDW environments
• Experience in database development and management tasks
• Working knowledge of data warehouse concepts and enterprise data management
• Strong analytical and interpersonal skills
• Advanced understanding of Data Migration/Data Warehousing/Data Mart delivery life cycle
• Strong experience with concepts of data profiling and data quality issues
• Excellent communication skills
• Ability to function in a dynamic environment with changing schedules and priorities
• Hands-on ability to design and re-design schemas, data models, and entity relationships
• Experience in designing, building, testing, executing, and performance tuning of ETL and reporting applications

Benefits

• Service-oriented approach with customers
• After-hours on-call support on a scheduled basis
• Adherence to service level agreements

Essential Tasks and Responsibilities

• Designs end to end ETL architecture for Data Migration, Data Warehousing or Data Mart Solutions using Microsoft SSIS tool
• Stands up a DW/ETL Center of Excellence to document and enforce best practices
• Implements a reference data management system
• Answers staff and client questions in person, via email and via phone
• Works with leaders in IT and operations to identify data from other source systems
• Participates in and contributes to the data governance program
• Assists with all upgrade, update or enhancement efforts associated with the ETL tool
• Builds and maintains SQL scripts, indexes, and complex queries for data analysis
• Prepares and maintains key documents and technical specifications for new and existing solutions
• Monitors incident management queue and efficiently troubleshoot issues

Physical Demands

• Weight Lifted: Up to 20 lbs, Occasionally 0-30% of time
• Weight Carried: Up to 20 lbs, Occasionally 0-30% of time
• Vision: Moderate, Frequently 31-65% of time
• Kneeling/Stooping/Bending: Occasionally 0-30%
• Standing/Walking: Frequently 31-65%
• Pushing/Pulling: Occasionally 0-30%