System Engineer DataWarehouse_Compliance

Magna-International-6df39721; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Magna IT is seeking a System Engineer to build and operate a centralized data warehouse focused on Intune data and device compliance monitoring. You will integrate data from multiple sources, develop ETL/ELT pipelines, and create Power BI dashboards for operational reporting.

Responsibilities include maintaining data quality, scheduling pipelines with Azure Data Factory, and enabling stakeholders with self-service analytics.

Qualifications

• 2–3 years of experience in endpoint management analytics / reporting (Intune strongly preferred)
• Strong SQL skills (querying, performance tuning basics, data modeling)
• Hands-on experience with Power BI datasets and dashboards; scripting in PowerShell or Python

Responsibilities

• Design, build, and operate a centralized data platform for Modern Workplace reporting with Intune Data Warehouse at core
• Integrate data from Intune, Entra ID, Matrix42 ITSM DB, Nexthink into a central database (ETL/ELT)
• Develop and maintain data pipelines using Azure Data Factory incl. scheduling and monitoring
• Create SQL-based data models, views and custom queries to support reporting and analytics
• Build and maintain Power BI datasets and dashboards for KPI definitions and access management
• Ensure device compliance monitoring across Intune managed devices (Windows, Android, iOS, MacOS) and coordinate remediation
• Provide 2nd/3rd level support for reporting, automation and compliance topics

Skills

SQL

Power BI

PowerShell

Python

Azure Data Factory

Intune

Microsoft Graph API

Entra ID

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

Power BI

Microsoft Graph API

Entra ID

Nexthink

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 ResponsibilitiesDesign, 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 monitoringCreate and optimize SQL-based data models, views and custom queries to support operational reporting and analyticsAutomate 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 groupsOwn 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 insightsParticipation in on-call rotation for the reporting/compliance monitoring service (as required)Knowledge and EducationPreferably Bachelor's degree in Computer Science, Computer Engineering, Information Technology or a relevant field.Completed education of a technical college.Work Experience and Skills2–3 years of experience in endpoint management analytics / reporting (Intune strongly preferred), including data extraction and operational reportingStrong 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 sourcesPower 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 CompetenciesPositive 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 usersCan 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 DisclosureAs 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 / PermanentGroup:Magna Corporate