BI & DWH analyst

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!
Job Details
What will be your daily routine?

• Active collaboration on the analysis, development, and implementation of processes and functions into WMS/ERP.
• Data analysis from various sources (databases, internal applications, systems, and data warehouse).
• Creation of SQL and PL/SQL scripts for data selection and manipulation (primarily Oracle, MS SQL).
• Performing analyses, designing solutions, and implementing system support - working with DWH, databases, and internal applications.
• Active collaboration with the internal team and external suppliers.
• Creating standardized documentation of changes.
• Collaboration on new projects.
• Analyzing and resolving operational issues and incidents.

What we expect from you?

• Relevant work experience in one of the following IT positions: BI Analyst, IT Business Analyst, Data Analyst, etc.
• Knowledge of working with databases (MS SQL or Oracle).
• Intermediate knowledge of PL/SQL and other tools for working with data and relational databases.
• Knowledge of SQL (JOIN, GROUP BY, WHERE) and ETL processes.
• Familiarity with Business Intelligence concepts (UML, logical and physical data models, etc.).
• Analytical thinking and the ability to communicate analysis results to colleagues.
• Ability to analyze data and create relevant reports and dashboards.
• Experience with business intelligence and data warehouses (DWH).
• Communicative knowledge of English and Czech language is mandatory.

What do you need for this role?

• University or high school education in information technology / economics.
• Knowledge of Oracle APEX / Oracle Forms.
• Familiarity with Qlik Sense / Power BI software solutions.
• Advanced knowledge of Excel.
• Understanding of programming code.
• Knowledge of warehouse and logistics processes.

What we can offer you?

• Work in a stable company - we have been successfully operating in the market for over 30 years.
• You will become part of a friendly team.
• Meal allowance of 90 CZK for each working day (paid directly to your account).
• MultiSport card with an employee contribution of only 410 CZK/month.
• Free weekends and public holidays.
• Discounts on products in the employee pharmacy.
• Option to use the canteen.
• Contribution to pension insurance.
• An additional fifth week of vacation.
• Expected start date: as soon as possible / as agreed upon.

If you are interested in our offer, please send us your structured CV via the response button, and we will definitely get back to you!
What Cencora offers
Benefit offerings outside the US may vary by country and will be aligned to local market practice. The eligibility and effective date may differ for some benefits and for team members covered under collective bargaining agreements.
Full time
Affiliated Companies
Affiliated Companies: Alliance Healthcare s.r.o.
Equal Employment Opportunity
Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.
The company's continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.
Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email [email protected]. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned