BI Analyst

Summary

Join Mercedes-Benz.io's OneDNA team as a Data Modeler, leading the design, development, and optimization of data models for business intelligence and analytics. You will establish and maintain a robust data architecture, ensuring data integrity and efficient data flow. Responsibilities include gathering data requirements, organizing data into scalable models, transforming business logic into data models, and ensuring compliance with data governance. Collaboration with stakeholders and development of data visualizations are key aspects of this role. The position offers a flexible work environment with options for office or remote work in Portugal, along with various benefits.

Requirements

• 5+ years of experience in business intelligence, data modeling, or database development
• Experience working in cloud-based data environments (AWS, Azure, GCP)
• Familiarity with big data technologies (e.g., Databricks)
• Data Modeling & Management: Advanced expertise in conceptual, logical, and physical data modeling
• SQL & Database Optimization: Proficient in writing complex SQL queries, optimizing database performance, and ensuring efficient ETL processes
• Programming & Scripting: Strong experience in Python for data manipulation and automation
• BI & Visualization: Experience with Power BI, or similar tools
• Version Control: Proficiency in GIT for tracking changes and collaboration
• Data Governance & Quality Assurance: Ensuring data accuracy, consistency, and security
• Analytical Thinking: Ability to break down complex problems and analyze data methodically
• Detail-Oriented: Commitment to accuracy and high-quality data outputs
• Requirements Analysis: Strong ability to translate business needs into data-driven solutions
• Collaboration & Communication: Comfortable working cross-functionally with technical and non-technical stakeholders

Responsibilities

• Lead the design, development, and optimization of data models to support business intelligence and analytics
• Establish and maintain a robust data architecture, ensuring efficient data flow between systems
• Ensure data integrity, consistency, and reliability by implementing best practices in database design
• Optimize database performance through indexing, table relationships, and structured queries
• Gather and analyze data requirements, raw data, and data flows from multiple sources
• Organize structured and unstructured data into scalable models that support business needs
• Transform business logic into logical and physical data models
• Ensure compliance with data governance and best practices
• Collaborate with stakeholders to understand business requirements and translate them into actionable insights
• Develop data visualizations, dashboards, and reports that drive strategic decisions
• Support teams in leveraging BI tools for self-service analytics
• Work closely with data engineers, analysts, and business users to enhance the BI ecosystem
• Advocate for data-driven decision-making across the organization
• Stay updated with industry trends and best practices in BI, analytics, and data modeling

Preferred Qualifications

• Open source software
• No top-down hierarchy. We trust in your self-organization
• Colleagues that are as smart, hardworking and driven as you
• An amazing open-minded and informal culture with the backup of a giant company like Mercedes-Benz
• IPhone, MacBook Pro or Dell (your choice) and noise-cancelling headphones

Benefits

• Health insurance for you and your family
• Life insurance
• Proactive self-development in international Trainings and Conferences
• Language Training courses
• Wellbeing actions (massages, nutrition sessions, happy hour and more)
• Brand Connection Perks
• Much more cool stuff …