Enterprise Data Integration Specialist

Compunnel Inc.

Cleveland (OH)

On-site

USD 70,000 - 90,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Compunnel, Inc. is looking for a Technical Analyst to support enterprise data integration initiatives. The ideal candidate will bridge business and technical teams, ensuring success in data migration and system integration.

Key responsibilities include analyzing data structures, developing data mapping specifications, and collaborating on requirements. Strong experience in ETL processes, querying relational databases like Oracle and SQL Server is essential.

Excellent communication skills and problem-solving abilities are necessary to work effectively with cross-functional teams.

Qualifications

  • Experience in data analysis and transformation.
  • Strong SQL querying and data analysis skills.
  • Experience with ETL processes and data governance.

Responsibilities

  • Analyze source system data structures for integration.
  • Develop data mapping specifications for migration projects.
  • Collaborate with stakeholders to define requirements.

Skills

Data analysis
Data transformation
ETL processes
SQL querying
Data mapping
Technical business analysis
Troubleshooting
Communication skills

Tools

Microsoft Excel
Oracle
SQL Server

Job description

We are seeking a Technical Analyst to support enterprise data integration and acquisition initiatives by analyzing, mapping, transforming, and validating business-critical data. This role serves as the bridge between business stakeholders and technical teams, ensuring successful data migration, system integration, and testing activities. The ideal candidate will have strong experience in data transformation, ETL processes, Oracle and SQL Server databases, and technical business analysis.

Key Responsibilities

• Analyze source system data structures to support enterprise data mapping and transformation initiatives.

• Develop and validate data mapping specifications for system integration and migration projects.

• Collaborate with developers, database administrators, business stakeholders, and subject matter experts to define functional and technical requirements.

• Perform data validation, reconciliation, and quality assurance throughout the data transformation lifecycle.

• Document data flows, transformation logic, mapping rules, and integration processes.

• Support ETL development and system integration activities.

• Participate in System Integration Testing (SIT), User Acceptance Testing (UAT), smoke testing, validation testing, and performance testing.

• Identify, troubleshoot, and resolve data quality, integration, and process issues.

• Ensure compliance with enterprise data governance standards and business processes.

• Prepare reports and communicate project status, data quality metrics, and transformation progress to stakeholders.

• Support cross-functional teams throughout data migration and acquisition integration activities.

• Contribute to continuous improvement of data integration, testing, and documentation processes.

Required Qualifications

• Experience in data analysis, data transformation, ETL processes, system integration, or technical business analysis.

• Strong experience with data mapping and enterprise data migration initiatives.

• Experience working with relational databases such as Oracle and Microsoft SQL Server.

• Strong SQL querying and data analysis skills.

• Advanced proficiency with Microsoft Excel.

• Strong understanding of ETL processes and data transformation concepts.

• Experience supporting System Integration Testing (SIT), User Acceptance Testing (UAT), smoke testing, validation, and performance testing.

• Experience working on Waterfall projects with structured milestones and deliverables.

• Strong analytical, troubleshooting, and problem-solving skills.

• Excellent verbal and written communication skills.

• Ability to collaborate effectively with both technical and business stakeholders.

Preferred Qualifications

• Experience in manufacturing, process manufacturing, chemical, or other regulated industries.

• Understanding of formulation, regulatory, inventory, and product data relationships.

• Experience with enterprise data governance and master data management practices.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Technical Analyst
Technical Analyst

Compunnel Inc. • Cleveland (OH)

On-site
USD 70,000 - 90,000
ETL Business Analyst
ETL Business Analyst

Interaction24,LLC • Wilmington (DE)

On-site
USD 70,000 - 90,000
Senior Enterprise Data Architect & Governance Lead
Senior Enterprise Data Architect & Governance Lead

Compunnel Inc. • South Carolina

On-site
USD 85,000 - 120,000
EDW Business Systems Analyst – Data & Snowflake Expert
EDW Business Systems Analyst – Data & Snowflake Expert

Compunnel Inc. • Columbus (OH)

On-site
USD 110,000 - 150,000
Data Integration Support Engineer
Data Integration Support Engineer

Whsmith • Las Vegas (NV)

On-site
USD 80,000 - 120,000
Senior Data Engineer & Oracle DBA for Enterprise Data
Senior Data Engineer & Oracle DBA for Enterprise Data

Compunnel Inc. • Merrimack (NH)

On-site
USD 120,000 - 180,000
Systems Engineer – Data Integration
Systems Engineer – Data Integration

myBridge Corporation • Denver (CO)

On-site
USD 90,000 - 140,000
Senior Data Solutions Architect
Senior Data Solutions Architect

Krasan Consulting Services • United States

On-site
USD 80,000 - 100,000
Senior EDW Business Systems Analyst: Data and Insights
Senior EDW Business Systems Analyst: Data and Insights

Compunnel Inc. • Addison (TX)

On-site
USD 90,000 - 120,000
Senior Data Engineer - 1018994
Senior Data Engineer - 1018994

Dexian • Covington (KY)

On-site
USD 120,000 - 160,000