MAS - Analytica Consulting, LLC - 47QTCA23D00AM

Analytica Consulting, LLC

Multiple Award Schedule (MAS)

Contact Information:

accounting@analyticaconsulting.com

Tel: 858-272-8260 www.analyticaconsulting.com

Mailing Address:

Analytica Consulting, LLC

548 Market Street PMB #67525 San Francisco, CA 94104

FSC Group: Information Technology – IT Services Awarded Items: 54151S, 54151HEAL Contract Number: 47QTCA23D00AM Contract Period: 6/30/2023 – 6/29/2028 Business Size: Small Business

Pricelist current effective June 30, 2023

Prices shown herein are net (discount deducted)

GENERAL SERVICES ADMINISTRATION

FEDERAL SUPPLY SERVICE

AUTHORIZED FEDERAL SUPPLY SCHEDULE PRICE LIST

Online access to contract ordering information, tems and conditions, up to date pricing, and the option to create an electronic delivery order are available through GSA Advantage!®, a menu driven database system. The INTERNET address GSA Advantage!® is: GSAAdvantage.gov.

For more information on ordering from Federal Supply Schedules click on FSS Schedules at GSA.gov.

http://www.analyticaconsulting.com/

GSA MAS Schedule

Contract No. 47QTCA23D00AM 1 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Table of Contents:

Section Page Number

Customer Information 2

SIN 54151S - Labor Category Descriptions 4

SIN 54151S - Labor Category Hourly Rates 11

SIN 54151HEAL - Labor Category Descriptions 12

SIN 54151HEAL - Labor Category Hourly Rates 19

Contract No. 47QTCA23D00AM 2 ANALYTICA CONSULTING, LLC

Customer Information

Contract Administrator Information:

Clifton G. Leung - Senior Director of Finance & Operations Email: info@analyticaconsulting.com Phone: 858-272-8260

Business Size: Small Business

1a. Items Awarded

SIN SIN Title

54151S Information Technology Professional Services

54151S Health Information Technology Services

1b. The lowest priced model number for SIN 54151S can be located on page 11 in the table column labeled “GSA Offered Hourly Rate.” The lowest priced model number for SIN 54151HEAL can be located on page 19 in the table column labeled “GSA Offered Hourly Rate.”

1c. Descriptions of each labor category for SIN 54151S, including functional responsibilities, experience, and education requirements can be located on page 4. Corresponding hourly rates for each labor category for SIN 54151S can be located on page 11. Descriptions of each labor category for SIN 54151HEAL, including functional responsibilities, experience, and education requirements can be located on page 12. Corresponding hourly rates for each labor category for SIN 54151HEAL can be located on page 19.

2. Maximum order: $500,000.00 for SIN 54151S and 54151HEAL.

3. Minimum order: $10,000.00 for SIN 54151S and 54151HEAL.

4. Geographic coverage (delivery area): Worldwide for SIN 54151S and 54151HEAL.

5. Point(s) of production: Not Applicable

6. Discount from list prices or statement of net price: Prices listed are net, discounts have been deducted and the industrial funding fee has been added.

7. Quantity discounts: Additional .75% for Task Orders above $400,000.00

8. Prompt payment terms: Net 30 days Information for Ordering Offices: Prompt payment terms cannot be negotiated out of the contractual agreement in exchange for other concessions.

9. Foreign items: Not applicable

10a. Time of delivery: As negotiated

Contract No. 47QTCA23D00AM 3 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

10b. Expedited delivery: As negotiated

10c. Overnight and 2-day delivery: Not applicable

10d. Urgent Requirements: Not applicable

11. F.O.B point(s): Not applicable

12a. Ordering address(es):

548 Market Street PMB 67525, San Francisco CA 94104 Phone : 858-272-8260 Email : info@analyticaconsulting.com

12b. Ordering procedures: For supplies and services, the ordering procedures, information on Blanket Purchase Agreements (BPA’s) are found in Federal Acquisition Regulation (FAR) 8.405-3.

13. Payment address(es):

548 Market Street PMB 67525, San Francisco CA 94104 Phone : 858-272-8260 Email : info@analyticaconsulting.com

14. Warranty provision: Not Applicable

15. Export packing charges: Not Applicable

16. Terms and conditions of rental, maintenance, and repair: Not Applicable

17. Terms and conditions of installation: Not Applicable

18a. Terms and conditions of repair parts: Not Applicable

18b. Terms and conditions for any other services: Not Applicable

19. List of service and distribution points: Not Applicable

20. List of participating dealers: Not Applicable

21. Preventive maintenance: Not Applicable

22a. Special attributes: Not Applicable

22b. Section 508 compliance: Section 508 compliance information is available on Electronic and Information Technology (EIT) supplies and services. EIT standards can be found at: www.Section508.gov/.

23. Data Universal Number System (DUNS) number: 040525515

24. Notification regarding registration in System for Award Management (SAM) database: Registered, and registration is valid until April 13, 2024.

Contract No. 47QTCA23D00AM 4 ANALYTICA CONSULTING, LLC

Labor Category Descriptions: SIN 54151S

Experience Substitutions:

• A Doctoral Degree may be substituted for two (2) years of required Technical Experience

• A Computer Science Degree or Master of Science Degree may be substituted for two (2) years of required

Technical Experience

• A Master of Business Administration (MBA) may be substituted for two (2) years of required Consulting

Experience

• A Technical Graduate Degree may be substituted for two (2) years of required Technical Experience, not to exceed four years total

• Project Management Professional (PMP) certification may be substituted for two (2) years of Technical

Experience

Engagement Director

Minimum Experience: Minimum 15 years of Technical Experience; Minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise in the fields of data engineering, data science, and/or data visualization

• Build and manage client relationships by working with client stakeholders through the project life-cycle, and ensuring the projects are delivered on time and within budget.

• Conduct risk assessments and develop mitigation plans to ensure successful project delivery.

• Identify opportunities for additional project work and business development opportunities.

• Lead and manage all aspects of the project including staffing and project timelines

• Determine project scope, requirements, and deliverables with clients or customers

• Implement project plans to meet objectives; includes managing and leading project resources, monitoring project activities, and developing and implementing project schedules

• Give presentations or briefings on all aspects of the project and participates in project reviews

Additional Experience:

• Prior experience managing client relationships and delivering exceptional customer service

• Experience as an engagement director, project manager, or similar leadership position in the IT field.

• Exceptional project management, communication, and leadership skills.

• Demonstrated attention to detail with a heavy focus on risk management and information management

Senior Engagement Manager

Minimum Experience: Minimum 8 years of experience with a focus on project management and/or operations and finance functionalities Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Assist Engagement Director in managing all aspects of the project, including planning, scheduling, and project oversight

• Prepare project budgets and manage monthly invoice processing and forecasting

• Ensure adherence to all contractual obligations including but not limited to liability requirements and mandatory training requirements

• Monitor project timeline and activities based on project schedule and oversee all internal processes related to project success

• Develop relationships with internal and external stakeholders to ensure project success

Additional Experience:

Contract No. 47QTCA23D00AM 5 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

• Prior experience managing client relationships and delivering exceptional customer service

• Demonstrated attention to detail with a heavy focus on budgeting and managing project timelines

• Excellent communication, problem solving, and organization skills

Subject Matter Expert - Lead IT Data Scientist

Minimum Experience: Minimum 12 years of Technical Experience; Minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise on complex data science issues related to the IT Professional Services industry.

• Provide specialized data science guidance and expertise of Data Science efforts, including collaboration and coordination with data engineers and consultants throughout the lifecycle of the project to ensure successful execution of projects

• Analyze, process, and model data to inform actionable plans, add value and improve decisions

• Develop, test, and apply machine learning, data mining, or other big data management approaches to extract insights from structured and unstructured datasets of varying sizes and complexity

• Organize, clean, and transform data into usable formats in order to apply the appropriate models or algorithms

• Determine gaps between the current and the target architecture and develop plans for transitioning to target architecture

• Work with data engineers, data scientists and consultants to set up complex ongoing analyses

• Create documentation and provide training to inform and educate stakeholders

• Stay up-to-date with industry developments, trends, and emerging technologies

Additional Experience:

• Minimum of 12 years of prior experience leading data science efforts and acting as a subject matter expert in the field

• Experience leading, managing and mentoring junior level staff members

• Fluent in one or more data manipulation programming languages (R, Python, Scala, etc.)

• Proficiency with structured and unstructured datasets of varying sizes and complexity

• Expertise in automating data collection and preprocessing of data, data mining and statistical methodology to solve problems

• Additional software engineering experience with data science platforms and data stores

• SME Lead Data Scientist’s are competent in subject matter and concepts and may lead individuals, including

Principals, Senior Consultants, and Consultants, assisting in the work.

Subject Matter Expert - Lead IT Engineer

Minimum Experience: Minimum 12 years of Technical Experience, minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise on complex engineering issues related to the IT Professional Services industry.

• Provide specialized engineering guidance and expertise of engineering efforts to gather, aggregate, clean, review, process, map, inventory, visualize and analyze data for use by stakeholders and other team members to ensure successful execution of projects

• Lead and/or work on complex IT application design, development, testing and implementation

• Identify business trends and problems through complex data analysis

• Create data models and develop databases to support business solutions

Contract No. 47QTCA23D00AM 6 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

• Interpret results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining

• Collaborate with Data Scientists, Consultants and other Engineers to design, develop, and implement valuable analytics solutions

• Manage client relationships and requirements

• Develop documentation and provide training to inform and educate stakeholders

• SME Lead Engineers are competent in subject matter and concepts and may lead individuals, including

Principals, Senior Consultants, and Consultants, assisting in the work

• Stay up-to-date with industry developments, trends, and emerging technologies

Additional Experience:

• Minimum of 12 years of prior experience leading data engineering efforts and acting as a subject matter expert in the field

• Experience leading, managing and mentoring junior level staff members

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

Subject Matter Expert - Lead IT Consultant

Minimum Experience: Minimum 12 years of Technical Experience, minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise on complex issues related to the IT Professional Services industry.

• Provide specialized guidance, expertise, leadership, and oversight throughout all phases of the project lifecycle to ensure successful execution of projects

• Work with other consultants, data scientists, and engineers in a leadership capacity to provide requirements analysis, needs assessments, and selection and implementation of integration strategies

• Provide support around understanding, analysis, recommendation, and implementation of IT systems

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Identify relevant datasets, contribute to data transformations, clean data, and conduct exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex datasets

• Provide IT support in accordance with the policies and procedures established by the client, such as current infrastructure review, technology investment strategy guidance, and new strategy implementation

• Document and record all aspects of the project, including but not limited to project design, data collection, sampling, cleaning and analysis

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services

• SME Leads are competent in subject matter and concepts and may lead individuals, including Principals, Senior Consultants, and Consultants, assisting in the work

• Stay up-to-date with industry developments, trends, and emerging technologies

Additional Experience:

• Minimum of 12 years of prior experience leading consulting efforts and acting as a subject matter expert in IT consulting

• Experience leading, managing and mentoring junior level staff members

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

Contract No. 47QTCA23D00AM 7 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

IT Principal Data Scientist

Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, MS Degree Preferred Functional Responsibilities:

• Lead, analyze, process, and model data to inform actionable plans, add value and improve decisions

• Develop, test, and apply machine learning, data mining, or other big data management approaches to extract insights from structured and unstructured datasets of varying sizes and complexity

• Organize, clean, and transform data into usable formats in order to apply the appropriate models or algorithms

• Determine gaps between the current and the target architecture and develop plans for transitioning to target architecture

• Work with data engineers, data scientists and consultants to set up complex ongoing analyses

• Create documentation and provide training to inform and educate stakeholders

Additional Experience:

• Minimum of 10 years of experience serving as a IT Professional, with an emphasis on Data Science

• Fluent in one or more data manipulation programming languages (R, Python, Scala, etc.)

• Proficiency with structured and unstructured datasets of varying sizes and complexity

• Expertise in automating data collection and preprocessing of data, data mining and statistical methodology to solve problems

• Additional software engineering experience with data science platforms and data stores

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks compared to Senior Consultants. They have less autonomy than SME Leads.

IT Principal Engineer

Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Lead, gather, aggregate, clean, review, process, map, inventory, visualize and analyze data for use by stakeholders and other team members

• Work on complex IT application design, development, testing and implementation

• Identify business trends and problems through complex data analysis

• Create data models and develop databases to support business solutions

• Interpret results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining

• Collaborate with Data Scientists, Consultants and other Engineers to design, develop, and implement valuable analytics solutions

• Manage client relationships and requirements

• Develop documentation and provide training to inform and educate stakeholders

Additional Experience:

• Minimum of 10 years of experience serving as a IT Engineering professional

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks

IT Principal Consultant

Contract No. 47QTCA23D00AM 8 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Work with other consultants, data scientists, and engineers to provide requirements analysis, needs assessments, and selection and implementation of integration strategies

• Lead the implementation and design of complex IT infrastructure and systems, ensuring that they meet business needs and align with client goals.

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Identify relevant datasets, contribute to data transformations, clean data, and conduct exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex datasets

• Provide IT support in accordance with the policies and procedures established by the client, such as current infrastructure review, technology investment strategy guidance, and new strategy implementation

• Document and record all aspects of the project, including but not limited to project design, data collection, sampling, cleaning and analysis

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services Additional Experience:

• Minimum of 10 years of experience serving as a IT Professional

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks

IT Senior Data Scientist

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Analyze, process, and model data to inform actionable plans, add value and improve decisions

• Develop, test, and apply machine learning, data mining, or other big data management approaches to extract insights from structured and unstructured datasets of varying sizes and complexity

• Organize, clean, and transform data into usable formats in order to apply the appropriate models or algorithms

• Determine gaps between the current and the target architecture and develop plans for transitioning to target architecture

• Work with data engineers, data scientists and consultants to set up complex ongoing analyses

• Create documentation and provide training to inform and educate stakeholders

Additional Experience:

• Fluent in one or more data manipulation programming languages (R, Python, Scala, etc.)

• Proficiency with structured and unstructured datasets of varying sizes and complexity

• Expertise in automating data collection and preprocessing of data, data mining and statistical methodology to solve problems

• Additional software engineering experience with data science platforms and data stores

• IT Senior Data Scientist’s perform more varied and difficult tasks compared to IT Consultants, but are supervised by individuals at higher levels.

IT Senior Data Engineer

Contract No. 47QTCA23D00AM 9 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Gather, aggregate, clean, review, process, map, inventory, visualize and analyze data for use by stakeholders and other team members

• Work on complex IT application design, development, testing and implementation

• Identify business trends and problems through complex data analysis

• Create data models and develop databases to support business solutions

• Interpret results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining

• Collaborate with Data Scientists, Consultants and other Engineers to design, develop, and implement valuable analytics solutions

• Manage client relationships and requirements

• Develop documentation and provide training to inform and educate stakeholder

Additional Experience:

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

• IT Senior Data Engineers perform more varied and difficult tasks compared to IT Consultants, but are

IT Senior Consultant

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Work with other consultants, data scientists, and engineers to provide requirements analysis, needs assessments, and selection and implementation of integration strategies

• Provide support around understanding, analysis, recommendation, and implementation of IT systems

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Identify relevant datasets, contribute to data transformations, clean data, and conduct exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex datasets

• Provide IT support in accordance with the policies and procedures established by the client, such as current infrastructure review, technology investment strategy guidance, and new strategy implementation

• Document and record all aspects of the project, including but not limited to project design, data collection, sampling, cleaning and analysis

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services Additional Experience:

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

• IT Senior Consultants perform more varied and difficult tasks compared to IT Consultants, but are

IT Consultant Minimum Experience: Minimum 2 years of Technical Experience, minimum of 2 years Consulting Experience

Contract No. 47QTCA23D00AM 10 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Minimum Education Requirements: BA/BS Degree Required Functional Responsibilities:

• Provide IT support in accordance with the policies and procedures established by the client, such as reviewing and implementing investment guidance documentation, operational procedures, scoring criteria, templates, technology evaluations or implementation approaches

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services

• Provide support around understanding, analysis, recommendation, and implementation of IT systems

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Apply intensive and diversified knowledge of engineering, operations or financial processes in a broad area of assignments

• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs

• Provide IT support in accordance with the policies and procedures established by the client, such as reviewing current infrastructure, guidance on technology investment strategy, and implementation of new strategies

• Document and record project design, data collection, sampling, cleaning and analysis

• Apply process improvement and reengineering methodologies and principles on process modernization projects Additional Experience:

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills

• IT Consultants perform more routine aspects of the position and are supervised by individuals at higher levels.

IT Content Designer

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Design, develop, create, and edit and website content

• Develop site architecture, wireframes, marketing personas, branding, and strategy

• Implement modern web content styles and standards to help organizations increase organic traffic and leads

• Manage and execute initiatives related to SEO, conversion optimization, lead generation, and lead nurturing

• Review analytics & user feedback to find opportunities to improve content

• Establish processes and documentation for website and content related activities from planning through to execution

• Communicate with stakeholders clearly and regularly, providing training and feedback on website related activities as needed Additional Experience:

• Expertise and/or certification in some of the following: marketing strategy, copywriting, editing, keyword research, SEO, web design, lead generation

• Knowledge of Wordpress, photoshop, illustrator and email marketing platforms

Contract No. 47QTCA23D00AM 11 ANALYTICA CONSULTING, LLC

Labor Category Hourly Rates: SIN 54151S

Labor Category GSA Offered Hourly Rate

Engagement Director $196.47

Senior Engagement Manager $157.98

Subject Matter Expert - Lead IT Data Scientist $190.11

Subject Matter Expert - Lead IT Engineer $190.11

Subject Matter Expert - Lead IT Consultant $190.11

IT Principal Data Scientist $178.84

IT Principal Data Engineer $178.84

IT Principal Consultant $178.84

IT Senior Data Scientist $172.80

IT Senior Data Engineer $172.80

IT Senior Consultant $172.80

IT Consultant $140.55

IT Content Designer $143.58

*Rates are effective 6/30/2023-6/29/2024 and subject to annual escalation rate of 3.1%

Contract No. 47QTCA23D00AM 12 ANALYTICA CONSULTING, LLC

Labor Category Descriptions: SIN 54151HEAL

Experience Substitutions:

• A Doctoral Degree may be substituted for two (2) years of required Technical Experience

• A Computer Science Degree or Master of Science Degree may be substituted for two (2) years of required

Technical Experience

• A Master of Business Administration (MBA) may be substituted for two (2) years of required Consulting

Experience

• A Technical Graduate Degree may be substituted for two (2) years of required Technical Experience, not to exceed four years total

• Project Management Professional (PMP) certification may be substituted for two (2) years of Technical

Experience

Health IT Engagement Director

Minimum Experience: Minimum 15 years of Technical Experience; Minimum of 8 years Consulting Experience Minimum Education Requirements: Bachelors or Masters Degree in Information Technology, Computer Science, or related field Functional Responsibilities:

• Provide subject matter expertise in the fields of data engineering, data science, and/or data visualization on healthcare related projects.

• Build and manage client relationships by working with client stakeholders through the project life-cycle, and ensuring the projects are delivered on time and within budget.

• Conduct risk assessments and develop mitigation plans to ensure successful project delivery in the healthcare field.

• Identify opportunities for additional project work and business development opportunities in healthcare.

• Lead and manage all aspects of the project including staffing and project timelines, with a deep knowledge of healthcare requirements and regulations.

• Determine project scope, requirements, and deliverables with clients or customers in the healthcare industry.

• Implement project plans to meet objectives; includes managing and leading project resources, monitoring project activities, and developing and implementing project schedules, with a strong emphasis on healthcare-specific protocols.

• Give presentations or briefings on all aspects of the project and participate in project reviews with healthcare professionals.

Additional Experience:

• Prior experience managing client relationships and delivering exceptional customer service in healthcare settings, including HIPAA compliance and data security.

• Experience as an engagement director, project manager, or similar leadership position in the IT field, with a specific focus on healthcare projects.

• Exceptional project management, communication, and leadership skills

• Demonstrated attention to detail with a heavy focus on risk management and information management, specifically related to healthcare data

Subject Matter Expert - Lead Health IT Data Scientist

Minimum Experience: Minimum 12 years of Technical Experience; Minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred

Contract No. 47QTCA23D00AM 13 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Functional Responsibilities:

• Provide subject matter expertise on complex data science issues related to the healthcare industry.

• Provide specialized data science guidance and expertise of healthcare Data Science efforts, including collaboration and coordination with data engineers and consultants throughout the lifecycle of the project to ensure successful execution of projects

• Analyze, process, and model healthcare data to inform actionable plans, add value and improve decisions

• Develop, test, and apply machine learning, data mining, or other big data management approaches to extract insights from structured and unstructured healthcare datasets of varying sizes and complexity

• Organize, clean, and transform healthcare data into usable formats in order to apply the appropriate models or algorithms

• Determine gaps between the current and the target architecture and develop plans for transitioning to target architecture

• Work with data engineers, data scientists and consultants to set up complex ongoing analyses in the healthcare industry

• Create documentation and provide training to inform and educate stakeholders in the healthcare industry

• Stay up-to-date with industry developments, trends, and emerging technologies to ensure that you are providing the most relevant and cutting-edge healthcare data science guidance and expertise Additional Experience:

• Minimum of 12 years of prior experience leading data science efforts and acting as a subject matter expert in the healthcare IT field

• Experience leading, managing and mentoring junior level staff members on healthcare projects

• Fluent in one or more data manipulation programming languages (R, Python, Scala, etc.)

• Proficiency with structured and unstructured datasets of varying sizes and complexity

• Expertise in automating data collection and preprocessing of data, data mining and statistical methodology to solve problems

• Additional software engineering experience with data science platforms and data stores

• SME Lead Data Scientist’s are competent in subject matter and concepts and may lead individuals, including

Principals, Senior Consultants, and Consultants, assisting in the work.

Subject Matter Expert - Lead Health IT Engineer

Minimum Experience: Minimum 12 years of Technical Experience, minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise on complex engineering issues related to the healthcare IT industry.

• Provide specialized engineering guidance and expertise of healthcare-related engineering efforts to gather, aggregate, clean, review, process, map, inventory, visualize and analyze data for use by stakeholders and other team members to ensure successful execution of projects

• Lead and/or work on complex healthcare IT application design, development, testing and implementation

• Identify healthcare business trends and problems through complex data analysis

• Create healthcare data models and develop databases to support business solutions

• Interpret results from multiple healthcare sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining

• Collaborate with Data Scientists, Consultants and other Engineers to design, develop, and implement valuable healthcare analytics solutions

• Manage healthcare client relationships and requirements

• Develop healthcare documentation and provide training to inform and educate stakeholders

• SME Lead Engineers are competent in healthcare subject matter and concepts and may lead individuals, including Principals, Senior Consultants, and Consultants, assisting in the work

• Stay up-to-date with healthcare industry developments, trends, and emerging technologies

Contract No. 47QTCA23D00AM 14 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Additional Experience:

• Minimum of 12 years of prior experience leading healthcare data engineering efforts and acting as a subject matter expert in the field

• Experience leading, managing and mentoring junior level staff members

• Expertise and/or certification in some or all of the following healthcare technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills with a focus on healthcare terminology and communication within the healthcare industry.

Subject Matter Expert - Lead Health IT Consultant

Minimum Experience: Minimum 12 years of Technical Experience, minimum of 8 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters or Doctoral Degree Preferred Functional Responsibilities:

• Provide subject matter expertise on complex issues related to the IT Professional Services industry, with a focus on healthcare.

• Provide specialized guidance, expertise, leadership, and oversight throughout all phases of the project lifecycle to ensure successful execution of healthcare IT projects.

• Work with other consultants, data scientists, and engineers in a leadership capacity to provide requirements analysis, needs assessments, and selection and implementation of integration strategies for healthcare systems.

• Provide support around understanding, analysis, recommendation, and implementation of healthcare IT systems and technologies.

• Translate business initiatives and goals into analytical questions and identify critical metrics for review, specifically in the healthcare industry.

• Identify relevant datasets, contribute to data transformations, clean data, and conduct exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex healthcare datasets.

• Provide IT support in accordance with the policies and procedures established by the client, such as current healthcare infrastructure review, technology investment strategy guidance, and new healthcare technology implementation.

• Document and record all aspects of the healthcare project, including but not limited to project design, data collection, sampling, cleaning and analysis.

• Provide support for extracting healthcare project data, creating dashboards and reports, queries, data warehousing, and other reporting services.

• SME Leads are competent in subject matter and concepts related to healthcare IT and may lead individuals, including Principals, Senior Consultants, and Consultants, assisting in the work.

• Stay up-to-date with industry developments, trends, and emerging healthcare technologies.

• Minimum of 12 years of prior experience leading consulting efforts and acting as a subject matter expert in IT consulting for the healthcare industry.

• Experience leading, managing and mentoring junior level staff members.

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI), specifically as applied to healthcare.

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python, with a focus on healthcare applications.

• Excellent communication skills, particularly in communicating complex technical concepts to non-technical stakeholders in the healthcare industry

Contract No. 47QTCA23D00AM 15 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

Principal Health IT Data Scientist

Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, MS Degree Preferred Functional Responsibilities:

• Lead, analyze, process, and model healthcare data to inform actionable plans, add value and improve decisions

• Develop, test, and apply machine learning, data mining, or other big data management approaches to extract insights from structured and unstructured healthcare datasets of varying sizes and complexity

• Organize, clean, and transform healthcare data into usable formats in order to apply the appropriate models or algorithms

• Determine gaps between the current and the target healthcare architecture and develop plans for transitioning to target architecture

• Work with healthcare data engineers, data scientists, and consultants to set up complex ongoing analyses

• Create documentation and provide training to inform and educate healthcare stakeholders

Additional Experience:

• Minimum of 10 years of experience serving as an IT Professional with an emphasis on healthcare Data

Science

• Fluent in one or more data manipulation programming languages (R, Python, Scala, etc.)

• Proficiency with structured and unstructured healthcare datasets of varying sizes and complexity

• Expertise in automating healthcare data collection and preprocessing of data, data mining and statistical methodology to solve problems

• Additional software engineering experience with healthcare data science platforms and data stores

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks

Principal Health IT Engineer Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Lead the collection, aggregation, cleaning, review, processing, mapping, inventorying, visualization, and analysis of healthcare data for use by stakeholders and other team members

• Work on complex IT application design, development, testing, and implementation in the healthcare industry

• Identify healthcare business trends and problems through complex data analysis

• Create healthcare data models and develop healthcare databases to support healthcare business solutions

• Interpret healthcare results from multiple sources using a variety of techniques, ranging from simple healthcare data aggregation via statistical analysis to complex healthcare data mining

• Collaborate with Data Scientists, Consultants, and other Engineers to design, develop, and implement valuable analytics solutions for healthcare organizations

• Manage healthcare client relationships and requirements

• Develop healthcare documentation and provide healthcare training to inform and educate healthcare stakeholders.

Additional Experience:

• Minimum of 10 years of experience serving as an IT Engineering professional with a focus on healthcare

• Expertise and/or certification in healthcare-specific technologies such as Epic, Cerner, or Allscripts

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python, with a focus on healthcare applications

• Excellent communication skills, with the ability to effectively communicate with healthcare professionals and technical teams

Contract No. 47QTCA23D00AM 16 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks compared to Senior Consultants. They have less autonomy than SME Leads, but have a deep understanding of healthcare-specific technologies and their application in healthcare settings.

Principal Health IT Consultant

Minimum Experience: Minimum 10 years of Technical Experience, minimum of 5 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Collaborate with consultants, data scientists, and engineers to analyze requirements, assess needs, and select and implement integration strategies for healthcare IT systems.

• Lead the implementation and design of complex IT infrastructure and systems that meet healthcare business needs and align with client goals.

• Translate healthcare business initiatives and goals into analytical questions and identifying critical metrics for review.

• Identify relevant healthcare datasets, contributing to data transformations, cleaning data, and conducting exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex healthcare datasets.

• Provide IT support that adheres to the policies and procedures established by the client, including current infrastructure review, technology investment strategy guidance, and new strategy implementation.

• Document and record all aspects of the project, including project design, data collection, sampling, cleaning, and analysis to ensure accurate and efficient healthcare IT solutions.

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services to meet the unique needs of the healthcare industry.

Additional Experience:

• Expertise and/or certification in some or all of the following healthcare technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI).

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python.

• Excellent communication skills, with the ability to effectively communicate with healthcare professionals and technical teams

• IT Principals are competent in subject matter and concepts and perform more varied and difficult tasks

Senior Health IT Data Engineer

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Gather, aggregate, clean, review, process, map, inventory, visualize and analyze healthcare data for use by stakeholders and other team members

• Work on complex IT application design, development, testing and implementation

• Identify business trends and problems through complex healthcare data analysis

• Create healthcare data models and develop healthcare databases to support business solutions

• Interpret results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining

• Collaborate with Data Scientists, Consultants and other Engineers to design, develop, and implement valuable healthcare analytics solutions

• Manage client relationships and requirements

• Develop documentation and provide training to inform and educate stakeholders

Contract No. 47QTCA23D00AM 17 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills, with the ability to effectively communicate with healthcare professionals and technical teams

• IT Senior Data Engineers perform more varied and difficult tasks compared to IT Consultants, but are

Senior Health IT Consultant

Minimum Experience: Minimum 5 years of Technical Experience, minimum of 3 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required, Masters Degree Preferred Functional Responsibilities:

• Work with other healthcare industry focused consultants, data scientists, and engineers to provide requirements analysis, needs assessments, and selection and implementation of integration strategies

• Provide support around understanding, analysis, recommendation, and implementation of healthcare IT systems

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Identify relevant datasets, contribute to data transformations, clean data, and conduct exploratory and statistical analyses to identify, analyze, and interpret trends or patterns in complex datasets

• Provide healthcare IT support in accordance with the policies and procedures established by the client, such as current infrastructure review, technology investment strategy guidance, and new strategy implementation

• Document and record all aspects of the healthcare project, including but not limited to project design, data collection, sampling, cleaning and analysis

• Provide support for extracting project data, creating dashboards and reports, queries, data warehousing, and other reporting services

Additional Experience:

• Expertise and/or certification in some or all of the following technologies: Snowflake, Databricks, Tableau, Microsoft BI (SSIS/SSAS, SQL Server, Power BI)

• Programming expertise in some or all of the following languages: SQL, C#, Java, SQL, R, Python

• Excellent communication skills, with the ability to effectively communicate with healthcare professionals and technical teams

• IT Senior Consultants perform more varied and difficult tasks compared to IT Consultants, but are

Health IT Consultant Minimum Experience: Minimum 2 years of Technical Experience, minimum of 2 years Consulting Experience Minimum Education Requirements: BA/BS Degree Required Functional Responsibilities:

• Provide IT support in accordance with the policies and procedures established by the client, such as reviewing and implementing investment guidance documentation, operational procedures, scoring criteria, templates, technology evaluations or implementation approaches

• Provide support for extracting project healthcare data, creating dashboards and reports, queries, data warehousing, and other reporting services

• Provide support around understanding, analysis, recommendation, and implementation of IT systems

• Translate business initiatives and goals into analytical questions and identify critical metrics for review

• Apply intensive and diversified knowledge of engineering, operations or financial processes in a broad area of assignments

Contract No. 47QTCA23D00AM 18 ANALYTICA CONSULTING, LLC Price list effective June 30, 2023

• Critically evaluate healthcare information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs

• Provide healthcare IT support in accordance with the policies and procedures established by the client, such as reviewing current infrastructure, guidance on technology investment strategy, and implementation of new strategies

• Document and record healthcare project design, data collection, sampling, cleaning and analysis

• Apply process…