DataWarehouseAnalyst

Job Details:

Job Title: Data Warehouse Analyst

Duration: 12 Months with a high possibility of extension

Location: Tallahassee, FL (Onsite from Day One)

Required Skills: -

*) 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 is preferred.

*) 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 Power Exchange.

*) 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

*) Experience with Data Governance products, like EDC, Axon, and CDGC

Job Duties & Task:

*) 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.