System Engineer DataWarehouse_Compliance

Job description

Job descriptions may display in multiple languages based on your language selection. 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: Magna IT is looking for a System Engineer with a strong focus on building and operating a centralized Intune Data Warehouse and establishing reliable device compliance monitoring. The role is responsible for integrating multiple data sources (e.g., Microsoft Intune, Entra ID, Matrix42 ITSM database, Nexthink) into a central database, enabling customized queries and Power BI dashboards for operational and management reporting. In close collaboration with MIT colleagues and Divisional IT, the position ensures device compliance is continuously tracked, validated, and restored where required. Major Responsibilities Design, build, and operate a centralized data platform for Modern Workplace reporting (Intune Data Warehouse as core, plus additional sources as required) Integrate and harmonize data from Microsoft Intune, Entra ID, Matrix42 ITSM DB, Nexthink and other relevant systems into a central database (ETL/ELT) Develop and maintain data pipelines using Azure Data Factory (or comparable tooling) including scheduling, error handling, and operational monitoring Create and optimize SQL-based data models, views and custom queries to support operational reporting and analytics Automate data extraction and operational tasks using Microsoft Graph API, Entra ID concepts, and scripting (PowerShell / Python) Build and maintain Power BI datasets and dashboards (including KPI definitions, refresh, and access management) for different stakeholder groups Own and continuously improve device compliance monitoring (e.g., free disk space, BitLocker status, anti-virus, M365 Apps versions, patch/health indicators) across all Intune managed devices (Android, iOS, Windows, MacOS) Coordinate and drive remediation with MIT and Divisional IT to restore compliance (runbooks, escalation paths, follow-up, and reporting) Ensure data quality, consistency and compliance (data definitions, validation checks, documentation, and auditability of metrics) Provide 2nd/3rd level support for reporting, automation and compliance monitoring topics; consult internal teams on usage of dashboards and insights Participation in on-call rotation for the reporting/compliance monitoring service (as required) Knowledge and Education Preferably Bachelor's degree in Computer Science, Computer Engineering, Information Technology or a relevant field. Completed education of a technical college. Work Experience and Skills 2–3 years of experience in endpoint management analytics / reporting (Intune strongly preferred), including data extraction and operational reporting Strong SQL skills (querying, performance tuning basics, data modeling; building views/stored procedures is a plus) Experience with Microsoft Graph API and Entra ID (identity and device objects, permissions, app registrations, authentication concepts) Hands-on experience with Azure Data Factory (or equivalent) and building reliable ETL/ELT pipelines across multiple sources Power BI skills (data modeling, DAX basics, dashboard design, row-level security concepts) Strong scripting/automation skills in PowerShell and/or Python (APIs, scheduling, logging, error handling) Understanding of endpoint compliance concepts and telemetry (e.g., Intune compliance, BitLocker, AV/Defender signals, application versioning, device health indicators; Nexthink is a plus) Other Competencies Positive attitude and a strong commitment to delivering quality work. Knowledge of client lifecycle management systems and current computing trends. Effective English communication skills (written and verbal) to properly articulate complicated technical matters to management, IT partners and the end users Can work independently or part of a team. Conform with and abide by all Company codes, regulations, policies, values, work procedures and instructions. Must be an independent problem solver with troubleshooting, decision-making and analytical skills. Excellent customer service skills. 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. Worker Type: Regular / Permanent Group: Magna Corporate