> Markdown version of [/jobs/ext/3460489-etl-data-analyst-it-business-analyst](https://www.wearedevelopers.com/jobs/ext/3460489-etl-data-analyst-it-business-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Data Analyst / IT Business Analyst

- **Company:** Vortex Consulting
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Data Dictionary, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Warehousing, Database Queries, Software Debugging, Operational Data Store, Query Optimization, Standard Sql, Product Software Implementation Methods, SQL Databases, Data Streaming, Enterprise Software Applications
- **Published:** September 23, 2026
- **Apply:** https://www.dice.com/job-detail/4c2fb06b-c668-4744-85e2-c298dffbaa98

## About the Role

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., * 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

## Description

* 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.