Sr Technical Analyst for Legacy cleanup

Atlanta, GA, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Contract Independent
Contract Corp To Corp
No Travel Required
On-site
$60 - $62/hr
Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

  • data governance
  • Database: Oracle (Legacy)
  • Snowflake (Target) Transformation: SQL
  • dbt Other: Data Modeling
  • ETL/Data Pipelines

Summary

Role: Sr Technical Analyst for Legacy cleanup

 

Location: Atlanta, GA – 5 days – Onsite

 

Contract role

 

Tools & Technologies

 

Database: Oracle (Legacy), Snowflake (Target)

Transformation: SQL, dbt

Other: Data Modeling, Data Governance, ETL/Data Pipelines

 

Key Responsibilities

  1. Legacy Data Cleanup: Analyze, audit, and clean up legacy data objects within Oracle and Snowflake environments to improve data quality and compliance.
  2. Data Housekeeping: Identify and retire unused tables, views, procedures, and data sets in the legacy system.
  3. SQL & Optimization: Write advanced SQL for data analysis, profiling, and optimizing data models in Snowflake (e.g., clustering, partitioning).
  4. Migration Support: Collaborate with data engineers to map legacy Oracle data structures to the modern Snowflake cloud data model.
  5. Documentation & Governance: Document data lineage, business rules, and technical specifications for data lifecycle management.
  6. dbt (Nice to Have): Utilize dbt (Data Build Tool) for transforming and modeling data.

 

Requirements

  1. Expertise in Oracle SQL and database structures.
  2. Strong experience with Snowflake data cloud, including data modeling and SQL.
  3. Proven experience in data cleansing, data migration, and data lifecycle management.
  4. Proficiency in data analysis and ETL processes.
  5. Nice to Have: Experience with dbt (Data Build Tool).
  6. Excellent communication skills to work between technical teams and business stakeholders.
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.
  • Dice Id: 10120137
  • Position Id: 67729-10367-
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Atlanta, Georgia

Today

Easy Apply

Contract

Depends on Experience

Hybrid in Atlanta, Georgia

Today

Easy Apply

Contract, Third Party

Depends on Experience

Atlanta, Georgia

Today

Easy Apply

Contract, Third Party

Up to $60

Hybrid in Atlanta, Georgia

Today

Easy Apply

Contract

54 - 55

Search all similar jobs