Senior Data Engineer
As TWR's Senior Data Engineer, you'll serve as the primary technical implementer for the organization's data infrastructure, building and maintaining the pipelines, integrations, and reporting systems that keep a globally distributed Christian media ministry running. Working alongside a Lead Data Architect and a small team of staff and dedicated volunteers, you'll manage ETL/ELT processes that move data between CRM, general ledger, web platforms, and BI reporting tools, while also administering SQL Server environments and supporting stakeholders across the organization.
The role spans both modern cloud platforms and legacy on-premises systems, so you'll balance day-to-day operational stability with forward-looking migration planning as TWR evaluates new data platforms, CRM systems, and integration tools. Beyond the technical work, you'll help translate complex trade-offs into clear guidance for leadership, identify opportunities to reduce unnecessary complexity, and play a meaningful part in shaping how TWR's data ecosystem evolves over the coming years.
Duties and Responsibilities:
- Build, maintain, and optimize data pipelines across cloud and on-premises environments.
- Manage ETL/ELT processes that move data between CRM, general ledger, web platforms, and reporting systems.
- Maintain and improve cross-system integrations, identifying opportunities to reduce complexity and eliminate unnecessary dependencies.
- Support BI reporting infrastructure, including data models and dashboards used by stakeholders across the organization.
- Administer SQL Server environments including backups, performance tuning, and security.
- Participate in the evaluation of new data platforms, CRM systems, and integration tools.
- Contribute to migration planning as the organization moves from legacy systems toward modern, cloud-native alternatives.
- Communicate technical trade-offs clearly to both technical and non-technical audiences.
- Document systems, pipelines, integration logic, and operational procedures.
Experience Required:
- 5+ years of hands- on data engineering, data integration, or related experience.
- Strong SQL skills including complex queries, stored procedures, and performance tuning.
- Experience with at least one major cloud data platform (e.g. Aure Synapse, Snowflake, Databricks, Big Query or Redshift), with demonstrated ability to adopt cloud- native patterns rather than porting on- premises approaches to the cloud.
- Experience with ETL/ELT tools and patterns, whether cloud- native or traditional, with an understanding of how these approaches differ.
- Familiarity with SQL Server administration.
- Experience integrating data across multiple business systems (CRM, ERP/GL, web platforms) via APIs, database replication, or middleware.
- Demonstrated ability to work in mixed modern/legacy environments and help organizations transition from one to the other.
Desired Experience:
- Experience with more than one cloud data platform, or with migrating between platforms.
- Familiarity with BI tools such as Power BI, Tableau, or Locker.
- Experience in nonprofit or mission- driven organizations.
- Exposure to donor management or CRM systems.
- Experience evaluating and selecting enterprise software platforms.
- Working knowledge of Python, PowerShell, or other scripting languages.
