Vitaver & Associates
Data Warehouse Analyst (onsite) Job at Vitaver & Associates in Tallahassee
Vitaver & Associates, Tallahassee, FL, US, 32318
13484 - Data Warehouse Analyst (onsite) - Tallahassee, FL
Start Date: ASAP
Type: Temporary Project
Estimated Duration:12+ months with possible extensions
Work Setting: This job is to be performed onsite Monday-Friday, during business hours. Flexibility for occasional remote work for specific reasons is at the discretion of the hiring manager.
Required:
• IT work experience utilizing data management tools, business intelligence tools, and data warehousing (7+ years);
• Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC tools like IDMC CDI, MI, CAI, etc.) (7+ years);
• Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT);
• Experience administering IDMC platform, Secure Agent Infrastructure and Snowflake Data Cloud platform for statewide adoption;
• Experience with relational database platforms including DB2, SQL Server, Snowflake and Oracle;
• Experience with Redhat Linux application administration like security patching applications, managing disk filesystems, managing wrapper and auto-startup scripts;
• Strong Experience with IDMC Connectors to perform 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;
• Strong development experience with Snowflake Data Cloud;
• Experience with Prototypes, builds and tests Power BI and Cognos reports/dashboards;
• Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration;
• Experience with Informatica IDMC Cloud Performance Tuning;
• Experience with Snowflake Data Cloud Performance Tuning
Preferred:
• Extensive experience with Informatica PowerCenter and Snowflake
Responsibilities include but are not limited to the following:
• Prototypes, builds and tests Power BI and Cognos reports/dashboards;
• Ensures data warehouse metadata is collected and maintained.
• 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.
Why Apply
• Join a company that provides multiple ways to retain great skills and talent: part-time employees have opportunities to become full-time, and skilled temporary employees can become permanent;
• Work with a great team of professionals in a friendly and supportive work environment where management provides all needed direction without micromanagement;
• Work in a safe and secure location with an onsite data center and major dining options within walking distance;
• Benefit from multiple project extensions;
• Get an opportunity to work extra hours to increase your bi-weekly paycheck;
• Receive support and advice from Vitaver consultants who are already working at our Client's site;
• Get extra cash by participating in the Vitaver Successful Completion Bonus Program;
• Always get paid in full and on time.
Start Date: ASAP
Type: Temporary Project
Estimated Duration:12+ months with possible extensions
Work Setting: This job is to be performed onsite Monday-Friday, during business hours. Flexibility for occasional remote work for specific reasons is at the discretion of the hiring manager.
Required:
• IT work experience utilizing data management tools, business intelligence tools, and data warehousing (7+ years);
• Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC tools like IDMC CDI, MI, CAI, etc.) (7+ years);
• Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT);
• Experience administering IDMC platform, Secure Agent Infrastructure and Snowflake Data Cloud platform for statewide adoption;
• Experience with relational database platforms including DB2, SQL Server, Snowflake and Oracle;
• Experience with Redhat Linux application administration like security patching applications, managing disk filesystems, managing wrapper and auto-startup scripts;
• Strong Experience with IDMC Connectors to perform 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;
• Strong development experience with Snowflake Data Cloud;
• Experience with Prototypes, builds and tests Power BI and Cognos reports/dashboards;
• Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration;
• Experience with Informatica IDMC Cloud Performance Tuning;
• Experience with Snowflake Data Cloud Performance Tuning
Preferred:
• Extensive experience with Informatica PowerCenter and Snowflake
Responsibilities include but are not limited to the following:
• Prototypes, builds and tests Power BI and Cognos reports/dashboards;
• Ensures data warehouse metadata is collected and maintained.
• 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.
Why Apply
• Join a company that provides multiple ways to retain great skills and talent: part-time employees have opportunities to become full-time, and skilled temporary employees can become permanent;
• Work with a great team of professionals in a friendly and supportive work environment where management provides all needed direction without micromanagement;
• Work in a safe and secure location with an onsite data center and major dining options within walking distance;
• Benefit from multiple project extensions;
• Get an opportunity to work extra hours to increase your bi-weekly paycheck;
• Receive support and advice from Vitaver consultants who are already working at our Client's site;
• Get extra cash by participating in the Vitaver Successful Completion Bonus Program;
• Always get paid in full and on time.