- 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
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.
