Data Platform Engineer

Description:

Convoy of Hope considers all team members to be ministers of the Gospel. Employment at Convoy of Hope is viewed as a calling from God to serve others through our faith and core values. As part of this calling, team members may be asked to pray with or provide spiritual care to fellow employees, donors, guests, or others we serve. Every team member is expected to model Christ-like character and to integrate their faith into their work and interactions.

Ministry Function:

The Data Platform Engineer will serve the ministry of Convoy of Hope as the organization’s primary administrator and technical owner for Snowflake, our central data platform. This individual will be responsible for the day-to-day administration, security, performance, governance, cost management, and ongoing development of our Snowflake environment. The role will support data integrations from several platforms within the organization’s data infrastructure.

The position will also support BI dashboard development and API-based integrations. The primary focus is ensuring that Snowflake is secure, reliable, well-governed, scalable, cost-conscious, and useful to teams across Convoy of Hope.

Serves as the primary administrator and day-to-day technical owner of the Snowflake data platform, ensuring it is secure, reliable, scalable, and well governed.

Administers Snowflake users, roles, privileges, warehouses, databases, schemas, stages, service accounts, and related platform objects.

Designs and maintains a scalable role-based access control model for departments, analysts, applications, vendors, and service accounts using least-privilege principles.

Manages Snowflake security practices, including access reviews, service credentials, SSO/MFA coordination, key-pair or OAuth-based access, and secure handling of sensitive data.

Monitors Snowflake platform health, warehouse activity, query performance, failed jobs, data availability, and integration reliability; troubleshoot issues as they arise.

Manages warehouse sizing, auto-suspend/auto-resume settings, resource monitors, credit usage, storage growth, and other cost-control practices.

Establishes and documents Snowflake standards for naming conventions, environments, schema organization, role design, warehouse usage, change management, and deployment practices.

Builds, supports, and troubleshoots data integrations from Dynamics 365, Salesforce instances, Log Alto, and additional enterprise applications as they are added.

Creates and maintains secure API-based data connections, including REST API integrations, OAuth or token-based authentication, JSON payload handling, flat-file ingestion, and related workflows.

Develops and supports ELT/ETL processes, SQL transformations, views, tables, tasks, streams, stored procedures, or orchestration patterns needed to move and prepare data in Snowflake.

Partners with application owners, vendors, consultants, TS leadership, analysts, and business teams to understand source-system data models, field definitions, refresh needs, and integration limitations.

Implements and supports data governance controls for donor, program, financial, staff, partner, and other sensitive organizational data.

Maintains data quality checks, validation processes, reconciliations, and issue-resolution workflows to improve trust in reporting and analytics datasets.

Partners with internal stakeholders to configure, support, and operationalize Snowflake capabilities for data validation, identity resolution, data quality workflows, and related platform use cases, while training technical staff and power users to use Snowflake CoWork effectively within established governance, security, and access-control standards.

Creates curated reporting layers, semantic datasets, and BI-ready Snowflake objects that support consistent organizational reporting and self-service analytics.

Build and maintain BI dashboards or reports as needed, while ensuring dashboards connect to governed, secure, and performant Snowflake data sources.

Create and maintain documentation, runbooks, access-request procedures, troubleshooting guides, integration notes, and…