Data Warehouse Analyst, Job at vTech Solution, Florida

QmhBc1MyQUVYV1lablRxUm1QaFJmSFdzNlE9PQ==
  • vTech Solution
  • Florida

Job Description

Job Summary:


The Data Warehouse Analyst is responsible for gathering business requirements, developing system requirements, and performing data mining analyses within a Snowflake cloud data warehouse environment. This includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog. The analyst will also use data mining and analysis tools like Power BI and Tableau to produce reporting requirements, validate data accuracy, and provide technical consulting to users.

Location: Florida, United States,

Responsibilities:


- Gathering and assessing business information needs and preparing system requirements.
- Performing analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment.
- Utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog.
- Using data mining and data analysis tools including Power BI and Tableau.
- Reviewing and validating data loaded into the data warehouse for accuracy.
- Interacting with user community to produce reporting requirements.
- Providing technical consulting to users of the various data stores and advising users on conflicts and inappropriate data usage.
- Prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population including data replication, extraction, loading, cleansing, and transforming the data.
- Enterprise data modeling.
- Maintaining knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment.
- Analyzing transactional data stores and developing data warehouse models to optimize the warehouse for reporting and analytics.
- Assisting with the development and maintenance of methods and practices documentation.
- Ensuring data warehouse metadata is collected and maintained.
- Prototyping, building and testing Power BI and Cognos reports/dashboards.

Required Skills & Certifications:

Preferred Skills & Certifications:

Special Considerations:

Scheduling:

Job Tags

Similar Jobs

Huntington Learning Center of Pleasanton

After School Teacher Job at Huntington Learning Center of Pleasanton

 ..., Pleasanton, CA 94588, USA. Job Position: In-person after-school teacher. We are looking for qualified candidates with min. Bachelor...  ...for you. Year-round flexible hours: Our after-school and summer hours adapt to your changing schedule. Since no preparation... 

Caduceus Medical Logistics

Medical Courier Driver Job at Caduceus Medical Logistics

 ...Job Description Medical Courier driver needed, Monday through Friday, plus on-call weekends. Good pay for good drivers, easy work for responsible drivers. Perfect for the semi-retired and Uber/Lyft Drivers who can set their own schedules, veterans encouraged to apply.... 

Sysco

Human Resources Coordinator Job at Sysco

 ...claims processes, onboarding and exit interviews, transitional return to work, leave administration, OSHA reporting, etc.). Support hiring managers and Talent Acquisition to support recruitment and staffing plans. Aid Human Resource Business Partner (HRBP) to drive... 

Insta360

Video Producer Job at Insta360

Requirements:- Bachelor degree or above, major in directing, film photography, animation design, advertising and media related majors...  ...and lighting equipment, familiar with video software and video production and editing process; Experience with digital content such as... 

Sysco

CDL A Delivery Truck Driver $33.79/hr up to $110K Job at Sysco

Job Summary:Earn no less than $33.79/hr at base rate with performance incentives that can push your hourly rate to $48.66/hr, and up to $110K per year. Sysco has immediate job openings for dependable CDL A Delivery Truck Driver Trainee to safely operate a tractor-trailer...