ETL Specialist

Why Join the Sikorsky Credit Union Team? Sikorsky Credit Union has been named the #1 Credit Union in Connecticut for 5 years in a row. We are one of the largest credit unions in the state, with over $1 billion in assets, and we continue to grow!

If you are passionate about helping people achieve their financial goals and want to make a difference in the local community, we want to hear from you! We are looking for talented people to help us improve the banking experience for our valued members.

Working at Sikorsky Credit Union has its benefits. You ll enjoy an awesome work-life balance, competitive pay, and an excellent benefits package that includes paid-time off, medical/dental, 401K plan with company match, tuition reimbursement and more! Please check out the details below to learn more about this position.

General Summary:

The ETL Specialist will be responsible for the design, development, and optimization of ETL processes that facilitate data extraction, transformation, and loading into Microsoft Dataverse. This role requires a deep understanding of ETL practices to manage the entire pipeline, ensuring data is accurately extracted from various sources, transformed into a usable format, and loaded into a target system like a data warehouse. The primary goal is to ensure data is accessible, accurate, and ready for analysis and reporting.

Key Essential Responsibilities:

1. Design, develop, and manage ETL pipelines that extract data from multiple sources, transform it according to business needs, and load it into Microsoft Dataverse.
2. Collaborate closely with business analysts, data architects, and other stakeholders to understand the requirements and ensure that the data processes align with organizational goals.
3. Monitor and troubleshoot ETL processes, ensuring accuracy, and optimizing performance and scalability.
4. Document the ETL process, including data mappings, flows, and optimization steps.
5. Ensure data governance and security policies are followed while providing ongoing support and training to end-users.
6. ETL Developer key tasks will include:
   1. Data Extraction: Retrieve data from varied sources like APIs, databases, and flat files.
   2. Data Transformation: Cleanse, validate, and transform data to fit business needs.
   3. Data Loading: Ensure efficient loading into target systems.
   4. Pipeline Design & Optimization: Build robust ETL workflows and optimize data loading for performance.
   5. Tool Proficiency: Expertise in tools like Informatica, Talend, SSIS, or similar platforms.
   6. Data Quality Assurance: Ensure data consistency, accuracy, and high quality.
   7. Collaboration & Documentation: Work with business stakeholders to understand requirements and document processes.
7. Promotes and maintains a positive work atmosphere by communicating in a manner consistent with professional standards to work effectively with members, co-workers, management, and vendors. Demonstrates the Credit Union s core values of Service, Teamwork, Integrity, and Responsibility.
8. Keeps abreast of industry developments including but not limited to changes in regulations and technology.
9. Ensures adherence to all company policies and procedures and Banking/Credit Union Regulations.
10. Performs additional duties as required.

Essential Skills, Knowledge and Requirements:

1. Bachelor s degree preferred in Computer Information Systems or Information Technology.
2. Minimum of 4 years of experience in ETL development and data integration, with a strong background in Microsoft Dataverse.
3. Advanced SQL knowledge, including query writing, stored procedures, and performance optimization.
4. Familiarity with relational databases like SQL Server and MySQL.
5. Ability to analyze data and communicate complex technical issues effectively to technical and non-technical stakeholders.
6. Understanding of Microsoft Power Platform (Power Apps, Power Automate) and cloud platforms (like Azure) is preferred.
7. Familiarity with MS Power Platform and cloud platforms (like Azure) preferred.
8. Experience with tools like Fiserv CRM/BI and Fiserv DNA is a plus.
9. Experience with data warehousing concepts and best practices is a plus.

Sikorsky Credit Union is an equal opportunity employer that is proud of its commitment to diversity and inclusion. Therefore, we welcome applicants from all communities, including age, color, ethnicity, familial or marital status, gender identity or expression, language, national origin, physical or mental disability, military or veteran status, race, religion, sexual orientation, and socioeconomic background.