Senior BI Developer

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:
The Senior Power BI Developer will be responsible for interpreting the business needs and transforming them into powerful Power BI report or other data insights related products / apps. This includes the design, development, maintenance, integration and reporting of business systems through cubes, ad-hoc reports, and dashboards in relation with trending technologies such as Microsoft Fabric or Databricks. The selected candidate will work closely with international team members from Europe, North America and Asia.
Major Responsibilities

• Collaborate with business analysts and stakeholders to understand data visualization requirements and translate them into effective BI solutions. Design and develop visually appealing and user-friendly reports, dashboards, and interactive data visualizations to present complex insights in a comprehensible manner.
• Leverage proficiency in DAX to create calculated measures, columns, and tables that enhance data analysis capabilities within Power BI models.
• Develop and optimize ETL processes using Power Query, SQL, Databricks, and MS Fabric to transform and integrate data from diverse sources, ensuring accuracy and consistency. Leverage Databricks' or MS Fabric's capabilities, including Apache Spark, Delta Lake, and AutoML/AzureML to enhance data processing and analytics.
• Implement best practices for data modeling, performance optimization, and data governance within Power BI projects.
• Work closely with database administrators and data engineers to ensure seamless data flow from source systems to Power BI and maintain data integrity.
• Identify and address performance bottlenecks in Power BI reports and dashboards.
• Optimize queries and data models for improved speed and efficiency.
• Implement security measures to ensure the confidentiality and integrity of data in Power BI.
• Ensure compliance with data governance and privacy policies.
• Create and maintain the documentation on all owned Power BI reports.
• Stay up to date with Power BI advancements and industry trends, constantly seek for better, more optimized solutions and technologies and implement newly gained knowledge to Magna's PBI processes.
• Provide training sessions and technical support to end users to foster self-service analytics and maximize Power BI utilization.
• Provide the support to junior team members.
• Collaborate with cross-functional teams to identify opportunities for data-driven insights and contribute to strategic decision-making processes.

Knowledge and Education

• Completion of University Degree.

Work Experience

• More than 3 Years of Work-Related Experience.

Skills and Competencies Required to Perform the Job

• More than 3 years experience in the development of Business Intelligence solutions based on Microsoft Tabular models including Power BI visualization and complex DAX expressions.
• Experience in designing and implementing data models both on Tabular, SQL or Delta Lake based storage solutions.
• Solid understanding of ETL processes, Data Warehouse and Lakehouse concepts.
• Strong SQL coding skills.
• Advanced skills in Microsoft BI stack (including Analysis Services, Paginated Reports and Power Pivot, Azure SQL).
• Experience with Synapse, Data Flow, AutoML/AzureML, Tabular Editor or Dax Studio is a plus.
• Knowledge of programming languages (Python, C# or similar is a big plus).
• Self-motivated and self-managed with a high degree of analytical skills (quick comprehension, abstract thinking, recognize relationships).
• Ability to be a strong team member, and communicate effectively
• Ability to prioritize and multi-task, and reasonably estimate work effort for tasks.
• Excellent English language skills (written and verbal).

Working Conditions and Environment

• Work in second or third shift (starting at 4:30 PM or later India time).

Travel

• 10-25% regular travel.

Any Additional Information

• Excellent English in spoken and written is a must. Ability to clarify the complex issues to the non-technical audience is mandatory.

Work Environment
Regular travel: 10-20% of the time.
For dedicated and motivated employees, we offer an interesting and diversified job within a dynamic global team together with the individual and functional development in a professional environment of a global acting business. Fair treatment and a sense of responsibility towards employees are the principle of the Magna culture. We strive to offer an inspiring and motivating work environment.
Additional Information
We offer attractive benefits (e.g. discretionary performance bonus) and a salary which is in line with market conditions depending on your skills and experience.
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