Senior Data Engineer (Snowflake)

📋 Description

• • As a Senior Data Engineer specializing in Snowflake, you will be instrumental in shaping the data infrastructure for a prominent U.S.-based education services provider. This organization is dedicated to delivering accessible post-secondary education through online and campus-based programs, with a strong focus on serving military personnel, veterans, and public service communities. Your role will directly impact the effectiveness of their learning management systems, student enrollment processes, and academic operations across web and mobile platforms.
• • You will be responsible for the end-to-end design, implementation, and ongoing maintenance of robust and scalable data pipelines. This involves leveraging cutting-edge technologies such as Snowflake, Coalesce.io, and Airbyte, alongside SQL Server/SSIS and Azure Data Factory, to ensure seamless data flow and integration.
• • A core aspect of your work will involve building and meticulously maintaining dimensional data models. This is crucial for ensuring the delivery of high-quality, structured, and reliable data that fuels critical analytics and reporting functions. Your expertise will be vital in enhancing the overall data quality and accessibility for stakeholders.
• • You will play a key role in implementing and managing the Medallion architecture within Snowflake. This includes establishing and optimizing the bronze, silver, and gold layers, ensuring a structured and efficient approach to data processing from raw ingestion to refined analytical datasets.
• • Collaboration will be a cornerstone of your role. You will work closely with cross-functional teams, utilizing Jira for efficient task tracking and GitHub for version control and code management. This collaborative environment fosters innovation and ensures alignment across projects.
• • You will be tasked with ensuring the reliability, performance, and efficiency of ETL (Extract, Transform, Load) processes. This includes developing sophisticated data transformations and complex data integration workflows to meet the evolving needs of the client's educational services.
• • A significant part of your contribution will be to proactively identify and address weaknesses in current data modeling practices. You will champion best practices in dimensional modeling, driving improvements that enhance data usability, performance, and analytical capabilities across the organization.
• • You will contribute to the development and refinement of data governance strategies, ensuring data integrity, security, and compliance with relevant standards.
• • This role offers the opportunity to work on diverse projects within the education technology (ed-tech) domain, contributing to a mission-driven organization that empowers individuals through education.
• • You will be expected to troubleshoot and resolve complex data-related issues, ensuring the smooth operation of data systems and providing timely support to data consumers.
• • The position requires a proactive approach to identifying opportunities for data pipeline optimization, performance tuning, and cost-efficiency within the Snowflake environment.
• • You will be involved in documenting data processes, models, and architectures, creating comprehensive resources for knowledge sharing and future development.
• • Your analytical and problem-solving skills will be crucial in dissecting complex data challenges and formulating effective solutions that align with business objectives.
• • You will contribute to a culture of continuous improvement, sharing knowledge and mentoring junior team members where appropriate.
• • The role demands a strong understanding of the data lifecycle, from ingestion and transformation to storage and consumption, ensuring a holistic approach to data management.
• • You will work with a global team, requiring effective communication and coordination across different time zones and cultural backgrounds.
• • The opportunity to work with leading-edge data technologies and contribute to the digital transformation of an established educational institution makes this a highly rewarding position.