ERP Integration Specialist BI - Dallas, United States - Dallas Area Rapid Transit

Description

General Summary:

The ERP Integration Specialist will be responsible for creating integrations between ERP systems and other enterprise applications, ensuring secure data exchanges between on-premises and cloud-based systems. They will work with various ERP systems and enterprise applications, such as EPM, HRIS, Workday, Lawson HCM, payroll, procurement, financial, EAM, and transportation applications. The Specialist will gather requirements, develop technical specifications, create architecture diagrams, and present to review boards. They will collaborate with security teams and create integrations using various technologies and protocols. The Specialist will act as a subject matter expert in analyzing legacy reporting inventory, mapping reporting needs, and validating ERP data. They will troubleshoot issues and conduct data analysis to ensure integration solutions meet performance and reliability requirements.

Essential Duties and Responsibilities:

• Design, develop, and maintain integrations between ERP systems and other enterprise applications, ensuring secure data exchanges between on-premises and cloud-based systems.
• Develop custom interfaces using middleware tools like Dell Boomi or similar tools and maintain them as required.
• Develop data exchanges using various formats and protocols, including the development of APIs, data exploration, transformation, and mapping, and develop data integration architecture for high availability and disaster recovery.
• Build integration testing and automation, use source code control for development and management of software, and manage production deployments through controlled build and release methodologies.
• Collaborate with stakeholders to understand requirements and design integration solutions that meet those requirements.
• Develop scripts and code for complex data mapping and transformations and document them accordingly.
• Ensure that integration solutions meet performance, reliability, functional, and non-functional requirements.
• Work with external vendors to build secured integration layers with third-party providers as needed.
• Analyze legacy reporting inventory, map reporting needs to ERP reporting options, and recommend approaches and mitigations to meet reporting requirements, working closely with report engineers as necessary.
• Work with cross-functional teams to cleanse, prepare, map, and validate ERP data to ensure accuracy and completeness.
• Assist in data extraction, migration, ERP system upgrades, and enhancements as required.
• Coordinate with database architects to assist with developing data dictionaries and metadata definitions.
• Prepare technical documentation, architecture diagrams, and training materials as required.
• Ensure timely delivery of integration projects and manage stakeholder expectations accordingly.
• Work with project teams, other technology teams, and stakeholders to identify integration risks and develop mitigation strategies.
• Stay up to date with the latest trends and technologies in ERP integration and recommend improvements to existing processes and systems.
• Identify opportunities to automate processes and reduce manual effort wherever possible.
• Continuously evaluate integration solutions for efficiency, reliability, and maintainability.
• Adhere to all tenets of DART Data Governance and Security.
• Actively participate in knowledge sharing and cross-training to ensure that the division has backups for all essential tasks and responsibilities.
• Provide exceptional customer service and meet Agency service level agreements (SLA).
• Perform any related other duties as assigned.

Minimum knowledge, Skills, and Abilities Required:

Note: An equivalent combination of related education and experience may be substituted for the below stated minimums excluding High School Diploma, GED, Licenses, or Certifications.

• Bachelor's degree from an accredited college or university in Computer Science, Management Information Systems, or related field.
• Seven (7) years' experience in data integration technologies, specifically in Dell Boomi, and experience working on data integrations between enterprise applications on both on-premises and cloud environments.
• Proficiency in various data exchange formats and protocols, API development, data exploration, transformation, and mapping, and developing data integration architecture for high availability and disaster recovery.
• Knowledge of integration testing and automation, source code control, and managing production deployments.
• Knowledge of SQL code origination and management tools.
• Proficiency of PC software applications to include Microsoft Office or other related software applications.
• Work variable hours, to include emergency response to outages.
• Perform work from remote locations as needed.
• Ability to work in an on-call rotation.
• Pass a physical (medical) examination that includes a drug screen to operate DART non-revenue vehicles.
• Ability to be dedicated to meeting the expectations and requirements of internal and external customers. Gets first-hand customer information and uses it for improvements in products and services. Acts with customers in mind. Establishes and maintains effective relationships with customers and gains their trust and respect.
• Ability to use rigorous logic and methods to solve difficult problems with effective solutions. Can see hidden problems. Is excellent at honest analysis. Looks beyond the obvious and does not stop at the first answers.
• Ability to be able to write clearly and succinctly in a variety of communication settings and styles. Can get messages across that have the desired effect.
• Ability to use his/her time effectively and efficiently. Values time. Concentrates his/her efforts on the more important priorities. Gets more done in less time than others. Can attend to a broader range of activities.
• Ability to learn quickly when facing new problems. A relentless and versatile learner. Open to change. Analyzes both successes and failures for clues to improvement. Experiments and will try anything to find solutions. Enjoys the challenge of unfamiliar tasks. Quickly grasps the essence and the underlying structure of anything.
• Ability to quickly find common ground and solve problems for the good of all. Can represent his/her own interests and yet be fair to other groups. Can solve problems with peers with a minimum of noise. Is seen as a team player and is cooperative. Easily gains trust and support of peers. Encourages collaboration. Can be candid with peers.
• Ability to be good at bringing the creative ideas of others to market. Has good judgment about which creative ideas and suggestions will work. Has a sense about managing the creative process of others. Can facilitate effective brainstorming. Can project how potential ideas may play out in the marketplace.
• Ability to make good decisions (without considering how much time it takes) based upon a mixture of analysis, wisdom, experience, and judgment). Most of his/her solutions and suggestions turn out to be correct and accurate when judged over time. Sought out by others for advice and solutions.
• Analytical and creative skills to find solutions to complex interpersonal, technical, and administrative problems.
• Knowledge of budget development/analysis, and operational cost factors.

Working Conditions:

Works in an environment where there is minimum exposure to dust, noise, or temperature. May be moderately exposed to unpleasant working conditions to include dust, noise, temperature, weather, petroleum products, and chemicals while visiting DART's operating facilities, assuming incumbent is observing all policies and procedures, safety precautions and regulations, and using all protective clothing and devices provided.

Note: The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. The statements are not intended to be an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All employees may perform other duties as assigned.

DART is proud to be an Equal Employment Opportunity Employer, supporting diversity in the workplace. M/F/D/V

Pay Grade:

Commensurate with education and experience.

JR101160