Position Overview
Title: Data Engineer
Overview
PADNOS is seeking a Data Engineer on our Data and Software team who thrives at the intersection of data, automation, and applied AI. This role builds intelligent data pipelines and robotic process automations (RPAs) that connect systems, streamline operations, and unlock efficiency across the enterprise. You’ll design and develop pipelines using Python, SQL Server, and modern APIs—integrating services such as OpenAI, Anthropic, and Azure ML—to drive automation and accelerate business processes. Your work will extend beyond traditional data engineering, applying AI models and API logic to eliminate manual effort and make data more actionable across teams. You will report directly to Jared Duquette, IT Manager, at PADNOS Corporate in Grandville, MI. This is a hybrid role based in Grandville, Michigan.
ACCOUNTABILITIES
- Design and develop automated data pipelines that integrate AI and machine learning services to process, enrich, and deliver high-value data for analytics and automation use cases.
- Build, maintain, and optimize SQL Server ELT workflows and Python-based automation scripts.
- Connect to external APIs (OpenAI, Anthropic, Azure ML, and other SaaS systems) to retrieve, transform, and post data as part of end-to-end workflows.
- Partner with business stakeholders to identify manual workflows and translate them into AI-enabled automations.
- Work with software developers to integrate automation logic directly into enterprise applications.
- Implement and monitor data quality, reliability, and observability metrics across pipelines.
- Apply performance tuning and best practices for database and process efficiency.
- Develop and maintain reusable Python modules and configuration standards for automation scripts.
- Support data governance and version control processes to ensure consistency and transparency across environments.
- Collaborate closely with analytics, software, and operations teams to prioritize and deliver automation solutions that create measurable business impact.
MEASUREMENTS
- Reduction in manual hours across teams through implemented automations.
- Reliable and reusable data pipelines supporting AI and analytics workloads.
- Delivery of production-ready automation projects in collaboration with business units.
- Adherence to data quality and reliability standards.
- Continuous improvement in data pipeline performance and maintainability.
QUALIFICATIONS/EXPERIENCE
- Bachelor’s degree or equivalent experience in data engineering, computer science, or software development.
- Proficiency in T-SQL and strong understanding of relational data modeling.
- Intermediate to advanced Python development skills, particularly for data and API automation.
- Experience working with RESTful APIs and JSON data structures.
- Familiarity with AI/ML API services (OpenAI, Anthropic, Azure ML, etc.) and their integration into data workflows.
- Experience with modern data stack components such as Fivetran, dbt, or similar tools preferred.
- Knowledge of SQL Server performance tuning and query optimization.
- Familiarity with Git and CI/CD workflows for data pipeline deployment.
- Bonus: Experience deploying or maintaining RPA or AI automation solutions. #IND123
PADNOS is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation or any other classification protected by Federal, State or local law.
Be a part of the green movement and join PADNOS today!
PADNOS is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, weight, height, sex, sexual orientation, marital status, national origin, age, genetic medical information, protected veteran status, or disability status.
