Data Warehouse Specialist

2 weeks ago


Tallahassee, United States TekBank Full time

Data Warehouse/Business Intelligence


  • We are unable to sponsor visas for this role
  • Position: Data Warehouse/Business Intelligence Specialist
  • Location: Tallahassee, FL (on-site)
  • Compensation: $73 - $75/hr C2C OR 1099



Experience:


  • Minimum of 5 years of hands-on experience in Data Warehouse implementation, database design, and database administration (DBA).
  • Proven track record of implementing and maintaining Oracle Data Warehouse and Business Intelligence tools, including:
  • Oracle Analytics Cloud (OAC)
  • Oracle Analytical Server (OAS)
  • Oracle Cloud Infrastructure (OCI)
  • Oracle Business Intelligence (OBI)
  • Oracle Data Integrator (ODI)
  • Extensive experience in data modeling (logical and semantic) and metadata management.
  • Proficiency in SQL, OLAP, star and snowflake schemas, ETL processes, Informatica, Tidal, and Business Intelligence Application Configuration Manager (BIACM).


Skills:


  • Expertise in data visualization, analytical thinking, attention to detail, and problem-solving.
  • Strong ability to analyze database tables, materialized views, data sets, and reports to identify and resolve gaps.


Test Planning and Coordination Resource


  • Minimum of 5 years of experience in coordinating and planning complex testing activities for large ERP implementations.
  • Hands-on experience in conducting various types of testing (automated, manual, integration) on large-scale IT projects.
  • Proficiency in developing comprehensive testing plans that cover all integration partners, interfaces, and business processes.


Financial Reporting Resource


  • Minimum of 5 years of experience in financial reporting for generating Annual Comprehensive Financial Reports (ACFR) within a PeopleSoft system, specifically for governmental agencies.
  • Extensive experience in reconciling general ledgers and supporting ledgers to source modules for accurate financial reporting.
  • Proficiency in configuring and managing financial reporting trees within PeopleSoft.
  • Experience in developing complex queries to support financial reconciliation and reporting, as well as identifying the sources of issues.
  • Experience in integrating financial reporting data with external systems used for ACFR generation.


Purchasing/Accounts Payable Resource


  • Minimum of 5 years of experience in implementing and supporting purchase order (PO) and accounts payable (AP) modules within a PeopleSoft system for governmental agencies.
  • Experience in adapting PeopleSoft PO/AP modules to meet the unique needs of governmental agencies.
  • Proficiency in developing complex queries within PeopleSoft for data analysis and reporting.
  • Experience integrating PeopleSoft with other large ERP applications.


Preferred Qualifications


Government Experience:


  • Experience working with state or similar government entities in terms of annual budget and FTE employee count.
  • Previous experience implementing PeopleSoft in local and state governments.


Technical Proficiency:


  • Strong knowledge of Microsoft Office Suite, SharePoint, Visio, and MS Project.
  • Experience with PeopleTools 8.59+ and fluid page development.
  • Expertise in PeopleSoft Financials, Human Capital Management (HCM), and associated Business Intelligence Reporting Solutions and ADW.


Certifications:


  • Professional certifications such as Oracle Certified Expert, Oracle Certified Implementation Specialist, Oracle Certified Professional (OCP), Certified Data Management Professional (CDMP), or other related certifications.


*

TekBank is committed to a diverse and inclusive workplace. TekBank is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status



  • Tallahassee, United States TekBank Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Specialist to join our team at TekBank. As a key member of our organization, you will be responsible for designing, implementing, and maintaining our data warehouse and business intelligence systems.Key ResponsibilitiesData Warehouse Implementation: Design and implement data warehouse solutions...


  • Tallahassee, United States TekBank Full time

    Data Warehouse/Business Intelligence We are unable to sponsor visas for this rolePosition: Data Warehouse/Business Intelligence SpecialistLocation: Tallahassee, FL (on-site)Compensation: $73 - $75/hr C2C OR 1099Experience:Minimum of 5 years of hands-on experience in Data Warehouse implementation, database design, and database administration (DBA).Proven...


  • Tallahassee, United States Lifescale Analytics Full time

    Who we are: Lifescale Analytics, a woman-owned small business (WBENC and WOSB certifications) provides specialized expertise in data and analytics. Formed in 2012, the Lifescale Analytics team has years of experience providing a spectrum of customized data management services and solutions including Data Management/Analytics, Big Data Solutions, Cloud...


  • Tallahassee, United States RADIANT Full time

    Position: Data Warehouse Analyst Location: Tallahassee, FL (Onsite) Education: • Bachelor’s Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement. Experience: • At least 7 years of IT experience utilizing data management, business intelligence tools, and...


  • Tallahassee, United States RADIANT Full time

    Position: Data Warehouse AnalystLocation: Tallahassee, FL (Onsite)Education:• Bachelor’s Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement.Experience:• At least 7 years of IT experience utilizing data management, business intelligence tools, and strong...


  • Tallahassee, United States SGS Technologie Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Analyst to join our team at SGS Technologie. As a Data Warehouse Analyst, you will play a critical role in designing, developing, and maintaining our enterprise data warehouse and data-lake-house architecture.Key ResponsibilitiesDesign and develop data models for Business Intelligence tools like...


  • Tallahassee, United States AppleOne Technical Staffing Full time

    Project Scope: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,...


  • Tallahassee, United States AppleOne Technical Staffing Full time

    Project Scope: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,...

  • Data warehouse manager

    3 months ago


    Tallahassee, United States Resource Informatics Group Full time

    The Data Warehouse Manager will serve as the principal line of communication for the project team. The duties and responsibilities of this position are as follows: Document the current state of the IBM DB2 databases, including but not limited to their structure, data dictionaries, data flow, interdependencies, and potential problem area. Design, develop, and...


  • Tallahassee, United States Tal Search Group, Inc. Full time

    Job Title: Data Warehouse Analyst (Due 9-12)Location: Tallahassee, Florida (Hybrid / 3 days in office )Duration: 1 yr, plus extensionRate: W2 + CHPStart Date: October, 2024Scope of Work:Responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development, and evaluation of data mining in the...


  • Tallahassee, United States Lifescale Analytics Full time

    At Lifescale Analytics, we help achieve data driven decisions by leveraging strategic technologies to create innovative solutions, that ultimately help our clients to navigate their ever-changing data landscape. We have an opportunity for a Data Warehouse Analyst. This role will be an Onsite Role, candidates will be required to be onsite a minimum of 3 days...


  • Tallahassee, United States TECKpert Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Architect to join our team at TECKpert. As a key member of our data management team, you will play a critical role in designing, developing, and managing data solutions within the Snowflake cloud data warehouse environment.Key ResponsibilitiesAssess business information needs and develop system...

  • Data Warehouse Analyst

    2 months ago


    Tallahassee, United States Infojini Full time

    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. Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage. Responsible for...


  • Tallahassee, United States ARK Solutions, Inc. Full time

    Data Warehouse AnalystTallahassee, FLHybrid RoleJob Description: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...


  • Tallahassee, United States ARK Solutions, Inc. Full time

    Data Warehouse AnalystTallahassee, FLHybrid RoleJob Description: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...


  • Tallahassee, United States Compu-Vision Consulting Full time

    Job Title: Data Warehouse Analyst, C. Advanced Location: Tallahassee, FL 32301 Duration: 12 months Scope of Services: 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...


  • Tallahassee, United States Compu-Vision Consulting Full time

    Job Title: Data Warehouse Analyst, C. Advanced Location: Tallahassee, FL 32301 Duration: 12 months Scope of Services: 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...

  • Cloud Data Analyst

    4 days ago


    Tallahassee, United States Lifescale Analytics Full time

    About the RoleLifescale Analytics is seeking a highly skilled Data Warehouse Specialist to join our team. As a Data Warehouse Specialist, you will play a critical role in helping our clients achieve data-driven decisions by leveraging strategic technologies to create innovative solutions.Key ResponsibilitiesData Integration and Warehousing: Design, develop,...


  • Tallahassee, United States Infojini Full time

    About the RoleAs a Data Warehouse Business Intelligence Analyst at Infojini, you will be responsible for leveraging data mining and data analysis tools, including Power BI and Tableau, to drive business insights and decision-making. Your expertise will be crucial in reviewing and validating data loaded into the data warehouse for accuracy, ensuring that our...


  • Tallahassee, United States TECKpert Full time

    We are looking for a Data Warehouse Analyst / BI Architectto support our client based in Tallahassee, Florida. US BASED CANDIDATES ONLY.   This is an onsite position based in Tallahassee office, FL.   *No third parties and no sponsorship* Who we are Founded in 2009 and headquartered in beautiful Miami, FL, TECKpert is a tech consulting and staff...