Data Integration & Process Optimization Specialist

Aras Corporation•Andover, MA

52d•Hybrid

About The Position

Aras is a leader in product lifecycle management (PLM) and digital thread solutions. As one of the fastest growing PLM companies, our technology enables the rapid delivery of flexible solutions built on a powerful digital thread backbone and a low-code development platform. Our platform and PLM applications connect users in all disciplines to critical product data and processes across the lifecycle and throughout the extended supply chain. The world's largest manufacturers are leveraging Aras Innovator to manage their complex product lifecycles to improve production timelines, meet and exceed revenue growth targets, and accelerate innovation. We collaborate with companies in some of the most innovative industries, including automotive, industrial/heavy equipment, aerospace and defense, and high-tech electronics. As a Data Integration & Process Optimization Specialist you will be responsible for developing, maintaining, and optimizing data pipelines and architectures that support data processing and analysis. This role involves working with large datasets, ensuring data quality, and collaborating with various teams to meet business needs.

Requirements

Minimum of 2 years of data optimization in an enterprise environment.
Proficiency in PowerBI and Fabric.
Strong analytical and problem-solving skills.
Highly driven and eager to contribute in a collaborative team environment.
Excellent communication (oral and written), interpersonal, organizational, and presentation skills.
Ability to work independently and as part of a team.
Adequate hearing and verbal abilities to communicate effectively in person and by telephone.
Familiarity with data warehousing and ETL processes.
Experience in PowerBI.
Proficiency in SQL and query optimization.
Experience in Azure PowerShell.
Strong commitment to providing exceptional support to internal and external stakeholders.
High level of accuracy and attention to detail in all tasks.
Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Applicants should also be able to commute to our Andover, MA office twice a week (Wednesdays and Thursdays). Please note that Aras is currently unable to offer relocation assistance.

Responsibilities

Design, build, and maintain scalable data pipelines for data extraction, transformation, and loading (ETL).
Integrate data from various sources, ensuring consistency and reliability utilizing Azure Fabric.
Optimize data systems for performance and scalability.
Implement measures to ensure data accuracy, integrity, and security.
Maintain comprehensive documentation of data processes, architectures, data dictionaries, metadata, and workflows.
Identify and resolve data-related issues.
Develop and maintain dashboards and reports using PowerBI.
Collaborate with cross-functional teams to understand data needs and deliver solutions.
Identify trends, patterns, and anomalies in data to support business strategies.
Present findings and recommendations to stakeholders in a clear and concise manner.
Data-Driven Troubleshooting - use advanced analytical techniques to interpret raw data and uncover the underlying causes of operational or technical problems.
Leverage a variety of systems, applications, and technologies to streamline and automate processes, such as Workato and Power Automate.

Benefits

Flexible paid time off to recharge when you need it, plus company-paid holidays and a dedicated Global Wellness Day.
A 401(k) plan with company match to help you invest in your future.
Robust health coverage, including generous medical, dental, and vision insurance with high premium contributions and deductible reimbursement.
Company-paid life insurance, as well as short- and long-term disability coverage for added peace of mind.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume