Integration Analyst Job

Arkema•Radnor, PA

About The Position

This position provides technical guidance and support for all data management and data mining functions involving data analysis across all sites in AMAS, as well as executive-level reporting. The role independently handles system configuration, development, troubleshooting issues, user access, dashboarding, and collaboration with business counterparts. It aligns with regional strategic guidance and assesses opportunities to align globally. This position supports the technical landscape for Manufacturing, Process Technology, Research & Development, and Health & Safety (EHS). The role will cover technical application development and enhancements for MES Data Historians, OSI PI, Aspen Tech, AI-Machine Learning analysis, as well as other future technology requirements.

Requirements

Proven working experience as an integration analyst or similar role.
Basic knowledge of the technical environment/tools for own area.
Independently answers user questions and resolves issues.
History as a collaborative team player, strength in communicating clearly with partners to elicit information/data requirements.
Technical expertise regarding data models, database design development, data mining and segmentation techniques.
Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc.).
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Adept at queries, report writing and presenting findings.
Follows and enforces internal IT policies and standards such as: User support process, promote to-production process, development and testing practices, security policies, documentation standards and communication practices.
Follows internal IT project management methodologies and uses selected tools.
Supports the site HES policy and complies with all regulatory and internal requirements.
Participates in HES activities provided by site management and Arkema Inc. (e.g., Behavioral Base Safety, SafeStart, etc.).
Supports and promotes the reporting of all health, safety, environmental, near-miss, accident or injury incidents.
Manages self to meet commitments and project schedules.
Builds and broadens professional knowledge.
Builds trust using effective and professional communication, customer service and team skills.
Can facilitate strong team relationships and teamwork across the organization and among a diverse workforce, including the ability to effectively interact within the team and with all levels of users in the business and staff departments.
Partners with process owners, supports continuous improvement and develops a positive customer relationship to improve processes and reliability, deliver impactful results and position Arkema for future business needs.
Effectively facilitates and/or leads meetings, presentations, requirements workshops, training sessions and project milestone communications.
Shares business, technical, and professional knowledge using interpersonal, mentoring and teambuilding skills.
Demonstrated ability to influence, gain feedback/support, and use sound judgment when making decisions and applying strong problem-solving skills.
Works independently and/or collaborates with others to design solutions and solve problems.
Uses professional and courteous interactions with all users and team members.
Innovates using strong and creative problem-solving skills for support and development activities.
Contributes to technical strategy development.
Demonstrates understanding of how own actions impact the company as a business.
Bachelor’s degree in computer/data science or related technical experience.
1-3 years of hands-on relational, dimensional, and/or analytic experience.
Some knowledge with data modeling with data strategy for data pipelines and data products.
Minimum of 1 - 3 years’ experience in various technical aspects of business systems and applications.
Experience with SQL, Python, OLAP, Shell, Git, Docker, XML, and HTML.
Experience working with Relational Database System (AWS options and MS SQL Server).
General knowledge of AWS services such as IAM, S3, Glue, Athena, Lambda, Step functions, Cloud formation, Cloud Watch, Lake Formation, Secret manager, API Gateway, SageMaker, ECS.
Experience working with tools related to Data visualization (Power BI, QuickSight).
Knowledge of API REST, Graph, SOAP, JDBC/ODBC, OData, authentication and certificates.
Experience working with the basics of network infrastructure (TCP/IP, firewalls, etc.).
Understands the basics of Windows Domain/Group security issues.
Ability to progressively build technical/business/professional knowledge.
Demonstrate strong problem-solving skills.

Nice To Haves

Travel dependent on project, enhancement or support activities; typically, less than 5%. International travel may be required.
Periodically will be responsible for enhancement or support activities outside of normal working hours.

Responsibilities

Serve as a technical advisor, partnering with internal clients to understand key data points, business functions, and informational needs.
Collaborate with the infrastructure team to define requirements for building and maintaining supporting tools for data lakes and various data strategies for business integration.
Explain technical considerations at related meetings to internal clients and less experienced team members.
Be responsible for all phases of solution development, including translating business specifications into design specifications and code.
Build requirements to identify the most suitable source for data that meets regional and global business requirements.
Assist with analysis of data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.
Build strategies to support data ingestion timing for real-time versus scheduled extracts.
Participate in gathering requirements for ETL (Extract / Transform / Load) processes, database systems designs, and tool development for real-time and offline analytic processing.
Perform initial data quality checks on extracted data.
Assist with analysis of data-related system integration challenges and propose appropriate solutions.
Ensure all code is well-structured, properly documented, easily maintainable, and reusable.
Troubleshoot software and processes for data consistency and integrity.
Integrate data from a variety of sources for business partners to generate insight and make decisions.
Create test cases to review and validate the solution design.
Conduct research and test new technologies that could enhance the data lake and its business use cases.
Recommend small to medium solutions by comparing advantages and disadvantages of custom development and purchased alternatives.
Apply automation and innovation on new and ongoing data platforms for development projects aligned to business or organizational strategies.
Implement processes aligned to data management standards, ensuring data quality and requirements are embedded in/adhered to within system development deliverables.
Support and follow Data Services Policies, Procedures & Standards.
Provide detailed specifications (Waterfall), including detailed requirements, gap analysis (for software package or SaaS solution), and test cases & campaign specifications.
Run Functional Acceptance Tests campaigns.
Write User/Administration manuals.
Design and roll-out user support, including error handling and data quality processes within pipelines and processes, support instructions for Helpdesk, and self-care forms implementation on ServiceNow.
Coordinate roll-out & change management actions.
Perform user support (Level 2 & 3) and incident management.
Deliver maintenance and support, including testing and implementing new software releases through regression testing, identifying issues and engaging with vendors to resolve and elevate software into production, and providing support for upgrades as required.
Perform application support activities, including root cause analysis, issue resolution, solution and prevention, bug fixes, routine maintenance, ongoing business modifications, testing, and documentation.
Ensure modifications properly fix issues and meet user expectations via thorough requirements gathering, system testing, user acceptance testing, and appropriate regression testing.
Perform independent research, programming specs, configuration, testing, and documentation.
Resolve issues and proactively initiate problem prevention.
Consult with others engaged in complex issue resolution.
Monitor system processes and manage maintenance assignments, including updating, enhancing, and/or streamlining technical functions of the system, data or system cleanup, standardizing processes, forms, application upgrades, and supporting OS server upgrade activities as part of a team.
Participate in application lifecycle upgrade projects.