Data Integration Specialist, Finance Systems

What we offer:
At Magna, you can expect an engaging and dynamic environment where you can help to develop industry-leading automotive technologies. We invest in our employees, providing them with the support and resources they need to succeed. As a member of our global team, you can expect exciting, varied responsibilities as well as a wide range of development prospects. Because we believe that your career path should be as unique as you are.
Group Summary:
Magna is more than one of the world's largest suppliers in the automotive space. We are a mobility technology company built to innovate, with a global, entrepreneurial-minded team. With 65+ years of expertise, our ecosystem of interconnected products combined with our complete vehicle expertise uniquely positions us to advance mobility in an expanded transportation landscape.
Job Responsibilities:
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.

Requirements:

• Bachelor's degree in information technology or computer science
• 3 to 5 Years of Work Related Experience
• 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)
Power BI

• Experience in data modeling methodologies such as temporal and dimensional modeling in classic DWH star or snowflake schemas
• Ability to read, interpret, analyze, and communicate effectively verbally and in written form in English

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.
Worker Type:
Regular / Permanent
Group:
Magna Corporate