Data Integrations Engineer (onsite)

Augustine Institute; Florissant (MO); Ibrido; USD 90.000 - 120.000; Tempo pieno

Vantaggi offerti da questo lavoro

403(b) retirement plan

On-site chapel with Daily Mass

On-site lunch

Descrizione del lavoro

The Augustine Institute seeks a Data Integrations Engineer to develop and maintain integrations and data pipelines that support finance, fundraising, media distribution, and education. You will document data contracts between systems and coordinate with the data architect to ensure alignment with architecture and design patterns.

This role offers growth into end-to-end API design, preparing our data products for AI use, and migrating our data platform to a modern infrastructure, with onsite work

Competenze

• 2+ years building data pipelines, integrations, or backend services.
• Strong SQL and scripting language skills.
• Experience with REST/JSON API integrations and OpenAPI specs.
• Familiarity with API security (keys, OAuth2, Bearer).

Mansioni

• Develop and maintain integrations between internal systems and third-party platforms.
• Remediate point-to-point integrations into maintainable solutions.
• Develop ETL/ELT pipelines to support reporting and analytics.
• Create internal APIs with back-end support and governance.
• Monitor health, diagnose failures, and resolve issues.
• Assist platform implementations and assess new system connections.
• Enable business users to build automations within governance standards.

Conoscenze

SQL proficiency

REST & JSON APIs

Git & GitHub

API authentication

Data pipelines

ETL/ELT development

Formazione

Bachelor’s degree in CS/IT or equivalent

Strumenti

Git

n8n

Airbyte

Databricks

OpenAPI 3.0+

Descrizione del lavoro

Position: Data Integrations Engineer (onsite with some hybrid flexibility, Florissant, MO)

Schedule: Full Time

FLSA: Exempt (not eligible for overtime)

Reporting to: Senior Manager of Enterprise Technology

Position Summary

The Augustine Institute seeks a Data Integrations Engineer to develop and maintain the integrations and data pipelines connecting the platforms that support our operations, including finance, fundraising, media distribution, and education. This role builds and maintains integration solutions and data pipelines, documents the data contracts between systems, and coordinates with the organization’s data architect to ensure new development aligns with established architecture and design patterns. The position offers room to grow into end-to-end API design and ownership, preparing our data products for AI use, and migrating our data platform to a modern infrastructure.

Specific duties are listed below, but may not be all-inclusive.

Duties and Responsibilities

• Develop and maintain integrations between internal systems and third-party platforms, and document the data contracts between them
• Remediate and replace point-to-point vendor integrations with documented, maintainable solutions
• Develop and maintain the ETL and ELT pipelines supporting reporting and analytics
• Develop code for internal APIs, with support from our back-end developer
• Monitor integration and pipeline health, diagnose failures, and resolve them
• Provide integration support during new platform implementations, including assessment of how a new system connects to the existing environment
• Enable business users to build their own automations within defined governance standards

Qualifications

• 2+ years of professional experience developing data pipelines, integrations, or backend services
• SQL proficiency, plus working proficiency in common coding and scripting languages
• Demonstrated experience building and maintaining REST and JSON API integrations, including pagination, rate limiting, webhooks, and error handling
• Working knowledge of API authentication and security, including API keys, Basic and Bearer auth, OAuth 2.0, and HMAC signing
• Working knowledge of idempotency and retry safety in integration design, including correct handling of duplicate message delivery, retries, and dead letter queues
• Understanding of the tradeoffs between event-driven and synchronous integration patterns, and between batch polling and publish/subscribe models
• Working knowledge of the OpenAPI specification (3.0+)
• Familiarity with large-data principles such as partitioning, replication, and incremental loads
• Familiarity with data cataloging, classification, lineage, and quality control
• Experience with ETL or ELT development, and with version control using Git and GitHub, including pull request workflows
• Bachelor’s degree in Computer Science, Information Technology, or equivalent practical experience

Preferred Qualifications

• Experience with platforms in use at the Augustine Institute, such as NetSuite, HubSpot, Domo, Oracle, Salesforce, or with comparable financial and CRM systems
• Experience with TypeScript and Node.js
• Experience with workflow automation or iPaaS platforms such as n8n or Workato, or with data platforms such as Airbyte, Databricks, or Microsoft Fabric
• Experience with Parquet, dbt, medallion (bronze / silver / gold) data architecture, or client-side versus server-side analytics collection

Skills and Abilities

• Hands-on software development capability; familiarity with low-code automation tools such as n8n is expected, but proficiency limited to those platforms is not sufficient for this position
• Ability to assess and remediate accumulated technical debt across undocumented integrations
• Effective oral and written communication skills, including the ability to explain technical tradeoffs to non-technical stakeholders
• Ability to work effectively in a collaborative team environment and to coordinate across departments
• Commitment to demonstrate consistently the Augustine Institute’s core values including:
  • Excellence– Win Souls for Christ
  • Innovation– Foster a Creative and Resourceful Mindset
  • Collaboration– Be the Body of Christ
  • Humility– Place Mission over “Me”
  • Community– Build up the Church

Physical Demands

While performing the duties of this job, the employee is regularly required to perform stooping, kneeling, crouching, reaching, standing, walking, lifting, typing and use of office equipment, talking, hearing, seeing, and repetitive motions.

While performing the duties of this job, the employee will typically work in a climate-controlled office setting.

Employee Benefits

Competitive compensation, paid time off, and a 403(b) retirement plan, on-site Chapel with Daily Mass and the Sacrament of Reconciliation regularly, on-site lunch.