Title: Data Warehouse Analyst
Experience
At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions. Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake. Experience with Data Governance products, like EDC, Axon, and CDGC.
Primary Job Duties/ Tasks
- Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
- Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
- Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
- Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.
- Coaches and mentors’ peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
- Prototypes, builds, and tests Power BI and Tableau reports and dashboards.
Assists with the development and maintenance of methods and practices documentation
Job Specific Knowledge, Skills, and Abilities
- Experience designing data models for Business Intelligence tools like Power BI and Tableau.
- Experience with Informatica on-premises products like PowerCenter and Data Quality.
- Experience with ELT with Change Data Capture solutions like PowerExchange.
- Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
- Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
- Ensures data warehouse metadata is collected and maintained.
- Experience with Informatica IICS Cloud Performance Tuning
- Experience with Snowflake Data Cloud Performance Tuning