REQUIRED CONSULTANT EXPERIENCE PROVIDED BY CONTRACTOR, SHALL INCLUDE:

• 5 years of experience with Snowflake data warehouse.
• 3 years of experience with no/low code ETL tools/platforms (e.g., Matillion, Talend, Informatica).
• 3 years of experience performing ETL processes using code (e.g. Python, SQL).
• Strong experience with data integration, data quality, and data governance.
• Strong experience with relational databases, SQL, and data modeling.
• Strong experience working collaboratively with business analysts, developers, and non-technical end
  users related to data warehousing.

PREFERRED EXPERIENCE:

• Excellent skills in communicating technical information to non-technical resources.
• Excellent troubleshooting skills.
• Excellent interpersonal and communication skills.
• Excellent communication and collaboration skills.
• Strong analytical and problem-solving skills.
• Detail-oriented, ability to switch tasks, ability to self-direct and prioritize tasks.
• Experience researching and investigating problems to develop viable solutions, report findings, and

provide clear and effective recommendations.

• Experience working in a project-oriented environment.
• Experience developing functional and technical specifications, design flow, and system blueprints.
• Experience with Microsoft Office 365.
• Ability to plan, organize and document IT solutions.
• Ability to plan, organize and coordinate IT work assignments with other technical resources.
• Ability to work independently and as part of a team.

REQUIRED DUTIES AND RESPONSIBILITIES OF CONSULTANT SHALL INCLUDE BUT ARE NOT LIMITED TO:

The Property Tax Oversight (PTO) program within the Florida Department of Revenue (DOR) seeks a Database
Analyst to create tables, migrate data, configure ETL pipelines, and create backup loads.
The Database Analyst position will provide consulting services in support of the creation of a Data Warehouse
for the Property Tax Oversight Program.

1. Writing ETL Pipelines

• ETL Tool Selection:

o Provide alternatives and advantages/disadvantages to aid in selection of a no/low code ETL

platform/tool.

• Design and Develop ETL Pipelines:

o Create, optimize, and maintain ETL pipelines to migrate data from various sources (Oracle, MSSQL,
flat files) to the target Snowflake data warehouse.
o Utilize a combination of coding (Python, SQL, etc.) and no/low-code tools (e.g., Azure Data

Factory, Talend, Informatica) to develop ETL processes that meet data integration needs.

• Data Transformation and Validation:

o Apply transformations to cleanse, filter, join, and aggregate data from the source systems.
o Ensure data quality by implementing validation rules to verify data correctness and

completeness before loading into Snowflake.

• Source-to-Target Mapping:

o Create detailed source-to-target mappings to ensure accurate transformation from source
systems (Oracle, MS-SQL) into Snowflake.

o Ensure solution provides data quality, consistency, and integrity throughout the ETL process.

• Automation and Scheduling:

o Work with other resources to automate the ETL processes to run at scheduled intervals based
on specific needs.

o Monitor and optimize ETL jobs to ensure they run efficiently and on time.

• Error Handling and Troubleshooting:

o Implement error detection, logging, and alerting mechanisms within the ETL pipelines.
o Troubleshoot ETL failures, identify root causes, and make necessary adjustments to ensure

pipeline stability.

• Performance Optimization:

o Tune ETL processes for performance improvements, minimizing resource consumption and

ensuring fast data migration.

• Testing:

o Develop test cases for ETL processes and data pipelines to ensure they meet business
requirements and are free of errors.
o Perform unit testing of ETL pipelines.