Data Warehouse Analyst Job at Cloud Analytics Technologies LLC, Tallahassee, FL

U0xTR2JkRXlCYkdlbWd2ZFBNa2tidzQ4aHc9PQ==
  • Cloud Analytics Technologies LLC
  • Tallahassee, FL

Job Description

Primary Job Duties :-

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

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

Job Tags

Similar Jobs

Swatch Group

Inventory Control Coordinator Job at Swatch Group

The Swatch Group is seeking an Inventory Control Coordinator in Secaucus, NJ. This role involves managing inventory levels, coordinating with departments, conducting audits, and implementing strategies to optimize stock availability. Candidates should have at least 2 years... 

24th Street Dental Biltmore

DA / Front Desk Floater For Delta Premier Office Job at 24th Street Dental Biltmore

 ...to be part of an awesome, growing, dynamic private (non-corporate) office! About We are Fee For Service & only in network with Delta Premier - we prefer QUALITY over quantity. Founded 40 yrs ago by Dr Ginger Price (one of top cosmetic dentists on US west coast)... 

Covance Inc.

Lab Manager - Anatomic Pathology Job at Covance Inc.

 ...LabCorp is seeking an Anatomic Pathology Manager to join our team at Tufts Medical Center in Boston, MA . This position will be responsible for overseeing the operations and administration of the Anatomic Pathology laboratory- Histology and Cytology. Additionally,... 

Snaphunt

Utility Locate Manager Job at Snaphunt

 ...locating services in support of Horizontal Directional Drilling (HDD) operations throughout Illinois, Michigan and Indiana. This contractor role is responsible for coordinating locating activities, ensuring accurate utility identification prior to drilling, and supporting... 

Glance

Videographer Job at Glance

 ...Summary: The videographer will shoot footage and assist in editing. The videographer will accomplish the bulk of the technical tasks related to production and post-production. He or she will transport, set up, and operate equipment; and assist with staging, set preparation...