Description

You will manage ETL processes and data warehouse lifecycles to support enterprise business intelligence needs.

Responsibilities

• Build and maintain new data marts and support data migration through ETL processes.
• Manage the lifecycle of physical data models and data maps for the data warehouse system.
• Troubleshoot data integrity issues and resolve technical problems for end users and programmers.
• Coordinate, schedule, and test upgrades to the data warehouse system.
• Collaborate with tech leads, database administrators, and systems administrators on system configuration and security administration.

Required Skills

• 7+ years of experience in Enterprise Data Warehouse, Business Intelligence, and analytic computing.
• 2+ years of experience with Informatica IICS.
• 2+ years of experience with Oracle RDBMS, PL/SQL, and SQL Server platforms.
• Strong proficiency in SQL and data analysis.
• Proven ability to perform pattern identification and troubleshoot complex data integrity issues.
• Bachelor’s degree in a relevant field.

Preferred Skills

• Experience with Snowflake.
• Experience documenting source-to-target and source-to-ETL mappings for high-complexity projects.
• Experience with reporting tools including Cognos, Oracle Analytics Cloud, or Microsoft Power BI.

Key Skills

Education

bachelor’s degree