1410: Data Architect (C. Advanced) - Abacus Service Corporation
Tallahassee, FL 32303
About the Job
STC # 1410: Data Architect (C. Advanced)
2 Scope of Services
The Department of Children and Families (the "Department " or "DCF ") is seeking qualified
candidates who will assist the Office of Information Technology (OITS) in their daily operations,
support, and services. The services requested in the following eQuote will be procured in accordance
with the Department of Management Services (DMS) State Term Contract (STC), entitled
Information Technology Staff Augmentation Services, 80101507-23-STC-ITSA.
The term for this staff augmentation position is intended to be until June 30, 2025. The term for
this engagement may be extended for a period not to exceed twelve months from the expiration of
the State Term Contract contingent upon funding and satisfactory performance. The Department
may select one or more candidates for this position. Candidates available immediately are preferred.
Preference will also be given to candidates available to work on-site in Tallahassee.
Candidates can either work part-time or full-time. The number of weeks is dependent upon the
available budget.
Quotes submissions due (on or before) October 25, 2024 3:00 PM
Anticipated Award Date Purchase Order Release N/A
2.1 Primary Job Duties and Tasks
The Office of Information Technology Services (OITS) is seeking Multiple Data Architect (STC
1410: Data Architect (C. Advanced)) positions.
The activities these candidates will be tasked with include, but are not limited to the following:
• Work with stakeholders and development team to determine project scope and vision,
gather and prioritize collected requirements.
• Designing and Implementing Data Architectures: Develop comprehensive data architectures
that support the organization's business goals, using Azure Synapse Analytics, Azure SQL,
and other Azure data services.
• Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL Pools in
Synapse to handle large-scale data warehousing and analytics workloads.
• Database Design and Management: Design, implement, and manage databases using Azure
SQL and Azure Managed Instance, ensuring high performance, availability, and security.
• Data Integration and ETL Processes: Develop and manage ETL (Extract, Transform, Load)
processes using Synapse Pipelines, ensuring efficient data flow from various sources to the
data warehouse.
• Data Governance and Cataloging: Implement data governance practices and manage the
data catalog to ensure data quality, consistency, and accessibility.
• Building and Maintaining Data Models: Create and maintain data models that accurately
represent the data landscape, ensuring they are scalable and optimized for performance.
• Ensuring Data Security and Compliance: Implement and oversee data security measures,
ensuring compliance with legal and regulatory standards.
• Maintain procedures manuals and system documentation.
• Research software solutions to support recommendations, analyzing current and future
technology trends.
These positions are to provide technical guidance and expertise in supporting the department in
developing, architecting, and maintaining data, data mappings, and monitoring high-volume
complex data transfer processes.
2.2 Specific Knowledge, Skills, and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the
following areas:
Minimum Required KSAs:
• 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database,
and Azure Managed Instance.
• 5+ years of experience in DDL, DML T-SQL skills, advanced stored procedure writing
skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process
logging, and error handling.
• 4+ years of experience in data architecture design principles, methodologies, and best
practices.
• 3+ years of experience in data governance principles and compliance requirements
related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large
data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure,
including storage solutions and compute capabilities.
• 1+ years of Experience with programming languages such as Python or Scala.
• 1+ years of experience in Salesforce, Message MQ, and MuleSoft
• Strong analytical and problem-solving skills to address complex data challenges.
• Ability to design and implement robust, scalable, and efficient data architectures.
• Ability to provide excellent customer support; meticulous quality of work and work
product.
2.3 General Knowledge, Skills and Abilities (KSAs)
The submitted candidate(s) must be able to apply common knowledge, skills, and abilities in the
following areas:
1. Communication: Able to 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, etc.). Must have the ability to effectively listen and process information provided by
others.
2. 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.
3. Decision Making: Makes sound, well-informed, and objective decisions.
4. Flexibility: Is open to change, new processes (or process improvement), and new information.
Has the ability to 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.
5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
6. Leadership: Motivates, encourages, and challenges others. Can adapt leadership styles in a
variety of situations.
7. Problem-Solving: Able to identify, evaluate, and use sound judgment to generate and evaluate
alternative actions, and make recommendations as accordingly.
8. Team Building: Encourages, inspires, and guides others toward accomplishing the common
goal.
2.3 Education and Certifications
Education: Bachelor's or Master's Degree in Computer Science, Information Systems, or other
related field. Or equivalent work experience. (Required)
Certifications: Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform
Certifications (Desired)
3 Vendor Response
Please include the following information in your candidate submission.
3.1 Responding Instructions and Documents to Provide
Please ensure each candidate submission contains the following documents and information:
1. Pricing information (REQUIRED): Please include the pricing (rate) for individuals or group
with your quote. The Department reserves the right to discuss lower rates with any vendor
selected prior to executing a contract through a Purchase Order.
2. Candidate Resume(s) Include relevant experience, certifications, education, etc. related to
the services requested in the Scope of Services.
3. Exhibit B - Resume Self-Certification Form Per the IT Staff Augmentation STC: When
submitting a response to an eQuote the Vendor shall submit with its response a signed
Resume Self-Certification Form (Exhibit B) to the Customer for each candidate included in
the eQuote response. See the DMS IT Staff Augmentation Contract website for details.
4. Contact Information Provide the main contact information at your company that you
would like the Department to use. Vendor contact information should include:
• Vendor contact's name
• Title
• Address
• Direct telephone number
• Email address
5. References Provide three (3) clients for which similar services were performed within the
past three (3) years for each proposed Project Manager. References should include:
• Reference contact's name
• Organization name
• Job title held by the candidate while employed or contracted
• Direct telephone number
• Email address
3.2 Candidate Submission
Please upload your candidate(s) resume and any supporting documents, if desired (i.e. skills matrix,
recommendations, etc.) here (maximum file size is 20 MB), if needed.
Vendors may submit multiple candidates for consideration. If you are submitting multiple
candidates upload ALL candidate submissions as ONE (1) PDF file per role.
4. Work Location
Location: The Department of Children and Families reserves the right to discuss with the selected
Vendor if the position will be full-time or remote. The selected candidate will be required to attend
onsite meetings and presentations on select days throughout the month at DCF HQW at your own
expense. Location is 2415 North Monroe Street, Tallahassee, FL 32303 or at the specified location.
5. Need help with MFMP?
Contact the MFMP Customer Service Desk at 866-352-3776 if you have any questions regarding
application functionality.
2 Scope of Services
The Department of Children and Families (the "Department " or "DCF ") is seeking qualified
candidates who will assist the Office of Information Technology (OITS) in their daily operations,
support, and services. The services requested in the following eQuote will be procured in accordance
with the Department of Management Services (DMS) State Term Contract (STC), entitled
Information Technology Staff Augmentation Services, 80101507-23-STC-ITSA.
The term for this staff augmentation position is intended to be until June 30, 2025. The term for
this engagement may be extended for a period not to exceed twelve months from the expiration of
the State Term Contract contingent upon funding and satisfactory performance. The Department
may select one or more candidates for this position. Candidates available immediately are preferred.
Preference will also be given to candidates available to work on-site in Tallahassee.
Candidates can either work part-time or full-time. The number of weeks is dependent upon the
available budget.
Quotes submissions due (on or before) October 25, 2024 3:00 PM
Anticipated Award Date Purchase Order Release N/A
2.1 Primary Job Duties and Tasks
The Office of Information Technology Services (OITS) is seeking Multiple Data Architect (STC
1410: Data Architect (C. Advanced)) positions.
The activities these candidates will be tasked with include, but are not limited to the following:
• Work with stakeholders and development team to determine project scope and vision,
gather and prioritize collected requirements.
• Designing and Implementing Data Architectures: Develop comprehensive data architectures
that support the organization's business goals, using Azure Synapse Analytics, Azure SQL,
and other Azure data services.
• Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL Pools in
Synapse to handle large-scale data warehousing and analytics workloads.
• Database Design and Management: Design, implement, and manage databases using Azure
SQL and Azure Managed Instance, ensuring high performance, availability, and security.
• Data Integration and ETL Processes: Develop and manage ETL (Extract, Transform, Load)
processes using Synapse Pipelines, ensuring efficient data flow from various sources to the
data warehouse.
• Data Governance and Cataloging: Implement data governance practices and manage the
data catalog to ensure data quality, consistency, and accessibility.
• Building and Maintaining Data Models: Create and maintain data models that accurately
represent the data landscape, ensuring they are scalable and optimized for performance.
• Ensuring Data Security and Compliance: Implement and oversee data security measures,
ensuring compliance with legal and regulatory standards.
• Maintain procedures manuals and system documentation.
• Research software solutions to support recommendations, analyzing current and future
technology trends.
These positions are to provide technical guidance and expertise in supporting the department in
developing, architecting, and maintaining data, data mappings, and monitoring high-volume
complex data transfer processes.
2.2 Specific Knowledge, Skills, and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the
following areas:
Minimum Required KSAs:
• 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database,
and Azure Managed Instance.
• 5+ years of experience in DDL, DML T-SQL skills, advanced stored procedure writing
skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process
logging, and error handling.
• 4+ years of experience in data architecture design principles, methodologies, and best
practices.
• 3+ years of experience in data governance principles and compliance requirements
related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large
data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure,
including storage solutions and compute capabilities.
• 1+ years of Experience with programming languages such as Python or Scala.
• 1+ years of experience in Salesforce, Message MQ, and MuleSoft
• Strong analytical and problem-solving skills to address complex data challenges.
• Ability to design and implement robust, scalable, and efficient data architectures.
• Ability to provide excellent customer support; meticulous quality of work and work
product.
2.3 General Knowledge, Skills and Abilities (KSAs)
The submitted candidate(s) must be able to apply common knowledge, skills, and abilities in the
following areas:
1. Communication: Able to 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, etc.). Must have the ability to effectively listen and process information provided by
others.
2. 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.
3. Decision Making: Makes sound, well-informed, and objective decisions.
4. Flexibility: Is open to change, new processes (or process improvement), and new information.
Has the ability to 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.
5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
6. Leadership: Motivates, encourages, and challenges others. Can adapt leadership styles in a
variety of situations.
7. Problem-Solving: Able to identify, evaluate, and use sound judgment to generate and evaluate
alternative actions, and make recommendations as accordingly.
8. Team Building: Encourages, inspires, and guides others toward accomplishing the common
goal.
2.3 Education and Certifications
Education: Bachelor's or Master's Degree in Computer Science, Information Systems, or other
related field. Or equivalent work experience. (Required)
Certifications: Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform
Certifications (Desired)
3 Vendor Response
Please include the following information in your candidate submission.
3.1 Responding Instructions and Documents to Provide
Please ensure each candidate submission contains the following documents and information:
1. Pricing information (REQUIRED): Please include the pricing (rate) for individuals or group
with your quote. The Department reserves the right to discuss lower rates with any vendor
selected prior to executing a contract through a Purchase Order.
2. Candidate Resume(s) Include relevant experience, certifications, education, etc. related to
the services requested in the Scope of Services.
3. Exhibit B - Resume Self-Certification Form Per the IT Staff Augmentation STC: When
submitting a response to an eQuote the Vendor shall submit with its response a signed
Resume Self-Certification Form (Exhibit B) to the Customer for each candidate included in
the eQuote response. See the DMS IT Staff Augmentation Contract website for details.
4. Contact Information Provide the main contact information at your company that you
would like the Department to use. Vendor contact information should include:
• Vendor contact's name
• Title
• Address
• Direct telephone number
• Email address
5. References Provide three (3) clients for which similar services were performed within the
past three (3) years for each proposed Project Manager. References should include:
• Reference contact's name
• Organization name
• Job title held by the candidate while employed or contracted
• Direct telephone number
• Email address
3.2 Candidate Submission
Please upload your candidate(s) resume and any supporting documents, if desired (i.e. skills matrix,
recommendations, etc.) here (maximum file size is 20 MB), if needed.
Vendors may submit multiple candidates for consideration. If you are submitting multiple
candidates upload ALL candidate submissions as ONE (1) PDF file per role.
4. Work Location
Location: The Department of Children and Families reserves the right to discuss with the selected
Vendor if the position will be full-time or remote. The selected candidate will be required to attend
onsite meetings and presentations on select days throughout the month at DCF HQW at your own
expense. Location is 2415 North Monroe Street, Tallahassee, FL 32303 or at the specified location.
5. Need help with MFMP?
Contact the MFMP Customer Service Desk at 866-352-3776 if you have any questions regarding
application functionality.
Source : Abacus Service Corporation
