[Hiring] 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 the dimensional model design, end to end ETL architecture design, ETL development, and implementation of data models and development of the Data Migration and Data Warehousing solutions. The ETL Architect is also responsible for:

• Requirements analysis
• Source data profiling
• Identifying data quality issues
• Designing transformation logic to address data quality issues
• Metadata data capture and data lineage
• Master data management and reference data management
• 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, professional job specific work experience

Requirements

• A minimum of seven (7) years experience with various BI and other analytic reporting software applications, with strong preference for EPIC, SQL, and Crystal Report Writing
• Prior experience providing production level support and/or development in business intelligence (BI)/enterprise data warehouse (EDW) environments
• Experience in database development and management tasks such as creating indexes, functions, stored procedures, and configuring permissions
• 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 identifying data quality issues
• Excellent communication (written, verbal and presentation) and people-facing skills
• Ability to review, re-engineer and/or tune legacy SQL queries and/or ETL jobs/processes
• Must be able to function in a dynamic environment subject to changes in schedules and priorities
• Experience in estimation, specification gathering, review code/designs, general planning for execution, monitoring and control
• Hands-on ability to design, re-design schemas, data models, and entity relationships
• Experience in designing, building, testing, executing and performance tuning of ETL and reporting applications

Benefits

• After-hours on-call support on a scheduled basis
• Responsible for ensuring service level agreement adherence
• Promotes and utilizes the data request and development process
• Participates in and contributes to the data governance program
• Assists with all upgrade, update or enhancement efforts associated with the ETL tool

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%
• Intensity of Work: Occasionally 0-30%
• Job Requires: Reading, Writing, Reasoning, Talking, Keyboarding, Driving