Senior Data Engineer (Snowflake)

📋 Description

• • As a Senior Data Engineer specializing in Snowflake, you will be instrumental in shaping and executing the data strategy for a prominent U.S.-based education services provider. This organization is dedicated to delivering high-quality online and campus-based post-secondary education, with a particular focus on serving military personnel, veterans, and public service communities. Your role will involve working with core product areas such as learning management systems, student enrollment, and academic operations, impacting both 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 will involve 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 to build and maintain sophisticated dimensional data models. These models are crucial for ensuring the integrity, quality, and structure of data, making it readily available and optimized for advanced analytics, business intelligence, and comprehensive reporting.
• • You will play a pivotal role in implementing and managing the Medallion architecture within Snowflake. This involves meticulously overseeing the bronze, silver, and gold layers, ensuring data is progressively refined and enriched to meet the highest standards of usability and accuracy for downstream consumption.
• • Collaboration will be central to your success. You will work closely with cross-functional teams, utilizing Jira for efficient task tracking, sprint planning, and progress monitoring, and GitHub for version control, code reviews, and collaborative development of data solutions.
• • Your expertise will be vital in ensuring the reliability and efficiency of ETL (Extract, Transform, Load) processes. This includes developing and optimizing data transformations and complex data integration workflows to support critical business functions and strategic decision-making.
• • You will actively contribute to the continuous improvement of data modeling practices within the organization. This involves identifying and addressing any weaknesses or inefficiencies in existing dimensional models, and championing best practices to enhance data architecture and governance.
• • This role offers a unique opportunity to make a significant impact on an organization that is committed to empowering its students through accessible and effective education. By ensuring the data infrastructure is robust and reliable, you will directly contribute to the success of their mission.
• • You will be expected to proactively identify opportunities for data pipeline optimization, performance tuning, and cost-efficiency within the Snowflake environment. This includes staying abreast of new features and best practices in data engineering.
• • The position requires a proactive approach to data quality assurance, implementing checks and balances throughout the data lifecycle to maintain accuracy and consistency.
• • You will be involved in troubleshooting and resolving complex data-related issues, ensuring minimal disruption to business operations and analytical capabilities.
• • This role is ideal for a seasoned data engineer who thrives in a dynamic environment and is passionate about leveraging data to drive educational excellence and innovation. Your contributions will be essential in enabling data-driven insights that inform strategic planning and operational improvements for the client.
• • You will also be expected to mentor junior team members and share your knowledge, fostering a culture of continuous learning and development within the data engineering team.
• • The ability to translate business requirements into technical data solutions will be a key measure of success in this role, ensuring that the data infrastructure directly supports the client's educational objectives and growth strategies.