Description

Design, develop, and maintain data integration processes and warehouse models within a Snowflake cloud environment. This role is on-site.

Responsibilities

• Build and test data integration processes including extraction, loading, cleansing, and transformation.
• Develop data warehouse models to optimize reporting and analytics from transactional data stores.
• Prototype, build, and test Power BI and Tableau reports and dashboards.
• Perform data mining and analysis within the Snowflake cloud data warehouse.
• Review and validate data accuracy, maintain enterprise data modeling, and provide technical consulting on data usage.

Required Skills

• 7+ years of IT experience in data management and business intelligence tools.
• Extensive experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration.
• Proficiency in ETL/ELT tasks and Change Data Capture solutions like PowerExchange.
• Experience with Informatica on-premises products including PowerCenter and Intelligent Data Quality.
• Ability to perform Snowflake Data Cloud and IICS Cloud Administration and performance tuning.
• Experience with IBM Mainframes, including COBOL, JCL, and DB2 analysis.

Preferred Skills

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

Key Skills

Education

Bachelor's Degree