Data Engineer

InnoSource seeks a Data Engineer in Dublin, Ohio, onsite, to design, implement, and maintain scalable data pipelines and analytics solutions on Azure, partnering with stakeholders to ensure data quality and enable enterprise analytics and reporting.

Responsibilities

• Design, build, and operate robust, scalable data pipelines in Azure using services such as Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake.
• Ingest and integrate data from diverse sources including APIs, databases, and files into centralized analytics repositories.
• Develop and manage ETL and ELT workflows that transform raw data into clean, analytics-ready models aligned with business requirements.
• Establish a microservices architecture that scales with business growth and AI capabilities.
• Construct data pipelines that feed AI models with clean, structured logistics data.
• Deploy real-time analytics engines powering predictive logistics capabilities.
• Ensure data quality, integrity, and governance through validation, monitoring, and alerting mechanisms.
• Collaborate with business and technical teams to capture data requirements and align data assets with strategic needs.
• Implement cost-efficient data engineering practices, optimizing performance while controlling cloud usage and storage costs.
• Maintain and enhance a semantic data layer or curated datasets to support self-service BI with Power BI and advanced analytics.
• Contribute to the architecture of the data platform, focusing on security, scalability, and performance best practices.
• Automate data operations and deployment workflows using CI/CD pipelines and infrastructure as code, including ARM, Bicep, or Terraform.
• Stay current with advancing Azure technologies and propose improvements to existing data workflows.
• Additional duties as assigned.

Requirements

• Proven experience building and managing data pipelines in Microsoft Azure environments.
• Proficiency with tools such as Azure Data Factory, Synapse Analytics, Data Lake, and Power BI integration.
• Strong knowledge of SQL, data modeling, and ELT/ETL patterns.
• Experience working with APIs, JSON, and structured and unstructured data sources.
• Demonstrated ability to work cross-functionally to define and deliver high-quality data solutions.
• Strong organizational skills and the ability to multitask, set priorities, work with diverse teams, work independently, manage competing priorities, and meet deadlines while maintaining quality.
• Availability to work a flexible schedule as needed.
• Proficient in Microsoft Office Suite.
• Demonstrated leadership skills with the ability to communicate and collaborate effectively with cross-functional teams.
• Attention to detail, with a focus on accuracy and compliance in a fast-paced environment.
• Logistics or supply chain experience preferred.

Technologies

• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake
• Power BI
• SQL
• JSON
• Terraform
• Bicep
• ARM
• Microsoft Office Suite

Benefits

• Dental insurance
• Health insurance
• Life insurance
• Paid time off

Physical Demands

• Sitting at a desk, typing, viewing multiple computer screens, and responding to inbound/outbound calls, emails, and messages throughout the day.
• Occasional bending, standing, or lifting up to 10 lbs.

Work Environment

The work setting is an open office with regulated temperatures, where many colleagues are on the phone for extended periods.

Position Type & Expected Hours of Work

This is a full-time role. Typically, work runs Monday through Friday, 8:00 am to 5:00 pm (with a 1-hour lunch), totaling 40+ hours weekly, with potential after-hours work aligned to business needs.

Travel

Minimal to no travel is required. Occasional attendance at work-related conferences or trainings may occur.

Professional

• Ability to adapt and work in a fast-paced environment by remaining flexible and handling change with ease.
• Demonstrate efficient time management by being punctual and reliable.
• Build and foster an environment of teamwork, integrity, and leadership.
• Communicate effectively, both in writing and verbally, in a respectful, professional manner.