Power Query Jobs in Dallas, TX (NOW HIRING)

ABOUT ROCHESTER SENSORS

Rochester Sensors, an Amphenol Company, develops sensors in many different industries including industrial, heavy vehicles, power generation and storage. Rochester is increasing its range of sensors, know-how, and in-house technologies to create engineered solutions for its customers. We are a multi-national company headquartered in Dallas, Texas, with manufacturing facilities in Coppell, Texas USA; Mexico City, Mexico; Brussels, Belgium; Warwick, United Kingdom, Shannon, Ireland and Shanghai, China.

Rochester builds Quality, Accuracy, and Reliability into all of our products. New designs and technologies are being introduced to further enhance your satisfaction with our products.

All of our products are constructed of quality materials to ensure durability and longevity. Rochester products are sold to original equipment manufacturers (OEMs) & distributors in the following markets:

Agricultural • Aircraft • Automotive • Refrigeration • Industrial • LP Gas Marine • Heavy Truck • Off-Road • Construction • Locomotive Petrochemicals • Process Equipment

D365 Support Specialist

THIS IS NOT A REMOTE POSITION. MUST BE LOCATED IN THE DFW AREA

OVERVIEW

The ERP & EDI Support Analyst is responsible for supporting and maintaining Electronic Data Interchange (EDI) integrations and Microsoft Dynamics 365 (D365) applications. This role serves as a liaison between business users, trading partners, and technical teams to ensure reliable data exchange, system stability, and effective issue resolution..

RESPONSIBILITIES

EDI Support & Administration (60%)

Integration Support

• Monitor EDI transactions and integration processes daily.
• Investigate, troubleshoot, and resolve EDI data and transmission issues.
• Support onboarding and testing of new trading partners and EDI mappings.
• Validate inbound and outbound EDI transactions to ensure data accuracy.
• Monitor FTP/SFTP connections and file transmissions.
• Perform EDI data reconciliation and exception analysis.
• Assist business teams with EDI-related questions and support requests.
• Maintain EDI configurations, documentation, process flows, and support procedures.
• Coordinate with third-party EDI providers, customers, vendors, and technical teams.
• Serve as the liaison between business stakeholders and technical partners.

Required EDI Knowledge

• Understanding of XML, JSON, and flat-file data formats.
• Basic understanding of client-server architecture.
• Working knowledge of EDI standards (X12, EDIFACT, ASN, 850, 810, 856, etc.).
• Experience with Power Query.
• Experience with one or more EDI platforms such as:
  • Cleo
  • SPS Commerce
  • Boomi
• Experience with Power Apps is a plus.

Microsoft Dynamics 365 Support (40%)

ERP Support

• Provide Tier 1 support for Dynamics 365 users.
• Troubleshoot and identify ERP system issues and escalate to Tier 2 support when necessary.
• Participate in system maintenance, upgrades, regression testing, and user acceptance testing (UAT).
• Maintain ERP documentation, procedures, and knowledge base articles.
• Support ERP change management processes and release activities.
• Troubleshoot ERP-related printing and reporting issues.
• Participate in ERP enhancement projects and process improvement initiatives.
• Assist Power BI analysts with data extraction, validation, and reporting requests.
• Support users with training and system adoption efforts.

REQUIRED EXPERIENCE

• Minimum 1 year of experience supporting Microsoft Dynamics 365 Finance and/or Supply Chain Management.
• Minimum 1 year of EDI support, administration, or integration experience.
• Experience supporting applications in a managed IT environment.
• Knowledge of Microsoft Power Platform.
• Experience with:
  • Dataverse
  • Dataflows
  • Power Automate
• Familiarity with REST APIs, web services, and integration protocols.
• Advanced Microsoft Excel skills including:
  • Pivot Tables
  • XLOOKUP/VLOOKUP
  • Power Query
  • Data Analysis

PREFERRED QUALIFICATIONS

• Experience with Cleo, SPS Commerce, Boomi, or similar integration platforms.
• Experience supporting manufacturing, distribution, wholesale, or supply chain operations.
• Exposure to SQL queries and database concepts.
• Experience with Azure integrations and APIs.
• Familiarity with Power BI reporting and dashboard development.
• Understanding of EDI transaction sets:
  • 810 Invoice
  • 850 Purchase Order
  • 855 PO Acknowledgement
  • 856 ASN
  • 997 Functional Acknowledgement

TRAVEL REQUIREMENTS
Up to 10% travel may be required
PHYSICAL REQUIREMENTS
While performing the duties of this job, employees may be required to walk for prolonged periods of time, frequently bending, climbing, rotating, squatting, reaching, kneeling, or stooping, lifting up to 25 pounds, and periods of computer use.

Employee may be frequently exposed to heat/cold, heights, gases, vibration, dust, chemicals, odors, dampness, fumes, and noises.
REASONABLE ACCOMODATIONS

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the position.

WHAT’S NICE ABOUT WORKING FOR ROCHESTER

• Comprehensive Health Insurance
• Paid Time Off and Holidays
• Life, AD&D, short/long term disability insurance
• Casual workplace with an unbelievable feeling of energy
• 401K Retirement program with company match
  

Rochester Sensors is an equal opportunity-affirmative action employer and considers all qualified applicants for employment based on business needs, job requirements and individual qualifications, without regard to race, color, religion, sex, age, disability, sexual orientation, gender identity or expression, marital status, past or present military service or any other status protected by the laws or regulations in the locations where we operate.

Any unsolicited resumes or candidate profiles submitted in response to our job posting shall be considered the property of Rochester Sensors. and its subsidiaries and are not subject to payment of referral or placement fees if any such candidate is later hired by Rochester Sensors unless you have a signed written agreement in place with us which covers the applicable job posting.
If you are a person with a disability needing assistance with the application process, please call (972) 845-4196 or email us at lonnie.golden@rochestersensors.com.
Equal Employment Opportunity Posters | U.S. Department of Labor (dol.gov)