Jobs via Dice ยท 3 days ago
Data Warehouse Analyst
Tallahassee, FL
Full-time
Onsite
Senior Level
7+ years expKforce has a client in Tallahassee, FL seeking a Data Warehouse Analyst with extensive experience in data management and business intelligence tools. The role involves gathering business information needs, performing data analyses in a Snowflake environment, and providing technical consulting to users.
Computer Software
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
Qualification
Required
At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions
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
Preferred
Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake
Benefits
Medical/dental/vision insurance
HSA
FSA
401(k)
Life, disability & ADD insurance
Paid time off
Paid sick leave
Company
Jobs via Dice
Welcome to Jobs via Dice, the go-to destination for discovering the tech jobs you want.
0-1 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase