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:
...been behind some of the worlds most-played games, from the classic Solitaire that came... ...seeking a creative and passionate Game Designer to join our Games team. This role will serve... ...trends, best practices, and Arkadiums internal standards of excellence; Oversee game...
...Director of Hospice Operations (RN) Location: Onsite / Regional Type: Full-Time Compensation: $100,000$120,000 base + performance bonus Reports To: Managing Director Status: Exempt Role Summary We are seeking a Director...
Position Summary: Help make the American dream come true for immigrants! This is an exciting opportunity to grow your career with one of the largest law firms in the United States. Ogletree Deakins is an international law firm with 60 offices throughout North America...
...As an independent developer and publisher, Templar develops the games that we want, on our own schedule. We are actively staffing up... ...relatively low cost of living. About the Role : As a Senior Game Designer at Templar Media, youll play a key part in shaping the...
...making, interpersonal, communication, planning, and execution skills. A proactive drive to learn. Genuine passion for coffee, food, or baking. A strong work ethic. Plain Vanilla Bakery it started out with a simple, earnest ambition to create and share some...