DataWarehouseAnalyst

Overview

Job title:

Data Warehouse Analyst

Employer:

Dataman

USA, LLC (via Dice)

Location:

Tallahassee, FL (Onsite from Day One)

Duration: 12+ Months with a high possibility of extension

• 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.

• 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 Power Center 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.

• Seniority level:
  Mid-Senior level
• Employment type:
  
  Full-time
• Industries:
  Software Development
• Job function:
  Information Technology

Note:

This refined description removes boilerplate and extraneous postings, preserving the core responsibilities and qualifications for the Data Warehouse Analyst role.