Senior DWH Specialist

Job summary
Freelance
Prague
Salary: Not specified
A few days at home
Experience: > 5 years
Skills & expertise
Generated content
Stakeholder engagement
Data analysis
Strategic planning
Problem-solving skills
Team building
+6
Apply

Mattoni 1873
Mattoni 1873

Interested in this job?

Apply
Questions and answers about the job

The position

Job description

Are you the type of person who sees beauty in structured data but doesn’t shy away from the chaos of unstructured information? If you’re someone who enjoys connecting the dots between raw data and business strategy, all while contributing to a cutting-edge data architecture, keep reading.

What’s it about? You’ll be our go-to DWH expert, responsible for building and optimizing ETL pipelines from diverse sources (think SAP, Oracle NetSuite, web APIs and similar) into our MSSQL-based Data Warehouse. More than that, you’ll have a hand in shaping the future of our Data Architecture, particularly as we move to the cloud.

Your daily duties

  • Data Extraction and Integration

  • Extract data from various sources into the DWH while ensuring accuracy and consistency.

  • Develop and optimize ETL processes for seamless integration.

Source Data Analysis

  • Analyze source data to identify trends, patterns, and anomalies.

  • Collaborate with business stakeholders to understand data requirements and provide insights.

  • Create and maintain comprehensive documentation of data sources and transformations.

Stakeholder communication

  • Communicate with business and technical teams to gather requirements and provide updates.

  • Translate business needs into actionable insights for both technical and non-technical audiences.

  • Present findings and recommendations to both technical and non-technical audiences.

Strategic Initiatives

  • Contribute to new Data Architecture landscape design in cloud.

  • Provide expert insights on crucial decisions related to data migration, technical patterns and selecting proper platforms and toolset.


Preferred experience

Qualifications

  • A degree in Computer Science, IT, or a related field.

  • Proven experience in implementing data extraction, transformation, and loading (ETL) processes.

  • Good knowledge of DWH patterns and principles.

  • Solid knowledge of MSSQL and T-SQL.

  • Excellent analytical and problem-solving skills.

  • Strong communication in Czech or Slovak (C1 level or native) and English (B2 min.) with advanced interpersonal skills.

  • Ability to work independently and as part of a team.

Preferred Skills

  • Experience with BI/DWH implementation in cloud (MS Fabric, Snowflake, Databrics)

  • Familiarity with SAP or S/4 HANA

  • Knowledge of Spark or Python

What do we offer?

  • Flexible working hours, home office

  • 5 weeks of paid vacation

  • Informal working atmosphere

  • Meal allowance

  • Benefit Plus Program - 6000 CZK annually

  • Multisport card

  • Allowance for transport to work

  • Contribution to pension insurance, group life and accident insurance and liability insurance

  • Interest-free loans for employees

  • Referral and loyalty programs

  • Teambuildings and other company events

  • Special prices for company products


Recruitment process

We have two rounds of interviews. First is with your future manager and HR recruitment, second interview is with the leader of Digitalization in Mattoni 1873. If you’re successful during these two rounds, last but not least step is sending you the offer.

Want to know more?

Apply