Data Integration Specialist, Finance Systems

Group Description

At Magna, we create technology that disrupts the industry and solves big problems for consumers, our customers, and the world around us. We’re the only mobility technology company and supplier with complete expertise across the entire vehicle.

We are committed to quality and continuous improvement because our products impact millions of people every day. But we’re more than what we make. We are a group of entrepreneurial-minded people whose collective expertise gives us a competitive advantage. World Class Manufacturing is a journey and it’s our talented people who lead us on this journey.

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 propose 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 propose 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.