ETL Architect – Snowflake, SSIS

Role Overview

• 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, experienced with the concepts and/or implementation of metadata data capture, data lineage, master data management and reference data management.
• The ETL architect designs for data warehouse/data mart solutions should include appropriate staging databases to handle change data capture on the source data, error handling and audit balance control mechanisms.
• The ETL Architect will have extensive interaction with operational team members and leadership, and will be tasked with analysis of business data and analytics requirements, and the transformation of those requirements into analytics solutions.
• Working with customers and Management to determine priorities and mentoring of other team members on ETL concepts and strategies is also an integral role of the position.
• Working with Infrastructure and DBA team members, ETL Architect is also responsible for keeping the ETL Environments updated periodically to the latest version of the ETL software.

Requirements

• Bachelor's Degree in Computer Science or related field
• Epic Revenue or Clinical Data Model or Cogito Project Manager Certificate required (must be obtained within 6 months of date of hire)
• A minimum of seven (7) years experience as a 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, creating databases, file groups, users, configuring permissions and assigning roles to users.
• Strong analytical and interpersonal skills; demonstrated ability to work with management and customers; proven ability to work independently or as a team member; strong problem solving and troubleshooting skills.
• Advanced understanding of Data Migration/Data Warehousing/Data Mart delivery life cycle, from requirements definition to creating source to target mapping documents with transformation rules, Error handling design, data quality, design audit Balance control mechanisms to be able to automate jobs, notify proactively failures, write test cases and create templates to document all aspects of the projects throughout the lifecycle.
• Strong experience with concepts of data profiling, identifying and measuring data quality issues, advanced experience with Master data and reference data management techniques to eliminate hard coding within the ETL processes/jobs.

Tech Stack

• ETL
• SQL

Benefits

• Health insurance
• 401(k) matching
• Paid time off