Senior Database Analyst

  • Tallahassee, FL
  • Posted 15 days ago | Updated 15 days ago

Overview

Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
100% Travel

Skills

Advanced Analytics
Analytical Skill
Snow Flake Schema
Extract
Transform
Load
Data Warehouse Architecture
Microsoft Power BI
Database
Microsoft Azure
Data Warehouse
Data Governance
SPSS
SQL
Python
Reporting
Talend

Job Details

Only W2 and Local to Florida.

Job Title: Database Analyst- Advanced (DWH, ETL, SNOWFLAKE) Location: Tallahassee, FL - Onsite Employment Type: Contract Duration: 12 Months
Job Description:
Database Analyst- Advanced
The Property Tax Oversight (PTO) program within the Florida Department of Revenue (DOR) seeks a Data
Warehouse Architect to design, implement, and manage a Snowflake data warehouse and low-code ETL
pipelines from existing database systems. The goal is to optimize data storage, improve data accessibility, and
enhance analytical capabilities to support PTO functions.

10 years of experience in data warehouse architecture, design, and implementation.
5 years of experience with Snowflake data warehouse, including setting up and managing Snowflake
environments.
3 years of experience with no/low code ETL tools/platforms (e.g., Matillion, Talend, Informatica), including
setting up connectivity from data sources and Snowflake.
Strong experience with data integration, data quality, and data governance.
Strong experience with relational databases, SQL, and data modeling.
Extensive experience working collaboratively with business analysts, developers, network engineers, and
non-technical end users related to data warehousing.
Excellent skills in communicating technical information to non-technical resources.
Excellent troubleshooting skills.
Excellent interpersonal, 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 in building data warehouse solutions within a hybrid (on-prem and cloud) network architecture.
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.

1. Data Warehouse Design and Implementation:
o Design and develop a scalable, secure, and efficient Snowflake data warehouse architecture.
o Define data models and schemas to meet the business and technical requirements of the project.
o Implement flexible strategies to meet current and future data warehousing needs.
o Define backup and disaster recovery strategies to ensure business continuity.
o Define cost optimization strategies and resource monitors to ensure efficient use of Snowflake's
pay-per-use model.
o Define performance tuning strategies, including query optimization, result caching, and clustering.
2. ETL Selection and Implementation:
o Aid in the selection and implementation of a no/low code ETL platform/tool.
o Ensure solution provides data quality, consistency, and integrity throughout the ETL process.
o Optimize ETL processes for performance and reliability.
o Create approach to migrate data sets in batches based on the specific need.
3. Analytics Integration:
o Work with DOR IT resources to create and configure virtual desktops in existing Azure Commercial
architecture to be used by data scientists to run advanced analytics against the data warehouse
using tools (i.e. SPSS) and query languages (i.e. R, Python).
o Integrate Power BI instance with Snowflake data warehouse.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.