Sign upLog in
See more jobs

3430: Data Warehouse Analyst (B. Intermediate)

Abacus Service Corporation

  • Tallahassee, FL
  • 2 days ago

    Highlights

    Request for Quote 2. Overview 2.1 The Florida Department of Transportation (Department) is requesting resumes and hourly rate quotes for staff augmentation resources meeting the specific Knowledge, Skills, and Abilities (KSAs) listed below. The Department will avoid Organizational Conflict of Interest through mitigation efforts in three categories: A. " Unequal Access " wherein an unfair competitive advantage surfaces when a Vendor obtains information not generally available to other competitors, and where such information would assist them in winning the contract over their competitors.

    Numbers & Facts

    LocationTallahassee, FL

    Description

    FDOT Job 3430: Data Warehouse Analyst (B. Intermediate)
    Statement of Work (SOW)
    Florida Department of Transportation State Term Contract No. 80101507-23-STC-ITSA
    1. Request for Quote
    2. Overview
    2.1 The Florida Department of Transportation (Department) is requesting resumes and hourly rate quotes for staff augmentation resources meeting the specific Knowledge, Skills, and Abilities (KSAs) listed below. The Department will select the candidate that provides the best overall value to the State, based on skill set and rate.
    Term : The contract term for this Staff Augmentation position is intended to be 09/01/2026 - 6/30/2027, with possible renewal, based on excellence in work provided, project need, and budget availability.
    NOTE : "Term " does not mean the awarded contractor or resource is locked into this term any contractor or resource may be terminated for cause, convenience, or funding during the contract term.
    VENDOR BILL RATE : It is the responsibility of the vendor to submit rates in accordance with the pre-established rates within the State Contract.
    Candidate Submission :
    FDOT is accepting two (2) candidate submission from vendors for New this position.
    Rate Increase :
    Please do not impose a rate increase for any subsequent year of the contract as part of your bid response. This is a firm fixed price and will be increased only at the discretion of the Department, based on consultant job performance and availability of funds. Imposing additional increases will automatically disqualify the candidate submission from consideration.
    Quote Evaluation :
    Quotes will be evaluated based on the specifications identified in the scope of services and sub-sections below. The eQuote will be awarded to the Contractor who presents a Candidate who demonstrates the best value to the Department based upon the response provided. The submission of additional work samples, or in-person interview(s), may be requested at the discretion of the Department.
    Face-to-Face Interviews :
    Since this position must report to the office 5 days a week, in-person interviews are required .
    Telecommuting :
    The candidate must reside in Tallahassee or the surrounding area and report to the office 5 days a week .
    Work Hours
    Flexibility to work hours between 7:00 AM & 7:00 PM and/or Saturdays, either on a rotation or as part of a regular
    and on-call work schedule.
    This position will report to :
    FDOT Office of Information Technology
    Barry Building
    3185 S. Blair Stone Rd
    Tallahassee, FL 32311
    Conflict of Interest Statement :
    To prevent any bias, unfair competitive advantage, conflict of interest, or the appearance of impropriety, Vendor
    employees must not have been directly or indirectly involved in the development of the Scope of Services or
    related solicitation documentation for which the Vendor is preparing a bid. If the Vendor employee worked in conjunction with the Department on the development of the solicitation document, the Vendor is disqualified from submitting a bid for this solicitation. The Vendor personnel assigned to other Department projects outside this Agreement shall hold and maintain any confidential information that could benefit the Vendor on future solicitations in strictest confidence.
    The Department will avoid Organizational Conflict of Interest through mitigation efforts in three categories:
    A. " Unequal Access " wherein an unfair competitive advantage surfaces when a Vendor obtains information not generally available to other competitors, and where such information would assist them in winning the contract over their competitors.
    B. " Impaired Objectivity " wherein a support Vendor is performing duties that involve assessing or evaluating itself or related entity.
    C. " Biased Ground Rules " wherein the Vendor is writing the SOW, performing systems engineering, or providing technical direction efforts.
    Need help with MFMP ? Contact the MFMP Customer Service Desk at 866-352-3776 if you have any questions regarding application functionality.
    3. Vendor Response will Include:
    3.1 Price per hour
    3.2 Candidate Resume
    Please upload your candidate's resume, and any supporting documents requested (i.e. skills matrix,
    recommendations, etc.) (maximum file size is 20 MB).
    NOTES :
    1. Submitting a "video " resume is strictly prohibited and will automatically disqualify your candidate for
    further consideration. Do not upload a video resume in Ariba OR email a video resume (or link to a video
    resume) separately to ANY FDOT personnel.
    2. PDF or Word doc are the only acceptable formats for resume submission. Resumes submitted in JPG
    format will be disqualified.
    3. Failure to upload a resume at the time of candidate submission will result in quote disqualification.
    3.3 Exhibit E: Resume Self - Certification Form
    When submitting a response to an RFQ the Contractor shall submit with its response a signed Resume Self-Certification Form (Exhibit E) to the Department for each candidate included in the RFQ response. For a blank form, see the DMS IT Staff Augmentation Contract website here: Exhibit E - Resume Self-
    Certification Form.pdf (ccplatform.net)
    NOTES :
    1. PDF is the only acceptable format for submission of the Exhibit E form. Forms submitted in JPG
    format will be disqualified.
    2. Failure to upload the Exhibit E form at the time of candidate submission will result in quote
    disqualification.
    3. Failure to upload a complete Exhibit E form, with all fields filled in, at the time of candidate submission
    will result in disqualification.
    4. Scope of Services
    The Data Warehouse Analyst / Report Builder will develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creating advanced DAX calculations, writing and tuning complex SQL queries, and ensuring Snowflake datasets are modeled and structured for reliable Power BI consumption. The resource will work with data engineers to support dimensional modeling, maintain metadata and data lineage documentation, and ensure accurate, high-performance reporting. The Analyst will collaborate with stakeholders to translate business needs into actionable reports, troubleshoot performance issues across Power BI and Snowflake, and operate effectively in a dynamic environment with minimal oversight.
    5. Education
    Bachelor's degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.
    6. Experience
    1. Required minimum of 5 years of IT work experience in business intelligence tools and systems.
    2. A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports,
    dashboards, and data models using Microsoft Power BI, including advanced report design, paginated
    reports, performance tuning, and DAX.
    3. Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
    4. Strong understanding of star schema design and fact/dimension modeling.
    5. Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
    6. Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
    7. Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
    8. Experience in integrating Power BI with Snowflake and connection modes.
    9. Proficiency in Power BI Report Builder, workspace management, and performance optimization.
    10. Experience with metadata management, data lineage, and documentation.
    11. Experience embedding Power BI reports into web or internal applications.
    12. Knowledge of CI/CD for Power BI and version control is a plus.
    7. Primary Job Duties/ Tasks
    The activities the candidates will be tasked with include, but are not limited to, the following:
    1. Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
    2. Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
    3. Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
    4. Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
    5. Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
    6. Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
    7. Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.
    8. Job Specific Knowledge, Skills, and Abilities (KSAs)
    The submitted candidates must be able to apply specific knowledge, skills, and abilities in the following areas:
    1. Knowledge of dimensional modeling and star schema design for semantic model development.
    2. Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query.
    3. Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts.
    4. Skill in building optimized, scalable Power BI semantic models using strong dimensional design.
    5. Skill in writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption.
    6. Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design.
    7. Ability to translate business requirements into structured semantic models and actionable reports.
    8. Ability to troubleshoot performance issues across DAX, SQL, and Snowflake compute layers.
    9. Ability to collaborate effectively with data engineers, SMEs, and stakeholders to deliver enterprise-ready reporting solutions.
    9. General Knowledge Skills and Abilities (KSAs):
    The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
    1. Initiative: Must be able to comprehend assignments, organize workload, and meet deadlines with little
    direction. Must be able to monitor and analyze situations to determine the next step.
    2. Communication: Can clearly convey information, in both written and verbal formats, to individuals or
    groups in a wide variety of settings (i.e., project team meetings, management presentations, business
    office etc.). Must have the ability to effectively listen and process information provided by others.
    3. Customer Service: Works well with clients and customers (i.e., business office, public, or other agencies).
    Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.
    4. Decision Making: Makes sound, well-informed, and objective decisions utilizing critical thinking skills and analysis.
    1. Flexibility : Is open to change, new processes (or process improvement), and new information. Can adapt
    in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give
    constructive criticism and maintain effective work relationships with others.
    1. Interpersonal : Shows friendliness, courtesy, understanding, and politeness to others
    2. Leadership : Motivates, encourages, and challenges others. Can adapt leadership styles in a variety of situations.
    3. Problem Solving : Able to identify, evaluate, and use sound judgment to generate and evaluate alternative actions, and make recommendations accordingly.
    4. Team Building : Encourages, inspires, and guides others toward accomplishing the common goal as an equal member of the team.


    By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - Abacus.

    Similar Jobs

    See more jobs