Senior Associate, Data Integration & Business Solutions Engineer

Position Overview:

Geller is seeking a highly motivated Senior Associate within the Data Integration & Business Solutions Engineer to join our Enterprise Applications team. This is a hands-on technical role focused on designing, developing, supporting, and enhancing enterprise applications, integrations, reporting solutions, and business process automation initiatives using traditional and the latest AI driven technologies.

The ideal candidate will work closely with application leadership and business stakeholders to deliver scalable technology solutions, modernize data for AI consumption and reporting platforms, automate business processes, and support enterprise applications. This role requires a strong mix of development, data engineering, business intelligence, and application support experience.

Key Responsibilities;

Data Integration & Automation

• Design, develop, and support enterprise integration solutions utilizing system-to-system integrations, event-driven architectures, message queues, webhooks, batch processing, and real-time data integrations to ensure reliable, scalable, and efficient business process automation and data exchange across applications and platforms.

• Develop and support ETL/ELT processes using Informatica Cloud and related integration technologies.

• Build and maintain automated business processes using Microsoft Power Platform and other technologies

• Develop API-based integrations and system-to-system connectivity solutions.

Microsoft Fabric & Business Intelligence

• Design and develop Microsoft Fabric solutions, including data pipelines, dataflows, Lakehouse’s, semantic models, and reporting datasets.

• Create and maintain Power BI dashboards, executive scorecards, and operational reports.

• Support data warehouse modernization and reporting transformation initiatives for AI consumption.

• Ensure data quality, governance, and performance across analytics platforms.

Application Development & Support

• Develop, enhance, and support enterprise business applications.

• Participate in requirements gathering, solution design, testing, deployment, and production support.

• Perform root cause analysis and issue resolution for business-critical applications.

• Develop technical documentation, support procedures, and knowledge transfer materials.

• Ensure adherence to development standards, security requirements, and best practices.

AI & Business Innovation

• Support implementation of Microsoft Copilot, Copilot Studio, ChatGPT, Claude, Gemini and other widely used LLMs and AI-powered business solutions.

• Identify opportunities to improve productivity through automation and AI technologies.

• Participate in governance and operational readiness activities for emerging technologies.

Technical Leadership

• Provide technical guidance across projects and initiatives.

• Partner with business users to translate requirements into scalable technical solutions.

• Mentor junior developers and consultants.

• Promote Agile, DevOps, and continuous improvement practices.

Required Qualifications

• THIS IS AN IN OFFICE HYBRID ROLE 3 DAYS IN 2 DAYS REMOTE.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.

• 7+ years of experience in software development, integration, business intelligence, or enterprise application support.

• Strong experience developing and supporting data integrations and automation solutions.

• Experience working directly with business stakeholders and cross-functional teams.

• Excellent analytical, troubleshooting, and problem-solving skills.

• Strong written and verbal communication skills.