Agile TO F50B0600045-41 Tableau Developer_Computer Systems Analyst (Junior)_W00P4602015.docx

Section 1 – General Information

Role CATS+ Labor Category System Development and Implementation / Tableau Developer Computer Systems Analyst (Junior) One position – May submit up to 2 resumes

MBE Goal (Refer to Section 4, Proposal Documentation Submission Requirements) Not Applicable to this TO

Issue Date:

mm/dd/yyyy

Time (EST):

00:00 am/pm

05/31/2024; 2:00 PM

(Responses received after the due date/time will be rejected)

Teleworking may be permitted at the discretion of the hiring manager/supervisor, but this position is neither hybrid nor 100% remote.

Section 2 – Task Order Request Procurement Officer Information

Section 3 – Duties/Responsibilities

Background: The Maryland Department of State Police (MDSP) seeks one (1) resource to work with its IT division to develop and deploy Tableau-based reports and dashboards. This resource will support the enhancement/development efforts for the Maryland Gun Center’s crime firearm system. This system will provide services to MDSP and all allied partners across the state. This process directly supports the mandate in Senate Bill 861.

Refer to Exhibit A – Position Descriptions

Section 4 - Resource Qualification and Experience Requirements

Refer to Exhibit A - Position Description

NOTE:

1. Proposed candidates must be authorized to work within the United States for at least 120 days following the NTP date. Proof of work authorization will be requested prior to on-boarding of selected candidate.

2. Individuals must be fingerprinted in Maryland using the Maryland State Police Fingerprint Form & Codes and must pass a Maryland State Police background check; background checks previously performed by other state or federal agencies do not apply.

Section 5 – Proposal Documentation Submission Requirements

TO Contractors shall respond to this TO Request via email to PO email address by submitting two emails, one for the Technical Proposal and the second for the Financial Proposal. The subject line for each email must identify which volume it contains along with the TO Contractor Name and TO Request number. Both the Technical and Financial Proposals must each be password protected.

The Technical Proposal must include the following:

1. Attachment A – MBE Utilization and Fair Solicitation Affidavit and MBE Participation Schedule (not applicable)

2. Attachment B – Qualifications Summary (1 page only) for each proposed candidate. Do NOT include the offeror’s Company/Organization Name/Logo. – One position, may submit up to 2 resumes

3. Resume for each proposed candidate, 8-page limit. Include any documentation supporting education/certification requirements (not included in the 8-page limit). Do NOT include the offeror’s Company/Organization Name/Logo. – One position, may submit up to 2 resumes Note: Submit one zip file (password protected) with all the individual documents.

Naming Convention: Resume_FirstName_LastName.pdf , Attachment B_Summary_FirstName_LastName.pdf

The Financial Proposal must include the following:

4. Completed Attachment C – Task Order Request Financial Proposal, submit in Excel and PDF format. Complete the Financial Proposal Form only as provided in the Financial Proposal Form Instructions and the Task Order Request Financial Proposal Form itself, including pricing for all labor roles anticipated for this TO.

5. The TO Request Financial Proposal shall contain a description of any assumptions on which the TO Contractor’s TO Request Financial Proposal is based (Assumptions shall not constitute conditions, contingencies, or exceptions to the Financial Proposal Form).

6. Proposed labor rates shall not exceed the rates in the TO Contractor’s Financial Proposal to TORFP #F50B0600039 for the TOA year(s) in effect at the time of the TO Request Proposal due date.

Note: State reserves the right to request three references for each proposed candidate.

Section 6 – Evaluation Criteria

Technical Proposals will be evaluated on the following criteria, each of which are of equal weight:

1. The proposed candidates’ relevant background, experience, and capabilities.

2. The proposed candidates’ relevant domain knowledge.

3. In person interview and responses to questions.

Note: The PO will notify each of the TO Contractors of the location, date, and time to bring selected candidates for in-person interview, or Interview may be conducted virtually. The State may, in its discretion, select proposed candidates for an additional round of interviews.

Section 7 - Evaluation Process

1. Attachment B – Resume Qualifications Summary (1 page only) and resumes for each proposed candidate will be reviewed to determine those candidates that meet the qualifications for the proposed position as provided in Section 4 - Resource Qualification and Experience Requirements. Proposed candidates that are determined to be qualified will be offered an interview. Following interviews, candidates will be evaluated in accordance with Section 6 and ranked from most to least qualified.

2. Financial Proposals will be opened and evaluated for all TO Contractors that are determined to be reasonably susceptible of being selected for award. Financial Proposals will be ranked from lowest (most advantageous pricing to the State) to highest (least advantageous pricing to the State).

3. The TO Procurement Officer will recommend award to one or more TO Contractor whose proposal is determined to be the best value to the State, considering price and the evaluation factors set forth above. In this evaluation, technical merit is considered to have greater weight.

Section 8 –Invoicing Instructions

1. Within 30 calendar days, the TO Contractor shall send a copy of the signed timesheets with an invoice to the mailbox msp.procurement@maryland.gov.

2. Reference TORFP #F50B0600045, Section 3.3 Invoicing for additional instructions.

Task Order Request #F50B0600045-41 Agile Team Resources – F50B0600045 (all provisions apply)

Agile Team Resources – TO# F50B0600045-41 Page 1

Attachment A. MBE Utilization and Fair Solicitation Affidavit and MBE Participation Schedule (if applicable)

See link at http://procurement.maryland.gov/wp-content/uploads/sites/12/2018/05/AttachmentDMBE-Forms-1.pdf.

NOT APPLICABLE FOR THIS TASK ORDER

SUBMIT WITH TASK ORDER REQUEST PROPOSAL AS INSTRUCTED IN SECTION 5

ATTACHMENT B – AGILE TEAM RESOURCES TASK ORDER REQUEST #F50B0600045-41

RESOURCE QUALIFICATIONS SUMMARY (1 page only) Proposed Resource Candidate Name:

Role:

CATS+ Labor Category:

System Development and Implementation / Tableau Developer Computer Systems Analyst (Junior) One position – May submit up to 2 resumes CATS+ Labor Category as proposed by the TO Contractor in response to the TORFP#F50B0600045 for the Role as in Section 1

Summary of Qualifications

Technical Skills/Domain Knowledge

Relevant Experience

[Dates]

[Dates]

[Dates]

Education/certifications

[Dates]

[Dates]

[Dates]

ATTACHMENT C – AGILE TEAM RESOURCES TASK ORDER REQUEST #F50B0600039-41

TASK ORDER REQUEST FINANCIAL PROPOSAL

INCLUDED AS A SEPARATE EXCEL FORM

SUBMIT AS INSTRUCTED IN SECTION 5

Task Order Request F50B0600045-41 Exhibit A - Position Description One Computer Systems Analyst (Junior)

High Level Description of Work:

This position is responsible for using Tableau to design, develop, implement, and maintain interactive dashboards and reports that provide valuable insights to the Maryland State Police organization and our stakeholders. A key aspect of this role will be working with cross-functional teams to understand business requirements and translate them into effective data visualizations.

Computer Systems Analyst (Junior):

Specific Work/Tasks

· Gather requirements for reporting.

· Follow the agency Center of Excellence procedures for projects.

· Develop and maintain data models consistent with agency requirements and needs.

· Develop and maintain data visualizations and dashboards.

· Develop and maintain detailed documentation of developed solutions and instructional procedures.

· Attendance at MSP ITD meetings (as required).

· Regular status reporting of assigned tasks to MSP supervisor.

· After-hours support (as required).

· Other duties as assigned.

Deliverables/Acceptance Criteria

· Tableau data models, dashboards, and reports.

· Documentation of instructions and methodology.

Education:

A bachelor’s degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field.

General Experience:

Must have three (3) years of computer experience in technical assignments working under close supervision and direction.

Specialized Experience:

· At least one (1) year of experience creating SQL queries.

· At least one (1) year of experience with Tableau Desktop.

· At least one (1) year of experience using Tableau Server.

· At least one (1) year of experience using Tableau Prep.

Preferred:

· Knowledge of Python (programming language).