Data Engineer

Job Description

Job Description

We are looking for a Data Engineer to help maintain and improve a mission-driven technology environment that supports essential nonprofit operations in Battle Creek, Michigan. This position blends application support, database engineering, and systems integration work, making it ideal for someone who enjoys solving technical problems across multiple platforms. The role works closely with internal teams and external partners to keep business systems reliable, data accurate, and reporting processes running smoothly.

Responsibilities:
• Maintain and resolve issues across core business applications, including Dynamics 365 Business Central, Microsoft 365, SharePoint, Power BI, procurement tools, workforce systems, and other connected platforms.
• Administer Microsoft SQL Server environments by monitoring system health, tuning performance, managing security access, and overseeing backup, recovery, upgrade, and capacity planning activities.
• Build, refine, and troubleshoot SQL queries to support operational needs while identifying and correcting data consistency, accuracy, and reconciliation problems between systems.
• Develop and support integrations, APIs, ETL processes, Azure Data Factory workflows, scheduled data exchanges, and SFTP-based transfers to ensure dependable movement of information across platforms.
• Investigate reporting and data warehouse issues by resolving failed loads, refresh interruptions, and mismatches between source systems and business intelligence outputs.
• Contribute to software rollouts and system enhancements through testing, data conversion support, deployment activities, post-launch issue resolution, and production stabilization efforts.
• Partner with software vendors and external service providers to diagnose complex technical challenges and drive incidents through to completion.
• Create and maintain clear technical documentation for applications, databases, integrations, and data flows while sharing knowledge with teammates to strengthen team coverage.
• Support both strategic engineering work and day-to-day technical tasks within a collaborative IT team, adapting to changing priorities as needed.• Hands-on experience administering Microsoft SQL Server, including query development, database maintenance, performance analysis, indexing, backup and recovery, migrations, and upgrades.
• Proven ability to support enterprise applications in production environments and troubleshoot issues affecting business-critical operations.
• Experience designing or maintaining APIs, ETL workflows, web services, and system-to-system integrations across multiple business platforms.
• Working knowledge of Azure Data Factory, data pipelines, and data movement processes such as SFTP and scheduled interface jobs.
• Familiarity with reporting and analytics dependencies, including data warehouse concepts, Power BI, and source-to-report reconciliation.
• Strong root-cause analysis skills with the ability to investigate issues spanning applications, databases, integrations, and infrastructure components.
• Experience with Microsoft technologies such as Dynamics 365 Business Central, SharePoint, Microsoft 365, and related Azure or Power Platform services is strongly preferred.
• Proficiency with tools and technologies such as Python, Apache Spark, Hadoop, Kafka, and Azure Pipelines is beneficial.