Software Developer - COR
Posted Updated
Description
Buffalo Rock Company seeks a capable Data Engineer to own and advance our data infrastructure. You will develop and maintain Python-based ETL processes, data pipelines, and batch jobs while building robust data integrations across Snowflake, IBM DB2, PostgreSQL, REST APIs, EDI, SFTP and AS2.
The role emphasizes reliability, monitoring, and agile collaboration with stakeholders. You will leverage AI-assisted tools to improve code quality and documentation, while ensuring the correctness,
Develop and maintain Python ETL processes, data pipelines, batch jobs, file transformations, scheduled automation, and operational tools. Develop SQL-heavy backend and integration solutions across multiple database platforms. Design, troubleshoot, and support integrations and practical automation for finance, operations, EDI, reporting, and other business workflows, including dependencies, failure recovery, and downstream impacts. Transform, validate, reconcile, and report on operational data, with appropriate monitoring, data-quality checks, alerting, and exception handling. Investigate production issues across applications, databases, integrations, scheduled processes, and external systems; identify root causes and implement sustainable corrections. Learn the business processes behind the systems, translate requirements into practical designs, and work directly with stakeholders, vendors, and technical partners to make those designs work in production. Use AI-assisted development tools appropriately to improve consistency, documentation, testing, code quality, and adherence to established practices while retaining responsibility for understanding, validating, securing, and supporting all produced code. Take ownership of existing software and continuously improve its reliability, maintainability, and supportability. Current environment includes Python; SQL; Snowflake, IBM DB2, and PostgreSQL; REST APIs; EDI, SFTP, and AS2; Prefect and Windows Task Scheduler; GitHub and GitHub Actions; Visual Studio Code; and GitHub Copilot. Common Python libraries include pandas, requests, Typer, XlsxWriter, and keyring. Assist with additional departmental functions as required.Skills
Sign in to read and join the discussion.