Business Intelligence Analyst

Passionate about optimizing data processes, building efficient ETL pipelines, or delivering high-performance dashboards?

At Zentiva, a generic pharmaceutical company we are looking for a Business Intelligence Analyst, to help us drive innovation and support strategic decision-making across our key business functions, such as Finance, Human Resources, Product Supply, or Commercial.

If you have expertise in database development, data engineering, and analytics, while utilizing tools like T-SQL, Microsoft SQL Server, Azure Data Factory, Power BI, and Databricks, let us know about yourself. It’s time to make an impact and transform data into actionable insights!

You will have the opportunity to:

• Gather and design requirements - collaborate with business stakeholders to capture and refine requirements and act as a partner, bouncing ideas, making recommendations and challenge when needed
• Conceptualize ideas through various mock-ups, diagrams or modelling tools to design the target solution.
• Implement new solutions - develop databases, Lakehouse, ETL or analytics solutions. Liaise with BI team members, external partners, project managers and business stakeholders during various phases of deployment including testing, validation, acceptance and post go-live support.
• Maintain existing solutions - become an expert on assigned solutions, building a comprehensive understanding of the data flows, type of data, inter-connected systems and how the solutions are used. Modify and extend solutions according to changing business needs, ongoing evolution of databases, ETL, Dashboard and reports.
• Monitor, fine-tune and support performance - contribute to daily monitoring activities (checking daily/nightly processing jobs, troubleshooting); Data validation, data analysis & root cause investigations, data extractions and data preparation for various projects and initiatives.
• Manage Helpdesk in the context of BI Solution - diagnosing data errors presented in reports, failed jobs, access management, enhancements to existing solutions etc.
• Contribute to the DEVOPS WIKI documentation for BI solutions, or to the curation of data assets within the Microsoft Purview data catalog
• Deliver user guides and support documentation and support the internal Power BI community with sharing guidance and best practice

What will you need to thrive in this role:

• University degree with focus on Data, Statistics or Mathematics
• 5+ years in industry working as a BI Analyst, Data Engineer or Report developer
  • Practical experience with the full Microsoft BI stack (DB, SSIS, SSAS, SSRS) or Microsoft Azure (Data factory, SQL DB, Power BI & Fabric), T-SQL (Expert level), Experience writing SQL queries; basic understanding of DAX functions and formulas; good understanding of Power Query, data transformation, data profiling & performance analyzer; Excel - practical experience with Excel functions (vlookup etc.), linking data between files/sheets, setting up connections to servers and semantic models, pivot tables. Expert knowledge of joins, data types conversion, functions, performance tuning, dynamic management view, temp tables, CTE’s recursive joins, text parsing, ranking functions, pivot/unpivot. Practical data modelling experience, understanding of star schemas, n:m relationships, circular references & bridging tables.
• Proficiency level of English
• Strong Analytical and Problem solving skills
• Nice to have - Previous experience with Python or Spark, Experience working with ERP, CRM & financial data, Prior experience working with APIs, Prior experience with reporting or visualization tools like Qlikview, Tableau, Crystal Reports etc.

Our Recruitment Process:

To be considered for this role, please apply in our Applicant tracking system and refrain from sending your CV via email. Upon the completion of sourcing (CV collection) period, all received application will be reviewed by our Recruitment experts and evaluated against the needs of the open role. Successful candidates will be contacted by our Recruiting experts for an initial screening interview during which further details about the selection process will be shared. Successful candidates will progress to interviews with line managers, while not selected candidates will be informed in a written form as soon as possible. 

We promise you will own your success. We will empower you with the freedom and autonomy to shape your work, make key decisions, and take ownership of your success. We will trust you to lead, innovate, and make an impact from day one.

Diversity is a fact. Inclusion is an act @Zentiva

At Zentiva, we are a team of 5000 unique talents bonded together by our purpose to provide health and well-being for all generations. We strive daily to create a work culture where everyone feels appreciated, can be their true selves, and contribute to the best of their ability. Seeking for a balanced team across the company, we welcome applications from all qualified candidates with various educational and industry experiences, cultural or ethnical backgrounds, and different life experiences or abilities, regardless of their religious or philosophical beliefs or whomever they choose to love. To learn more about our D&I commitment, click here.

Join our winning team! Be part of our winning culture! Be Zentiva!