What are the responsibilities and job description for the Data Warehouse Analyst position at Kforce Technology Staffing?
Job Details
RESPONSIBILITIES:
Kforce has a client that is seeking a Data Warehouse Analyst in Tallahassee, FL.
Key Tasks:
* Data Warehouse Analyst will be responsible for gathering and assessing business information needs and preparing system requirements
* Performs 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
* Uses 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
* As a Data Warehouse Analyst, you will provide 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
* Maintains knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment
REQUIREMENTS:
* Bachelor's degree in Computer Science, Information Systems, or other related field; Or equivalent work experience
* A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing; Extensive experience with Informatica PowerCenter and Snowflake is preferred
* Extensive knowledge of data warehouse and data mart concepts
* Extensive knowledge of and expert skill in use of Informatica PowerCenter and Cloud functionality
* Extensive Knowledge of and expert skill in administration of Informatica and Snowflake
* Knowledge of and skill in Snowflake cloud data warehouse functionality
* Knowledge of and skill in Informatica Data Quality functionality
* Knowledge of and skill in Informatica Data Catalog functionality
* Knowledge of and skill in Power BI functionality
* Knowledge of and skill in Tableau functionality
* Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle
* Ability to model transactional data for data warehousing usage
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Kforce has a client that is seeking a Data Warehouse Analyst in Tallahassee, FL.
Key Tasks:
* Data Warehouse Analyst will be responsible for gathering and assessing business information needs and preparing system requirements
* Performs 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
* Uses 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
* As a Data Warehouse Analyst, you will provide 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
* Maintains knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment
REQUIREMENTS:
* Bachelor's degree in Computer Science, Information Systems, or other related field; Or equivalent work experience
* A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing; Extensive experience with Informatica PowerCenter and Snowflake is preferred
* Extensive knowledge of data warehouse and data mart concepts
* Extensive knowledge of and expert skill in use of Informatica PowerCenter and Cloud functionality
* Extensive Knowledge of and expert skill in administration of Informatica and Snowflake
* Knowledge of and skill in Snowflake cloud data warehouse functionality
* Knowledge of and skill in Informatica Data Quality functionality
* Knowledge of and skill in Informatica Data Catalog functionality
* Knowledge of and skill in Power BI functionality
* Knowledge of and skill in Tableau functionality
* Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle
* Ability to model transactional data for data warehousing usage
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
