Data Integrations Engineer

Augustine Institute Inc; Florissant (MO); Ibrido; USD 85.000 - 115.000; Tempo pieno

Vantaggi offerti da questo lavoro

On-site Chapel with Daily Mass

403(b) retirement plan

On-site lunch

Paid time off

Descrizione del lavoro

The Augustine Institute seeks a Data Integrations Engineer to develop and maintain integrations and data pipelines across finance, fundraising, media distribution, and education systems. This role collaborates with the data architect to align with architecture and design patterns and aims toward end-to-end API design and AI-ready data products.

Onsite with some hybrid flexibility in Florissant, MO, the position includes growth into modern infrastructure and integration solutions, reporting to

Competenze

• 2+ years of professional experience developing data pipelines, integrations, or backend services.
• Proficiency in SQL and common coding/scripting languages.
• Experience building REST/JSON API integrations, including pagination and error handling.
• Knowledge of API authentication (API keys, OAuth 2.0, Bearer) and security.
• Familiarity with OpenAPI 3.0+ and data cataloging/quality concepts.
• Experience with ETL/ELT development and Git/GitHub workflows.
• Understanding of event-driven vs. batch processing integrations.
• Bachelor’s degree in CS/IT or equivalent practical experience.

Mansioni

• Develop and maintain integrations between internal systems and third-party platforms; document data contracts.
• Replace point-to-point integrations with maintainable solutions.
• Develop and maintain ETL/ELT pipelines for reporting and analytics.
• Develop internal APIs with support from back-end developers.
• Monitor health of integrations and pipelines; diagnose and resolve failures.
• Support new platform implementations and assess connections to existing environments.
• Enable business users to build automations within governance standards.

Conoscenze

Data pipelines

REST APIs

SQL

API security

OpenAPI

ETL/ELT

Git

Team collaboration

Formazione

Bachelor’s degree in Computer Science / IT

Strumenti

GitHub

TypeScript

Node.js

n8n

Workato

Airbyte

Databricks

dbt

Parquet

Microsoft Fabric

Descrizione del lavoro

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Integrations Engineer (onsite)

Full Time Technical Florissant, MO, US

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.