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.
Never miss an opportunity! Create an alert based on the job you applied for.
