Position Summary:The Senior Snowflake Engineer is responsible for managing and optimizing our Snowflake data warehouse environment to support our data-driven initiatives. This position will have a lead responsibility in overseeing the Snowflake data warehouse, ensuring its availability, performance, security, and scalability. The Senior Snowflake Engineer works closely with the Business Intelligence team and cross-functional teams to enhance the ministry's data services and data management. Essential Functions:
Lead in overseeing the Snowflake data warehouse, ensuring its availability, performance, security, and scalability.Manage Snowflake users, roles, and resource monitors, ensuring compliance with security and data governance policies.Monitor and optimize Snowflake's performance and cost, including query tuning and optimizing data storage.Collaborate with BI and software teams to design and implement effective data models and ETL processes.Focus on heinous data engineering by building, maintaining, and optimizing Streams, Tasks, Stored Procedures, Functions, Views, Materialized Views, and Dynamic Tables.Stay current with Snowflake features and updates, implementing best practices and upgrades.Take a lead role in data migration projects, ensuring smooth and efficient transfer of data to the Snowflake environment.Provide technical support and training to team members on Snowflake usage and best practices.Prepare and maintain detailed documentation regarding the Snowflake environment, including configuration, processes, and policies. Work closely with Snowflake support to resolve any technical issues.Job SpecificationsJob Title: Senior Snowflake EngineerStudy or Knowledge or Experience:
- Bachelor's degree in Information Technology, or equivalent experience.
- Proven experience (4+ years) in a Snowflake Data Engineering role as a lead in the design and implementation of complex data solutions in large-scale organizations.
- Expertise in SQL and experience with ETL tools and processes.
- Familiarity with data warehousing concepts, data modeling, and big data technologies.
- Experience with Snowflake security management, data sharing, and performance tuning.
- SnowPro Certifications a plus.
- Understanding of external integrations such as Azure Blob Storage.
- Understanding of Salesforce CRM and Marketing Cloud.
- Understanding of CCPA and GPDR.
- Strong problem-solving skills, with the ability to analyze complex business processes and design scalable solutions.
- Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse teams and stakeholders.
- Knowledge of Agile methodologies and project management practices.
- Strive to live a life consistent with Biblical principles, engaged with the Bible on a consistent basis and demonstrate continued growth and spiritual development.
Internal Work Environment:Develop, maintain, and improve communication channels among various teams and departments to ensure effective flow of information throughout the organization. Facilitate cross-functional collaboration and teamwork. Handle sensitive situations or controversial issues with tact, discretion, and sensitivity. Exhibit excellent judgment regarding the appropriate content and timing of communications. Break down complex concepts into easily understandable formats for various audiences across the organization. Develop strategies to present and share complex information.Create and deliver software demonstrations for meetings and other high-level gatherings.External Communication:Establish and maintain communication with vendors, partners, and other external stakeholders. Understand their needs, expectations, and requirements to foster positive and productive relationships and model Biblical principles.Leadership Responsibility:May serve as a lead for other Snowflake engineers or administrators.Stewardship of Resources:Contribute to the budget planning process for data initiatives, providing expert input on anticipated resources required for data, storage, as well as necessary tools and technologies. Offer insightful feedback to ensure cost-effectiveness and alignment with project goals.Miscellaneous:Occasional domestic travel within the United StatesOur Daily Bread Ministries is a nondenominational nonprofit with staff and volunteers across the globe and resources distributed in 150 countries and in more than 58 languages. As a global ministry faithful to Biblical principles, our commitment to diversity is reflected in our ministry's mission, vision, values, and ethos.