ETL Architect

ETL Architect Location: Local to either Providence or Martha's Vineyard, onsite 2-3 days per week Interview Process: 2 rounds with Head of IT Job Title: ETL Architect Job Description: We are seeking a talented ETL Architect with a strong background in cloud technologies, particularly Snowflake, and experience in the banking industry. As an integral member of our team, you will be responsible for designing, implementing, and optimizing our Extract, Transform, Load (ETL) processes to ensure efficient data integration and analytics capabilities. Responsibilities: 1. Architect, design, and implement end-to-end ETL solutions that meet business requirements and ensure data quality and integrity. 2. Leverage cloud platforms, with a particular emphasis on Snowflake, to develop scalable and performant ETL processes. 3. Collaborate with business stakeholders, data engineers, and data scientists to understand data requirements and design ETL solutions accordingly. 4. Ensure compliance with banking regulations and security standards in all aspects of ETL architecture and implementation. 5. Optimize ETL workflows for performance, scalability, and cost-effectiveness on cloud platforms. 6. Work closely with cross-functional teams to integrate ETL processes with other data-related systems and applications. 7. Implement and enforce best practices for data governance, data lineage, and metadata management. 8. Stay current with industry trends, emerging technologies, and advancements in ETL and cloud computing. Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, or a related field. 2. Proven experience as an ETL Architect with a focus on cloud technologies in the banking or financial sector. 3. Hands-on experience with Snowflake, including designing and optimizing data warehousing solutions. 4. Strong understanding of ETL principles, data integration patterns, and best practices. 5. Proficient in cloud platforms such as AWS, Azure, or Google Cloud Platform. 6. Familiarity with data modeling concepts and techniques. 7. Excellent problem-solving and analytical skills with attention to detail. 8. Effective communication skills to collaborate with diverse teams and articulate complex technical concepts to non-technical stakeholders.

Created: 2024-10-19