Mphasis is seeking a highly analytical and detail-oriented Data Analyst in Barcelona, Spain to support and enhance an Excel-based tool by integrating it with Databricks, improving data views, and making it scalable for broader business use. This role requires a strong foundation in data analysis, reporting, and process automation, with an emphasis on optimizing workflows and delivering actionable insights through reports and summaries.
About the Role:
Maintain and enhance an Excel-based tool, ensuring seamless integration with Databricks to automate data updates and improve efficiency.
Improve data views and dashboards, making them more intuitive, insightful, and scalable for various stakeholders.
Work on scalability solutions to expand the tool's functionality and adaptability across teams.
Develop and automate reports and summaries, translating complex data into actionable insights for decision-making.
Collaborate with data engineers, data scientists, business teams, and stakeholders to ensure the tool meets business needs and evolves with changing requirements.
Troubleshoot and resolve data-related issues, ensuring data accuracy and consistency.
Provide documentation, training, and support to ensure end-users can effectively use the tool and reports.
Qualifications:
4+ years of experience in business analysis, data analysis, or a similar analytical role
Expert-level proficiency in Excel, including advanced formulas, pivot tables, macros, and VBA
Expert-level proficiency in SQL for querying, data transformation, and analysis
Strong experience with Databricks and other SQL-based platforms for large-scale data processing and analytics
Proven track record of automating processes and improving data pipelines to drive efficiency and scalability
Strong problem-solving skills and keen attention to detail
Excellent communication skills and ability to collaborate effectively with cross-functional teams
Proficiency in Tableau for data visualization and dashboard development
Preferred Skills:
Experience with Python, SQL, or Spark for data manipulation and automation.
Knowledge of cloud platforms such as Azure, AWS, or Google Cloud .
Familiarity with API integrations and data governance best practices.
Equal Opportunity Statement: Include a statement on commitment to diversity and inclusivity.