Database Developer at Greater Kansas City Community Foundation

Kansas City, Missouri, United States -

Full Time

Start Date

Immediate

Expiry Date

09 Jun, 26

Salary

0.0

Posted On

12 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Pipelines, Azure Data Factory, Fabric Data Factory, SSIS, ETL, ELT, Data Warehouse, Orchestration, Automation, AI Capabilities, Data Reliability, Monitoring, SQL, API Integration, JSON, XML

Industry

Philanthropy

Description

Description The Database Developer is responsible for designing, building, and maintaining reliable data integration pipelines that power enterprise reporting, analytics, and operational systems. This role focuses on the consistent and secure movement of data across applications, warehouses, and cloud platforms. The Database Developer works across the organization to provide reliable, analytics-ready data that informs effective decision-making. This is a full-time, exempt, salaried position reporting to the Director of Data Technologies. Candidates must be local to Kansas City, MO, and after a successful training period, there are opportunities to work remotely. Requirements Data Pipelines & Integrations Design, build, and maintain scalable batch and near-real-time data pipelines. Develop integrations using tools such as Azure Data Factory, Fabric Data Factory, SSIS, or equivalent technologies. Maintain clear, well-documented data processes that ensure secure, reliable data delivery. Ensure pipelines are secure, reliable, and well-documented. ETL / ELT Development Develop structured ETL and ELT processes that support data warehouse models and downstream analytics. Partner with staff to ensure data structures align with reporting and semantic model needs. Scheduling & Automation Manage orchestration, scheduling, and dependencies across data workflows. Implement automation to improve reliability, monitoring, and recovery from failures. AI Platform Readiness Partner with leadership to evaluate, govern, and leverage AI-enabled capabilities within the data platform ecosystem. Leverage AI-assisted tooling to improve platform reliability and operations efficiencies. Data Reliability & Monitoring Monitor pipeline execution and proactively identify failure patterns. Implement improvements to increase resiliency, observability, and operational predictability. Source System Integration Work with application owners (e.g., financial systems, CRM platforms) to understand data structures, APIs, and integration requirements. Maintain clear documentation for data flows, lineage, integration logic, and operational processes. Support ingestion of files, APIs, JSON/XML payloads, and database sources. Education & Experience At least 3-6 years of related experience with a bachelor's degree. An equivalent combination of education and experience will be considered. Required Technical Background Hands-on experience developing and supporting ETL/ELT pipelines in Azure, SQL Server, or comparable data environments. Strong SQL skills with the ability to troubleshoot data quality, transformation, and performance issues. Experience integrating data from APIs, SaaS platforms, files, and relational databases (including JSON and XML payloads). Experience managing job orchestration, scheduling, documentation, retries, and failure of recovery for data workflows. Familiarity with version control (Git) and deployment practices for data pipelines and integration code. Ability to monitor pipeline execution and proactively identify and remediate reliability issues. Preferred Background Experience with Azure Data Factory, Fabric Data Factory, SSIS, or similar tools. Exposure to cloud data warehouses or analytics platforms. Experience working in regulated, audit-conscious, or highly governed environments. Physical Requirements Office & Computer Work: Ability to work regularly at a computer terminal in a fast-paced environment with frequent interruptions. Noise & Communication: Able to work in an office with moderate noise levels. Ability to communicate and interpret detailed information effectively. This job description serves as a summary of the employment-at-will relationship and is not a contract. Responsibilities may evolve, and other duties may be assigned as needed.

Responsibilities

The Database Developer designs, builds, and maintains reliable data integration pipelines for enterprise reporting, analytics, and operational systems, focusing on secure and consistent data movement across various platforms. This role involves developing ETL/ELT processes, managing workflow orchestration, and ensuring data reliability and observability.