Technical Analyst

Compunnel, Inc.; Cleveland (OH); On-site; USD 70,000 - 90,000; Full time

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.