Senior ETL Analyst: Data Warehousing & SQL

Interaction24,LLC; Parsippany-Troy Hills (NJ); On-site; USD 70,000 - 90,000; Full time

Job summary

A data solutions firm is seeking an ETL Business Analyst in Parsippany-Troy Hills, New Jersey. The ideal candidate will have expertise in ETL mapping and SQL, playing a vital role in gathering and documenting requirements essential for successful data solutions. Responsibilities include collaborating with stakeholders, translating requirements into technical specifications, and ensuring data integrity through testing and analysis.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Proven experience as a Business Analyst in ETL projects.
• Proficiency in SQL for data analysis and querying.
• Experience with ETL tools is a plus.
• Strong analytical and problem-solving skills.

Responsibilities

• Collaborate with stakeholders to gather business requirements for ETL processes.
• Translate business requirements into technical specifications.
• Work closely with development teams on ETL implementations.
• Perform data analysis and profiling for data quality.
• Create and maintain documentation for ETL mappings.
• Conduct testing and validation of ETL processes.
• Provide troubleshooting assistance for ETL issues.
• Stay updated on industry best practices in ETL.

Skills

ETL mapping

Data mapping

SQL

Data analysis

Problem-solving

Education

Bachelor's degree in Computer Science

Tools

Informatica

Talend

SSIS

Job description

A data solutions firm is seeking an ETL Business Analyst in Parsippany-Troy Hills, New Jersey. The ideal candidate will have expertise in ETL mapping and SQL, playing a vital role in gathering and documenting requirements essential for successful data solutions. Responsibilities include collaborating with stakeholders, translating requirements into technical specifications, and ensuring data integrity through testing and analysis.