Description

Design, develop, and maintain enterprise data warehousing and data lakehouse solutions. You will own the architecture, ETL/ELT processes, and data modeling for reporting and analytics.

This role is on-site.

Responsibilities

• Design and develop Snowflake enterprise data warehouse and data lakehouse architectures.
• Build and test ETL/ELT processes using Informatica IICS and Snowflake.
• Develop data warehouse models by analyzing transactional data stores to optimize reporting.
• Prototype and build dashboards using Power BI and Tableau.
• Mentor peers on data warehousing concepts, modeling, and tool utilization.

Required Skills

• 7+ years of IT experience in data management and business intelligence.
• Extensive experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration.
• Proficiency in ETL/ELT processes and Change Data Capture solutions like PowerExchange.
• Experience with Informatica on-premises products including PowerCenter and Data Quality.
• Ability to design data models for Power BI and Tableau.
• Experience with IBM Mainframe environments, specifically COBOL, JCL, and DB2.
• Knowledge of Snowflake and IICS Cloud Administration.
• Experience with Snowflake Data Cloud Performance Tuning.
• Bachelor's degree in Computer Science, Information Systems, or equivalent work experience.

Preferred Skills

• Familiarity with Data Governance products such as EDC, Axon, or CDGC.

Key Skills

Education

Bachelor's degree