Data Warehouse Analyst

RESPONSIBILITIES:
Kforce has a client that is seeking a Data Warehouse Analyst in Tallahassee, FL.

Duties:
* Data Warehouse Analyst will be responsible for administration and maintaining Informatica IDMC services including Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, and API Center, ensuring platform stability and optimal configuration across projects
* Deploy, configure, and upgrade Informatica Secure Agents on Red Hat Enterprise Linux (RHEL) servers; Implement agent failover, load balancing, and manage cipher suites and secure communications (TLS/SSL)
* Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics
* Assists with the development and maintenance of methods and practices documentation
* Ensures data warehouse metadata is collected and maintained

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
* Strong Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC tools like IDMC CDI, MI, CAI, etc.)
* Strong experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
* Experience administering IDMC platform, Secure Agent Infrastructure and Snowflake Data Cloud platform for statewide adoption
* Experience with Redhat Linux application administration like security patching applications, managing disk filesystems, managing wrapper and auto-startup scripts
* Strong experience with IDMC Connectors performing Change Data Capture solutions like PowerExchange and other widely used connectors like relational, ServiceNow, etc.
* Experience with IBM Mainframes COBOL, JCL, and DB2 analysis
* Experience designing data models for Business Intelligence tools like Power BI and Cognos
* Experience with Informatica on-premises products like PowerCenter and Data Quality
* Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration
* Experience with Informatica IDMC Cloud Performance Tuning
* Experience with Snowflake Data Cloud Performance Tuning
* Knowledge of and skill in relational database platforms including DB2, SQL Server, Snowflake and Oracle
* Strong development experience with Snowflake Data Cloud
* Prototypes, builds and tests Power BI and Cognos reports/dashboards

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.