Senior Data Engineer (Snowflake)

📋 Description

• • Embark on a pivotal role as a Senior Data Engineer, specializing in Snowflake, to architect, develop, and maintain robust and scalable data pipelines that are the lifeblood of a leading U.S.-based education services provider. This organization is dedicated to delivering high-quality online and campus-based post-secondary education, with a strong focus on serving military personnel, veterans, and public service communities. You will be instrumental in shaping the future of their data infrastructure, supporting critical areas such as learning management systems, student enrollment, and academic operations across web and mobile platforms.
• • Your primary responsibility will be the end-to-end design, implementation, and ongoing maintenance of sophisticated data pipelines. This involves leveraging cutting-edge technologies including Snowflake, Coalesce.io, Airbyte, and SQL Server/SSIS, with strategic utilization of Azure Data Factory to ensure seamless data flow and integration.
• • A key aspect of your role will be the construction and meticulous maintenance of dimensional data models. These models are essential for ensuring the highest quality, structured, and accessible data, thereby empowering advanced analytics, comprehensive reporting, and informed decision-making across the organization.
• • You will be a champion for the Medallion architecture within Snowflake, expertly managing and optimizing the bronze, silver, and gold layers. This structured approach ensures data is progressively refined, validated, and prepared for diverse analytical needs, from raw ingestion to curated business-ready insights.
• • Collaboration is at the heart of this role. You will work closely with cross-functional teams, utilizing Jira for efficient task tracking and GitHub for robust code repository management, fostering a transparent and agile development environment.
• • Ensuring the reliability, efficiency, and accuracy of ETL processes, complex data transformations, and intricate data integration workflows will be paramount. Your expertise will directly contribute to the integrity and availability of critical data assets.
• • You will play a crucial role in elevating the organization's data modeling practices. This includes identifying and addressing weaknesses in existing dimensional models and implementing best practices to enhance data quality, performance, and usability.
• • This position offers a unique opportunity to contribute to an organization with a significant social impact, supporting educational advancement for dedicated communities. Your work will directly influence the operational efficiency and strategic growth of an institution committed to empowering its students.
• • You will be expected to contribute to the continuous improvement of data infrastructure, exploring new technologies and methodologies to optimize performance, reduce costs, and enhance data governance.
• • The role demands a proactive approach to problem-solving, identifying potential data issues before they impact downstream processes and implementing effective solutions.
• • You will be a key contributor to the data strategy, providing insights and recommendations based on your deep understanding of data engineering principles and the specific needs of the education sector.
• • This is a remote position, offering flexibility while requiring a minimum 4-hour overlap with US Eastern Time to facilitate effective collaboration with stakeholders and team members.
• • You will be part of a global tech company with a strong engineering legacy, working on international projects and contributing to the success of Fortune 500 clients, alongside this specific educational services provider.