Job Search

← Back to all jobs

DWH Analyst

Are you chasing the top IT companies with an international reputation and seeking to enhance your professional career by advancing yourself in a multicultural atmosphere lead by respected experts in the global market? Work with the Data Warehouse (DWH) Industry leaders who believe in the success of our business solutions for analytics, industry-leading technology and architecture expertise, at the heart of the analytic ecosystem, helping the world’s most influential companies that achieve high-impact business outcomes for four decades. The innovative approach that is used for Analytics Solutions achieves high-impact business outcomes by leveraging our vast consulting expertise, advanced data, and analytics capabilities, and intellectual property to deliver the results businesses need to reach their goals. We are looking for DWH Analysts to perform various tasks like analyses, database, and architecture design, gathering business requirements, creating testing and implementation scenarios, etc.

Responsibilities and Duties of DWH Analyst:

• Performing data warehouse tasks for large projects (database design, business analyses, defining business requirements)

• Deliver business and application specific consulting services included in the integrated Teradata solutions

• Providing mapping and design of customer’s business needs to the Teradata database

• Support the pre-sale process as well as client communication

• Understand Business Data Model and logical mappings (source mappings, LDM mappings)

• Create detailed,technical Source Target mappings

• Perform unit testing and package jobs to be prepared for deployment Qualifications

Basic requirements:

• 2-3 years of experience working as an ETL Analyst on DWH projects

• Experience with the creation/modification of Mapping or Technical ETL specifications (Source Target Mapping)

• Excellent SQL know-how

• Flexibility in working from Prague (Czech Republic) with business trips abroad if required by the customer

• Advanced English

• EU Citizenship

Desired requirements:

• Experience in banking, telco or retail industry

• Familiar with CASE modeling

• Experience in designing User Acceptance Tests

• Experience with Teradata Tools and Utilities (FastLoad, MultiLoad, BTEQ, FastExport, TPT)

We offer:

• Relocation bonus (if coming to Prague from abroad)

• Vast amount of online trainings covering Teradata DB, DWH Methodologies, Big Data and more with Teradata University

• Every new hire gets a detailed training plan containing 2 weeks on-site training about Teradata architecture

• Each ETL Developer is eligible for up to 10 training days per year

• 25 days of holiday per year (instead of the standard 20 as per Czech law)

• Language courses (Czech, German)

• Private medical care

• Meal vouchers in the amount of 100 CZK/day (Teradata contributes 75%)

• Company contribution for pension fund (up to 3% of monthly gross salary)

• Life insurance

• Company assistance in case of sickness (25% of your gross base salary) in addition to local regulations

• Employee referral program (4,000$ USD)

• Sports and activities membership program

• Employee stock purchase program

• Contribution of 300$ USD for a mobile phone of your choice (every 2 years)


By sending your email or application you agree that your personal data may be recorded in the database of Hagen Human Capital s.r.o. with its registered office at Václavské náměstí 838/9, 110 00, Praha 1, Czech Republic. This then may be processed for recruitment purposes as detailed in the Czech legislative act number 101/2000 Sb., on the protection of personal data.

Zasláním životopisu vyjadřujete souhlas se zpracováním osobních údajů ve smyslu § 11 zákona č. 101/2000 Sb., o ochraně osobních údajů a změně některých zákonů, ve znění pozdějších předpisů (dále jen „Zákon“), v souladu s nařízením EU 2016/679. Kandidát tímto potvrzuje, že je společnost Hagen Human Capital s.r.o., IČ: 246 95 262, se sídlem Praha 1, Václavské náměstí 838/9, PSČ 110 00, zapsaná v obchodním rejstříku vedeném Městským soudem v Praze, oddíl C, vložka 166750 (dále také jako „Zprostředkovatel“), v souladu s § 5 odst. 4 a § 11 Zákona oprávněna zpracovávat jím poskytnuté osobní údaje, a to pro účely vyhledání a zprostředkování zaměstnání pro Kandidáta.

Apply for this Job