Red Hat Data Warehouse and Business Intelligence Engineer in Prague, Czech Republic
At Red Hat, we connect an innovative community of customers, partners, and contributors to deliver an open source stack of trusted, high-performing solutions. We offer cloud, Linux, middleware, storage, and virtualization technologies, together with award-winning global customer support, consulting, and implementation services. Red Hat is a rapidly growing company supporting more than 90% of Fortune 500 companies.
The Red Hat Business Intelligence team is seeking a Data Warehouse and Business Intelligence Engineer to join us in Prague, Czech Republic. In this role, you will design, develop, and test data solutions using ETL tools in an open and collaborative environment. You will also collaborate with Red Hat’s internal business departments to enable data-driven decisions for the company.
Primary job responsibilities
Add new data sources to our cloud-based data warehouse using ETL tools and custom connectors as needed
Design and develop SQL-based views on our data warehouse to enable multi-source data analysis
Perform unit tests and validate expected results, and iterate these until test conditions have passed
Manage problem assessment, resolution, and documentation
Modify existing universes to provide defect fixes
Troubleshoot defects to determine the root cause
Review code created by team members
2+ years of demonstrated ETL development experience
Record of building innovative solutions
Understanding of the processes of data quality, data cleansing, and data transformation
Advanced experience with SQL coding
Extensive knowledge of data warehousing tools, patterns, and processes
Ability to interpret written requirements and technical specification documents
Good coding skills according to published standards and design guidelines
The following are considered a plus:
Experience with cloud computing platforms like Amazon Web Services
Knowledge of columnar databases like Amazon Redshift
Comfortable with ETL tools like Informatica, Informatica Cloud, or Pentaho
Ability to visualize data in tools like Business Objects or SAS Visual Analytics
Understanding of analytical vs. operational reporting
Red Hat is proud to be an equal opportunity workplace and an affirmative action employer. We review applications for employment without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, citizenship, age, uniformed services, genetic information, physical or mental disability, medical condition, marital status, or any other basis prohibited by law.
Red Hat does not seek or accept unsolicited resumes or CVs from recruitment agencies. We are not responsible for, and will not pay, any fees, commissions, or any other payment related to unsolicited resumes or Cvs except as required in a written contract between Red Hat and the recruitment agency or party requesting payment of a fee.
Job ID 58495
Department Software Engineering
Posting date 7/20/2017
Remote base ..