Data Warehouse Analyst

Overview

On Site
$50 - $55 hourly
Contract - W2
Contract - Temp

Skills

Data Integration
System Requirements
Evaluation
Database Architecture
Data Management
Informatica PowerCenter
Data Mining
Data Analysis
Reporting
IT Consulting
Prototyping
Test Scripts
Replication
Extraction
Data Modeling
Scripting
Business Intelligence
Microsoft Power BI
Tableau
Data Quality
ELT
Change Data Capture
Informatica PowerExchange
IBM Mainframe
COBOL
JCL
IBM DB2
Data Warehouse
Meta-data Management
Informatica
Snow Flake Schema
Cloud Computing
Performance Tuning
Data Governance
EDC
Artificial Intelligence
Messaging

Job Details

RESPONSIBILITIES:
Kforce has a client in Tallahassee, FL that is seeking a Data Warehouse Analyst. This person must have 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.

Responsibilities:
* Gathering and assessing business information needs and preparing system requirements
* Performs analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment which includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog
* Uses data mining and data analysis tools including Power BI and Tableau
* Reviews and validates data loaded into the data warehouse for accuracy. Interacts with user community to produce reporting requirements
* Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage
* Responsible for prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population including data replication, extraction, loading, cleansing, and transforming the data
* Responsible for enterprise data modeling
* Maintains knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment

REQUIREMENTS:
* 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

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Kforce Technology Staffing