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:
...experience in general construction. ~ Basic knowledge of tools and construction practices. ~ Some experience with carpentry, demolition, framing, drywall installation or repair, tile work, remodeling, or plumbing. ~ Must be proficient with using a tape measure....
...specific details for this role. Job Description We are currently seeking Associates to join our Financial Institutions Investment Banking practice in New York. The day-to-day responsibilities of an Associate include: financial analysis and modeling, managing a team...
...We're Hiring! Mutual of Omaha Mortgage is looking for experienced, self-sourced Loan Officers in Florida! If youre passionate about helping clients achieve their homeownership goals and want to work with a well-respected, trusted brand, we want to hear from you....
...will make an impact by designing and developing user-friendly web applications and reusable components that deliver exceptional user... ...To Have To Be Considered 6+ years of experience in React.js development and full-stack proficiency. Strong expertise in React.js,...
...based. Join Serenity. Serenity Healthcare was started by a psychiatrist that believes mental health care should be more than just... ...What You Need: Board certification by the American Board of Psychiatry and Neurology Licensed, or willing to become licensed, in...