Remote Senior ETL Architect

Jobgether•New Jersey, NJ

1d•Remote

About The Position

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Senior ETL Architect - REMOTE. In this role, you will play a vital part in enhancing data analytics capabilities by designing robust ETL architectures using Microsoft SSIS. Your expertise will help shape data migration and warehousing solutions, ensuring data quality and integrity across various operational teams. This position requires a strong analytical mindset, as you will interact extensively with stakeholders to translate business needs into effective data solutions. As a mentor within your team, you're expected to lead discussions on ETL strategies and foster a culture of excellence in data management.

Requirements

Bachelor's Degree in Computer Science or related field or equivalent experience.
Minimum of seven years experience in business intelligence (BI) and ETL processes.
Strong expertise in SQL and experience with EPIC and data warehousing concepts.
Excellent analytical and problem-solving skills.
Strong communication and interpersonal abilities.
Experience with data profiling and data quality issues.
Familiarity with metadata management and master data management techniques.

Responsibilities

Design end-to-end ETL architecture for data migration and warehousing solutions using Microsoft SSIS.
Implement error handling and audit mechanisms for ETL jobs.
Mentor and train team members on best practices in ETL processes.
Collaborate with operational teams to ensure adherence to data governance standards.
Document specifications for BI reports, dashboards, and other outputs.
Troubleshoot database and application issues efficiently.
Participate in strategic discussions to evaluate new tools and technologies.