Application Support Engineer

Application Support Engineer

We are looking for an experienced Application Support Engineer to join our team in Paoli, Pennsylvania. This role offers an exciting opportunity to work with cutting-edge tools and technologies to design and maintain robust data pipelines, databases, and reporting platforms. The ideal candidate will be passionate about optimizing performance, ensuring data quality, and collaborating with cross-functional teams to deliver impactful business solutions.

Responsibilities

• Develop and manage efficient data pipelines using tools such as Azure Data Factory or similar technologies.
• Oversee the lifecycle management of both on-premises and cloud-based databases, including SQL Server and Oracle.
• Monitor and enhance database performance by tuning queries, optimizing indexing, and managing storage effectively.
• Create and share insightful dashboards, datasets, and data models using Power BI.
• Maintain and improve enterprise data warehouse structures to support reporting platforms.
• Establish frameworks for data governance, validation processes, and maintaining high data quality standards.
• Collaborate with application teams to identify data requirements and ensure seamless integration across enterprise systems.
• Automate repetitive tasks by leveraging scripting languages such as PowerShell or Python.

Requirements

• Proficiency in designing and developing data pipelines using Azure Data Factory or equivalent tools.
• Extensive experience managing on-premises and cloud-based databases, including SQL Server and Oracle.
• Strong skills in database performance tuning and optimization techniques.
• Hands-on experience with Power BI for creating dashboards and managing data models.
• Knowledge of data governance principles and frameworks for ensuring data integrity.
• Ability to collaborate effectively with application teams and stakeholders to meet data integration needs.
• Expertise in scripting languages such as PowerShell or Python for task automation.
• Familiarity with Advanced Business Application Programming (ABAP) is a plus.