Data Warehouse Analyst

IT Data Solutions

IT Data Solutions is looking for a Data Warehouse Analyst to join their team. This role is essential in building and optimizing data warehouse solutions, particularly using Snowflake and Informatica IICS Cloud Data Integration tools. The ideal candidate will play a strategic role in planning and developing enterprise data warehouses while supporting reporting and analytics functions.

In this role you can expect to have the responsibilities:

• Lead data integration and data warehousing using Snowflake and Informatica IICS Cloud Data Integration tools.
• Manage ETL or ELT tasks including data extraction, transformation, and loading.
• Participate in strategic planning for warehouse design and development.
• Analyze transactional data stores and develop models for optimal reporting and analytics.
• Mentor peers in data warehousing concepts and tools.
• Prototype, build, and test reports and dashboards using Power BI and Tableau.
• Develop and maintain documentation for methods and practices.

This role comes with the following benefits:

This role requires you to have:

• Data integration and data warehousing experience.
• Experience with Snowflake Data Cloud and Informatica IICS.
• Experience with ETL or ELT tasks.
• Proficiency in designing data models for BI tools like Power BI and Tableau.

You would benefit from having:

• Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
• Experience with data governance products like EDC, Axon, and CDGC.
• Experience with Informatica IICS and Snowflake performance tuning.

A Bachelor's Degree in Computer Science, Information Systems, or a related field is required, though equivalent work experience may be considered. The role requires three days on-site per week.