We are seeking a motivated and experienced Data Engineer with 2-4 years of hands-on experience to join our team. The ideal candidate will have expertise in Azure Data Factory (ADF), SQL, Logic Apps, and a solid understanding of IT/OT systems. Knowledge of KQL and Overall Equipment Effectiveness (OEE) concepts will be a strong plus. This role involves working with large datasets, building data pipelines, and contributing to the integration of IT and OT environments to enhance operational efficiency.
Key Responsibilities:
- Design, build, and maintain scalable ETL pipelines using Azure Data Factory (ADF).
- Develop and optimize SQL queries, stored procedures, and data models to support data integration and analytics requirements.
- Implement and maintain workflows using Logic Apps for process automation and data orchestration.
- Collaborate with IT and OT teams to ensure seamless integration of data across industrial and enterprise systems.
- Support OEE calculation frameworks by integrating machine and production data.
- Analyze and process large datasets to enable actionable insights for business and operational decision-making.
- Ensure data quality, reliability, and consistency in all projects.
- Troubleshoot and resolve issues related to data pipelines and integrations.
- Work closely with stakeholders to gather requirements and translate them into technical solutions.
Key Skills and Qualifications:
• Experience: 2-4 years of experience in data engineering or related roles.
• Technical Expertise:
o Proficient in Azure Data Factory (ADF) and building data pipelines.
o Strong SQL skills for querying, performance optimization, and database management.
o Experience with Logic Apps for workflow automation.
• Knowledge Areas:
o Understanding of IT and OT systems and their integration.
o Familiarity with Overall Equipment Effectiveness (OEE) concepts and calculation methods.
o Knowledge of KQL (Kusto Query Language) is a plus.
• General Skills:
o Strong problem-solving and analytical skills.
o Ability to work independently and collaboratively in a team environment.
o Effective communication skills to interact with technical and non-technical stakeholders.
Top Skills
What We Do
Avanceon is the leading provider of automation, control systems integration, proprietary energy management solutions and support services. It has a strong market footprint through its offices in Dubai - UAE (covering Middle East), Lahore - Pakistan (covering South Asia) and Exton, Pennsylvania - United States of America (covering North America). Avanceon is also among the select group of ‘certified members’ of Control System Integrators Association (‘CSIA’) and is also listed on the Control Engineering Magazine’s System Integrator Hall of Fame.Avanceon has been in the automation business for the last 24 years and has transformed into a 360 degree solution provider for automation, energy management, service and maintenance. Servicing clients over a span of two decades, Avanceon has completed several projects for major blue chip companies enabling it to earn strong credentials, move up the learning curve and develop a diverse client base. Going forward, it intends to capitalize on its core strengths to expand its footprint in the Middle East by setting up offices in Qatar, Kingdom of Saudi Arabia (KSA) and Oman.
