Data Analyst- Automation & Integration (Power Platform)
Amphenol TCS
Hudson, NH 03051, USA
6/14/2022
Technology
Full Time
Job Description
Job Description
We are currently seeking a Data Analyst Automation & Integration to join our team.
The Data Analyst Automation & Integration will eliminate manual work by building production-grade Power Apps and Power Automate workflows that connect people, data, and systems. This role will design and maintain apps/flows for NPI, ECN, RMA/8D/CAPA, approvals, and planning processes; implement secure integrations with ERP/PLM/CRM; and ensure workflow reliability, documentation, and adoption. The ideal candidate combines low-code development expertise with practical integration skills and a continuous-improvement mindset.
RESPONSIBILITIES:
- Collaborate with business stakeholders to define application and workflow requirements; rapidly prototype and harden Power Apps and Power Automate solutions for high-value processes.
- Implement and manage connectors and APIs (ERP/PLM/CRM/SharePoint/Dataverse); align with BU and Group IT on security, environments, and ALM.
- Build and maintain robust data pipelines/transformations (Power Query/SQL; PowerShell/Python where appropriate) to ensure clean, governed data for analytics.
- Monitor and optimize workflow performance, error handling, and run history; maintain documentation and release notes.
- Create reusable templates and components to accelerate future automations; train super-users and support citizen-developer guardrails.
- Partner with data analyst peers to align data capture with KPI and reporting needs.
- Any other activities required by the business to support its data, processes and growth.
QUALIFICATIONS:
- BS in Engineering, Information Systems, Computer Science, or related field.
- 36+ years building production Power Apps and Power Automate solutions; experience integrating enterprise systems via connectors/REST APIs/webhooks.
- Working knowledge of SQL and Microsoft data services (Dataverse, SharePoint, Azure SQL); understanding of Power Platform environment strategy, permissions, and governance.
- Nice to have: Azure Functions/Logic Apps, Git-based ALM, basic scripting (PowerShell/Python).
- Knowledge of traditional engineering and manufacturing operations processes and KPIs.
- Travel required as needed to support global sites.
