职位描述

Job Introduction

We are looking for a skilled data integration and management professional to join our team as a Finance Data Integration Specialist. In this role you will implement integrations to Magna’s ERP and business systems to provide the relevant data to support key financial processes (Consolidation, Month-End Close, Budgeting & Forecasting). You will maintain and continuously improve data pipelines delivering to Magna’s Finance Data Hub, including its major downstream integration to our core financial system OneStream. You will work closely with business analysts, system owners, and business intelligence developers to ensure that integrations are correct and performing optimally. As part of regular integration support the Data Integration Specialist will perform root cause analysis, data quality analysis, and pro**e solutions for data quality management.

Major Responsibilities
• Implementing data flows to deliver data Magna’s major finance systems.
• apply various integration patterns such as CDC, ETL, Event Driven, batch, etc., to maximize reusability and minimize maintenance of the data pipeline.
• Setup & maintain the data ingestion into OneStream specific integrations incl. the management of related gateway infrastructure.
• Maintain and continuously improve up & downstream integrations to the Finance Data Hub
• Monitor data processing between the various stages within the Finance Data Hub.
• Perform data quality analysis, report data quality issues and pro**e solutions for data quality management.
• Work closely with business analysts, system owners and functional SMEs to gain understanding of business processes and data elements to contribute to architectural decisions and provide efficient support.
• Work with Data engineers and BI developers as part of a delivery team for Finance Data Solutions

Knowledge and Education
Completion of University Degree

Work Experience
3 to 5 Years of Work Related Experience

Skills and Competencies Required to Perform the Job
• Minimum 3 years experience in the development of integrations leveraging
T-SQL (or PL/SQL)
Low-code tools (Talend Studio, Talend CDC, SQL server replication)
Cloud native (Azure Data factory and Databricks preferred)
Streaming based (Kafka, Data Explorer or equivalent)
• Experience in data modeling methodologies such as temporal and dimensional modeling in classic DWH star or snowflake schemas
• Familiarity with UML diagrams for design and requirements specifications
• Ability to read, interpret, analyze, and communicate effectively verbally and in written form in English.
• Nice to have, working knowledge in:
Accounting (highly valued)
OneStream Software (highly valued)
Finance Enterprise Systems (SAP preferred)



Travel
No Travel

Any Additional Information
• Excellent English in spoken and written.
• Work Experience on Finance data domain is beneficial.