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:
McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being...
...(e.g. H-1B visa status), nor is th e State able to provide extensions of optional practical training (OPT) under the STEM-designated degree program for F-1 students. To be considered for permanent employment with the State of Illinois, applicants must be currently authorized...
...problems, leveraging tools and resources to take extreme ownership and solve or escalate as appropriate for additional support in a timely manner. Research / Resourcefulness - Demonstrates curiosity and interest in continuous learning. Confidently follows procedures...
Welcome to the first truly immersive Cannabis experience in Michigan. We are looking for high-energy, cannabis-focused people to be part of our team. At Gatsby, we truly believe in a team-first mentality as well as providing the most knowledgeable and pleasant experience...
...This posting is for both part time and full time candidates. KOCHI is a upscale Korean restaurant located in Hell's Kitchen awarded one Michelin star 2021 and 2022 If you have a passion for food, and interested in Korean cuisine, this is the place for you. Work...