Apply now »

Data Integration Analyst, Finance Systems

Job Number:  58167
Group:  Magna Corporate
Division:  Magna IT Mexico - San Pedro
Job Type:  Permanent/Regular
Location: 

San Pedro Garza Garcia, MX

Work Style: 

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.

 

Role Summary

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 it’s 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.

 

Key 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

Key Qualifications/Requirements

•    Completion of a University Degree 
•    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
•    Work experience on Finance data domain is beneficial 
•    Nice to have, working knowledge in:

  • Accounting (highly valued)
  • OneStream Software (highly valued)
  • Finance Enterprise Systems (SAP preferred)
     

Awareness. Unity. Empowerment.

At Magna, we believe that a diverse workforce is critical to our success. That’s why we are proud to be an equal opportunity employer. We hire on the basis of experience and qualifications, and in consideration of job requirements, regardless of, in particular, color, ancestry, religion, gender, origin, sexual orientation, age, citizenship, marital status, disability or gender identity. Magna takes the privacy of your personal information seriously. We discourage you from sending applications via email to comply with GDPR requirements and your local Data Privacy Law.

Apply now »