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:
Data Governance Manager Location Little Rock, AR : The Manager Data Governance role will build, implement and ensure adherence to an enterprise data governance framework for data practices, policies, and standards both at a technical and functional level. This role will...
Heartland Concepts, who owns and operates Auntie Annes Pretzels, Planet Smoothie is currently seeking applications for Crew Members at all of our locations. We have locations at Westroads Mall, , Nebraska Crossing and Gateway Mall in Lincoln. Minimum age is 16 years old...
Enhance the ALDI customer shopping experience in a collaborative team environment as an ALDI Cashier or Stocker. As a member of our team, youll be operating the registers or other machinery, stocking our shelves, keeping our stores looking their best, and serving our...
...Overview Catholic Charities of Buffalo is hiring a Psychiatric Nurse Practitioner for our Behavioral Health Program with Monsignor Carr... ...records and telemedicine platforms, and EMR systems. ~ Requires travel to provide in-person services at various clinics as needed...
...unlock the full potential of their referrals. As we prepare for the next stage of growth, were looking for a visionary Chief Marketing Officer to join our team. This is an equity-only position, offering a unique opportunity to take ownership and shape the future of...