Apply on Employer Site

Lifescale Analytics · 2 weeks ago

Data Warehouse Analyst - Senior

Tallahassee, FL

Full-time

Onsite

Senior Level

LifeScale Analytics helps achieve data driven decisions by leveraging strategic technologies to create innovative solutions. They are seeking a Senior Data Warehouse Analyst responsible for gathering business information needs, performing data analysis, and managing data within the Snowflake cloud environment.

AnalyticsConsultingSoftware

No H1B

U.S. Citizen Only

Responsibilities

Responsible for gathering and assessing business information needs and preparing system requirements

Perform analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment which includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog

Use data mining and data analysis tools including Power BI and Tableau

Reviews and validates data loaded into the data warehouse for accuracy

Interacts with user community to produce reporting requirements

Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage

Responsible for prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population including data replication, extraction, loading, cleansing, and transforming the data

Responsible for enterprise data modeling

Maintain knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment

Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools

Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks

Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development

Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics

Coaches and mentors’ peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse

Prototypes, builds, and tests Power BI and Tableau reports and dashboards

Assists with the development and maintenance of methods and practices documentation

Qualification

Snowflake Data CloudInformatica PowerCenterData IntegrationPower BITableauData GovernanceELT with Change Data CaptureIBM Mainframes COBOLIICS Cloud AdministrationCustomer ServiceTeam BuildingCommunicationProblem SolvingLeadership