Data Warehouse Analyst_04/25/2024 EOD_RFQ #

2 weeks ago


Tallahassee, United States BeaconGov Full time
osition: Data Warehouse Analyst
Place of Performance : Onsite -Tallahassee, FL
Duration: 48 Months Aprox

Contractor Qualifications and Experience:
Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:
•Six years of experience with Structured Query Language (PL/SQL) to query Oracle databases.
•Six years of experience with Oracle relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS), serving in high performance, service-oriented, multi-tiered environments.
•Six years of experience with Source Code Control System (SCCS) for the management of internal code changes to Oracle Forms and Reports, Oracle objects, and scripts.
•Microsoft Structured Query Language (MS SQL) Related Experience:
•Six years of experience with MS SQL products inclusive of MS SQL 2008.
•Six years of experience as an MS SQL administrator inclusive of data design and modeling, monitoring, and performance tuning.
•Six years of experience with Structured Query Language (SQL) programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked servers.
•Six years of experience with SQL relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments.
•Six years of experience with configuration management (SourceSafe administration) for SQL database objects.
•Six years of experience with database design tools including ERWin and ERStudio.

Reports Development Experience:
•Six years of experience with independently analyzing and interpreting table structures and relationships to develop complex queries and reports.
•Six years of experience with database navigational and analysis tools, and the ability to recommend the appropriate tool for the appropriate data infrastructure complexity;
•Six years of experience with developing queries and reporting against complex relational databases with preference given to experience with Crystal Reports and ASP to deliver such queries and reports.
•Six years of experience with data integrity evaluation, taking corrective action on identified data problems, and assisting with implementing data quality checks during data intake;
•Six or more years developing queries and reports against the Versa Regulation and Versa Online Commercial Off-the-Shelf (COTS) products.

Contractor Responsibilities
SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified:
•As directed by the Department, develop ad-hoc queries on database schema daily.
•As directed by the Department, provide reporting and data integrity requirements of the licensure data warehouse to the Department's Office of Information Technology (Client) daily.
•As directed by the Department, modify MS SQL T-SQL language daily.
•As directed by the Department, modify MS SQL Database Storage structures tables daily.
•As directed by the Department, modify MS SQL tables view indexes daily.
•As directed by the Department, develop ad-hoc queries on MS SQL Databases daily.
•As directed by the Department, work directly with the Department's Client to manage production promotion for Crystal BO reports daily.
•As directed by the Department, provide analytical services for system incidents and enhancements daily.
•As directed by the Department, process defect tickets to correct system errors within two business days.
•As directed by the Department, process release tickets to manage user requirements within the specific ticket request timeframe. The response due date of tickets assigned will range from one hour to more than one week.
•As directed by the Department, provide analytical services on systems to implement user-defined report requirements monthly.
•As directed by the Department, provide analytical services on systems to identify data integrity issues daily.
•As directed by the Department, facilitate collection of report requirements with the business program staff daily.
•As directed by the Department, deliver code to perform reporting functions as defined in user requirements daily.
•As directed by the Department, document report requirements, business processes, and system processes daily.
•As directed by the Department, perform testing on system changes to meet user-defined requirements daily.
•As directed by the Department, facilitate user acceptance testing (UAT) with the business program staff daily.
•As directed by the Department, facilitate meetings with technical and program staff (scheduling meetings, document decisions, identify issues and action items) daily.
•As directed by the Department, produce work estimates to implement user-defined requirements and system changes daily.
•As directed by the Department, produce status reports on the implementation of user-defined requirements monthly.
•As directed by the Department, produce detailed accounting of hours worked by tasks monthly.
•As directed by the Department, provide analytical services on Department's Client processes to identify operational efficiencies daily.
•As directed by the Department, provide analytical research to satisfy queries requested by the Legislature and Department's management daily.
•As directed by the Department, follow the Department's Client processes and coordinate with other Department IT staff to ensure compliance with Department standards daily.
•Coordinate efforts with the Department's Program Manager to achieve cost savings under this agreement, where feasible and practicable, as directed by the Department. Those efforts include, but are not limited to, identifying common system errors in systems that can be resolved in a manner that achieves cost savings in the State of Florida.

  • Tallahassee, United States Brilliant Infotech Inc Full time

    Job DescriptionJob DescriptionJob Title: Data Warehouse Analyst Location: Tallahassee, FL 32301 Assignment Type: Hybrid Duration: 12 Months (Extendable)Need Local Candidates Due To Work RequirementsDescription: A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing. Extensive experience...


  • Tallahassee, Florida, United States Infojini Full time

    Scope of ServicesResponsible 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 Power Center, Intelligent Data...


  • Tallahassee, United States Crescens Full time

    Job Title: Data Warehouse Director/Manager Location: Tallahassee, FL Duration: 3 Years Job Description : Bachelor's or Master's degree in Data Science, Computer Science, Information Systems, or other related field. Equivalent work experience, including qualified experience in executive leadership or senior organizational development roles, may be substituted...


  • Tallahassee, Florida, United States Two95 International Inc. Full time

        Title – Data Warehouse Analyst     Position – Contract (18+ Months)     Location – Tallahassee, FL     Rate - $Open(Best Possible)  Job Description: Responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development and evaluation of data mining in a data...

  • Warehouse Manager

    4 weeks ago


    Tallahassee, United States Dinjob Full time

    The Warehouse Manager is responsible for providing leadership to a core team of associates responsible for the receiving and replenishment of merchandise ensuring the sales floor is well presented and product is available for sale to the customer. ThWarehouse Manager, Manager, Warehouse, Management, Retail, Receiving **Select basic ads** Ads can be shown to...

  • Warehouse Manager

    3 weeks ago


    Tallahassee, United States Gobolt Full time

    **Warehouse Manager** Medley, Florida We are looking to hire a Warehouse Manager to help build, manage, and scale our fulfillment operations in Medley, Florida. We are an adaptable, solution-focused, fast-paced team looking for energetic people who would like to have a rare opportunity to join one of the fastest growing companies. Founded in 2017, Bolt...

  • Data Architect

    2 weeks ago


    Tallahassee, United States Crescens Full time

    Title: Data Architect Location: Tallahassee, FL Duration: 12+ Months Type: Contract Job Description: Bachelor's or Master's degree in Computer Science, Information Systems, or other related field. Equivalent work experience may be substituted for the educational requirements at a rate of one year of experience for one year of education. Five years of...

  • Data Architect

    2 weeks ago


    Tallahassee, United States Crescens Full time

    Title: Data Architect Location: Tallahassee, FL Duration: 12+ Months Type: Contract Job Description: Bachelor's or Master's degree in Computer Science, Information Systems, or other related field. Equivalent work experience may be substituted for the educational requirements at a rate of one year of experience for one year of education. Five years of...


  • Tallahassee, United States International Rescue Committee Full time

    Requisition ID: req51725 Job Title: Summer 2024 Anti-Trafficking Casework Intern Sector: Social Work Employment Category: Intern Employment Type: Part-Time Compensation: USD 0.00 - 0.00 Annually Location: Tallahassee, FL USA Work Arrangement: Hybrid Job Description Background: The International Rescue Committee (IRC) responds to the world's worst...


  • Tallahassee, United States Comprehensive Resources Inc Full time

    Role:Project Lead with Data Analyticts with Informatica ExperienceExp:10+yearsLoc:Tallahassee,FL(Onsite)Responsibilities:• Data Discovery and Inventory: Identify, catalog, and classify data assets, including datasets, databases, and metadata.• Catalog Metadata Management: Work with data stewards to develop and maintain standardized metadata descriptions...


  • Tallahassee, United States Comprehensive Resources Full time

    Role:Project Lead with Data Analyticts with Informatica Experience Exp:10+years Loc:Tallahassee,FL(Onsite) Responsibilities: Data Discovery and Inventory: Identify, catalog, and classify data assets, including datasets, databases, and metadata. Catalog Metadata Management: Work with data stewards to develop and maintain standardized metadata descriptions...


  • Tallahassee, United States Comprehensive Resources Inc Full time

    Role:Project Lead with Data Analyticts with Informatica ExperienceExp:10+yearsLoc:Tallahassee,FL(Onsite)Responsibilities:• Data Discovery and Inventory: Identify, catalog, and classify data assets, including datasets, databases, and metadata.• Catalog Metadata Management: Work with data stewards to develop and maintain standardized metadata descriptions...


  • Tallahassee, United States Crescens Full time

    Job Title: - Advanced Applications Architect Location: Tallahassee, FL Duration: 7+ months QUALIFICATIONS AND EXPERIENCE: years of total application development experience. years of IT infrastructure experience. years enterprise architecture experience. years of experience in Object oriented programming. years of experience with SQL scripting and...


  • Tallahassee, United States Crescens Full time

    Job Title: - Advanced Applications Architect Location: Tallahassee, FL Duration: 7+ months QUALIFICATIONS AND EXPERIENCE: years of total application development experience. years of IT infrastructure experience. years enterprise architecture experience. years of experience in Object oriented programming. years of experience with SQL scripting and...

  • .net Architect

    2 weeks ago


    Tallahassee, United States Resource Informatics Group Full time

    Job Description Job Title: .net Architect Job Location: Tallahassee, FL Job Duration: Contract through June + extensions Job Overview: Advanced Applications Architect necessary to support the software development and data operations of the Office of Children's Medical Services (CMS) Managed Care Plan. Required Experience: Ten years of total application...

  • .net Architect

    5 days ago


    Tallahassee, United States Resource Informatics Group Full time

    Job Description Job Title: .net Architect Job Location: Tallahassee, FL Job Duration: Contract through June + extensions Job Overview: Advanced Applications Architect necessary to support the software development and data operations of the Office of Children's Medical Services (CMS) Managed Care Plan. Required Experience: Ten years of total application...

  • Net Architect

    2 weeks ago


    Tallahassee, United States The Talent Source Full time

    Multi-Year Contract engagement thru June 30, 2027 Hybrid Role with some travel to Tallahassee, FL on an ad hoc basis. Florida residents preferred. The Talent Source is looking to engage a .Net Azure Architect with proven experience in the .Net, Azure development stack for a direct contract with a large Florida Agency. Applications closing May 6th so please...

  • Net Architect

    5 days ago


    Tallahassee, United States The Talent Source Full time

    Multi-Year Contract engagement thru June 30, 2027 Hybrid Role with some travel to Tallahassee, FL on an ad hoc basis. Florida residents preferred. The Talent Source is looking to engage a .Net Azure Architect with proven experience in the .Net, Azure development stack for a direct contract with a large Florida Agency. Applications closing May 6th so please...

  • Communications Intern

    4 weeks ago


    Tallahassee, Florida, United States International Rescue Committee Full time

    The International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations...


  • Tallahassee, United States InsideHigherEd Full time

    Tallahassee Community College announces openings for Wellness Adjunct Faculty positions for the 2024-25 academic year.Adjunct Faculty Minimum Qualifications: Requires a Master’s degree in health education, public health, wellness, fitness, physical education, or field related to good health and positive life skills or 18 graduate semester hours in health...