Data Engineer, Data Platform & Integration

Group Summary:

The Data Engineer role at Magna International will build and orchestrate synchronous and asynchronous data pipelines integrating heterogeneous business systems for both EAI and BI use cases.

Responsibilities of the Data Engineer include:

• Builds ETL data pipelines using Talend tool portfolio and SQL code.
• Models Database objects to fulfil data pipeline requirements
• Designs following integrations:
• ETL jobs using incremental load patterns, using technologies like Change Data Capture (CDC) or Change Tracking
• Services for APIs using technologies such as REST to be consumed synchronously by client application
• Subscription based workflows triggering ETL actions based on events at source system
• Embedded mapping and casting of data from heterogenous source and target systems and formats
• Responsible for development, testing, documentation and performance of data pipelines, understanding and optimizing impact on source and target systems.
• Works closely with:
• Business analysts, system owners to gain understanding of business processes and corporate data
• Business intelligence developers to ensure that integrations are correct and performing optimally.
• Contribute to architectural decisions to support business processes
• Provide production support for data solutions
• Complete root cause analysis and contribute to remediation planning and implementation
• Perform data quality analysis, report data quality issues and propose solutions for data quality management

Skills of the Data Engineer include:

• Familiarity with various relational and non-relational database management systems, in particular Microsoft classic and cloud ecosystem
• Architectural understanding of data hub oriented integrations as single point of orchestration.
• Hands on knowledge in the design of data flows that facilitate data harvesting for automated genealogy documentation in a data catalog
• Able to work in various delivery methodologies (Agile – Scrum/SAFe, Waterfall, Kanban, etc.).
• Ability to read, interpret, analyze, and communicate effectively verbally and in written form.
• Familiarity with UML Sequence diagrams.
• Knowledge of data integration patterns across various functions of the enterprise.
• Experience with cloud-based solutions preferably on Microsoft stack.
• Azure Synapse
• Data Factory
• Data Lake
• Experience implementing and supporting scalable solutions, with a solid understanding of database locking escalation and other concurrency related mechanisms.
• Understanding of when and how to use table partitioning and other data insertion, storage and distribution approaches.

Qualifications

• Bachelor’s in Information Technology or a related field (experience will be considered in lieu of education requirement)
• 3+ years of ETL development experience with T-SQL, Talend or other graphical ETL tools (Datastage, SSIS, Informatica, Ab Initio, PowerCenter, IBM InfoSphere, Pentaho,)
• SQL development, preferably in multiple database management platforms, and working with normalized relational databases and dimensional data warehouse implementation
• Ability to manage multiple projects simultaneously and deliver results in a timely manner. Ability to work independently, under pressure, and adaptable to change.
• Manufacturing experience and SAP knowledge are a plus

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 or traditional mail to comply with GDPR requirements and your local Data Privacy Law.

AI-Assisted Screening Disclosure

As part of our commitment to a fair, consistent, and efficient recruitment process, we may use artificial intelligence (AI) tools to assist in the initial screening of applications submitted through our Workday system. These tools help identify qualifications and experience that align with the role requirements. Please note that AI is used solely to support our recruiters. Final decisions are always made by the hiring manager and the hiring team. Importantly, no applicant data is shared externally through these AI tools. All information remains securely within our systems and is handled in accordance with our privacy and data protection policies.

Under conditions defined by applicable law, you may have the right to request an explanation of how AI is used to support decision-making.

If you have any questions or concerns about this process, feel free to contact our Talent Attraction team.