Data Warehouse Analyst, Job at vTech Solution, Florida

S1hieGtaa3NuZmk2Y010UHh6SElXaW1HcFE9PQ==
  • 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

meati™

Quality Manager Job at meati™

 ...free of the top nine allergens. You can find Meati in 7,000 stores nationwide, including the Kroger family of stores, Albertsons and Safeway stores, Super Target, Whole Foods Market, Sprouts Farmers Market, Meijer, Fresh Thyme, Natural Grocers, Wegmans, and many more! It'... 

Gpac

Family Law Attorney Job at Gpac

Family Law Litigation Attorney About Us: We are a well-established, client-focused law firm specializing in family law matters. We are dedicated to providing compassionate, effective, and results-driven legal services to families throughout California. We handle a wide... 

DLS Events @ CineVita

Cocktail Server Job at DLS Events @ CineVita

Seeking experienced and accomplished Cocktail Servers for new theatre-in-the-round LIVE, immersive show and venue located on the SoFi Stadium / Hollywood Park campus in Inglewood. If you are a nightlife pro with table service chops and love being a part of the fun, our...

Cornerstone Rehab

Physical Therapy Assistant Job at Cornerstone Rehab

 ...We are hiring a Physical Therapy Assistant to deliver care to our patients and work with a diverse team of clinical professionals. *Sign-On Bonus...  ...in accordance with patients' needs and capabilities Travel to nearby centers as needed Qualifications: Valid State... 

Harmony House Assisted Living

Caregiver Job at Harmony House Assisted Living

 ...Join Our Team as a Caregiver at Harmony House! Are you passionate about making a difference in the lives of others? At Harmony House...  ...patient, and eager to help others live their best lives. No prior experience? No problem! We welcome individuals who are ready to learn and...