Senior BI Developer

• Responsible for interpreting business needs and transforming them into powerful Power BI reports or other data insights related products/apps.
• Involves the design, development, maintenance, integration, and reporting of business systems.
• Utilizes cubes, ad-hoc reports, and dashboards.
• Works with trending technologies such as Microsoft Fabric or Databricks.
• Will collaborate closely with international team members from Europe, North America, and Asia.
• 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.