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:
Position Title: Office Team AdministratorLocation: Earth City, MOOrganization: Lou Fusz AthleticJob Type: Full -TimeBenefits:... ...sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or...
...supplement your income as a Delivery Driver? Are you looking for part-time opportunities? Priority Dispatch is looking for Delivery... ...Kentucky. What we have available: Pick up times are during 2nd shift hours M-F and weekends. Need a large car, mini van or SUV....
...requests are allocated and response acquired. This will include Railway, Highway, pipeline, environmental, heritage, and other crossings as required. Should be able to perform field survey based on requirement. Adhere to and promote the environmental, health &...
...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...
Our client, a reputable and client-focused law firm, is seeking a skilled Immigration Attorney to join their team. This is an excellent opportunity for a dedicated legal professional with a strong background in immigration law and a genuine passion for guiding clients through...