Apply Now

ETL Data Analyst

Remote • Posted 56 minutes ago • Updated 56 minutes ago

Contract W2

Contract Independent

4 Months

No Travel Required

Remote

Depends on Experience

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

SQL
Data Mapping
ETL
Functional Design Specs

Summary

Seeking an experienced ETL Data Analyst / IT Business Analyst with excellent communication skills that can bridge the gap between Operational Data and Business Intelligence by extracting data from source systems, transforming it into a clean and usable format, loading it into a data warehouse, and analyzing it to drive business decisions.

Key Responsibilities

Write Functional Design Specs - Draft functional design documents that identify data sources from ERP systems, 3rd party systems, files, or scanned images and how best to map data into data warehouses
Data Transformation & Cleansing: Format, and standardize data records to ensure consistency and accuracy before analytical reporting.
Data Mapping & Modeling: Create and maintain source-to-target mapping documents, data dictionaries, and transformation business rules.
Query Optimization: Write and optimize SQL queries to extract data
Data Quality & Validation: Monitor datasets for completeness and integrity, performing reconciliation and troubleshooting data discrepancies.
Reporting & Insights: Build dashboards, generate analytical reports, and present data trends to business stakeholders.

Required Skills & Qualifications

SQL Proficiency: Proficient SQL skills to write, debug, and optimize SQL queries.
Data Mapping / ETL Knowledge: Experience with Data Mapping and ETL concepts
Analytical Thinking: Strong aptitude for data analysis and root-cause investigation
Documentation: Ability to maintain clear data flow and data mapping specifications.
Communication: Strong stakeholder-facing skills to capture business requirements and write functional design specification documents
Prior experience: Prior IT project experience supporting a large enterprise software implementation (ERP) and knowledge of Software Implementation Lifecycle

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: vortexny
Position Id: 9092954
Posted 56 minutes ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Engineer II

Remote

•

Today

Start/End Dates: 11/16/2026 - 5/15/2027 Tax Work Location: US - CA - Remote Job Title: Data Analytics & Engineering - Data Engineer II Job Description: Summary: The main function of the Data Engineer is to develop, evaluate, test and maintain architectures and data solutions within our organization. The typical Data Engineer executes plans, policies, and practices that control, protect, deliver, and enhance the value of the organization's data assets. Years of overall experience required? 3+ Y

Easy Apply

Contract, Third Party

$132

ETL Developer (Azure Data Factory/MS Fabric) - Remote Opportunity

Remote or Duncan, South Carolina

•

Today

AFL manufactures industry-leading fiber optic cable, connectivity and accessories and provides engineering and installation services for some of the largest telecom customers in the world. Our company was founded in 1984 with a single fiber optic cable and today, we manufacture thousands of products, generate an excess of $4B in revenue, and employ approximately 12,000 associates worldwide. At AFL, we recognize that our employees are our greatest asset. We hire and train each individual, investi

Full-time

Data Engineer

Remote or Bethesda, Maryland

•

Today

Analytica is seeking a Data Engineer to support a key, long-term federal government client program and software product. The ideal candidate will be comfortable working in an agile, multi-faceted team that involves direct, collaborative client engagement to design and develop software products. Analytica has been recognized byInc. Magazineas one of the fastest-growing 250 businesses in the US for 3 years. We work with U.S. government clients in health, civilian, and national security missions to

Full-time

Senior Data Migration / Data Purging Lead

Remote or New York, New York

•

Today

job summary: We are seeking an experienced Senior Data Migration & Purging Lead to guide and execute the technical separation, archiving, and migration of critical R&D applications. In this pivotal role, you will work closely with enterprise application owners, R&D engineering SMEs, and database teams to establish data inventories, define retention and purge rules, and lead seamless data transitions. Your expertise will safeguard system integrity, maintain strict data governance, and ensure ope

Contract

USD80 - USD85

Search all similar jobs

Remote jobs at Vortex Consulting, Inc