Creatix Slovakia, s.r.o.

SSIS/ETL Engineer

Creatix Slovakia, s.r.o.

×

Neváhajte a pošlite životopis!O prácu sa uchádzajú aj kandidáti, ktorí nespĺňajú úplne všetky požiadavky.

Place of work
Einsteinova 11, Petržalka
Contract type
full-time, agreement-based (Temporary jobs), trade licence
Basic wage component (gross) and other rewards
Salary starting at: Junior minimum1300EUR. Mid-level minimum1800EUR. Senior minimum2600EUR. Salaries vary based on relevant experience & skills, 13th salary bonus based on individual & company performance.

Information about the position

Job description, responsibilities and duties

Like being around other entrepreneurial geeks? Is it important to you to create products that have meaning and value? Are you looking for the space to do great things? Want to play a pivotal role in the fast track growth of one of Chicago's hottest tech companies?
Creatix, a digital product design and development firm, is looking for a skilled SSIS/ETL Engineer with python programming skills, who will become an integral part of our Data Science & Engineering team. We've got game changing opportunities ahead of us, so if you're looking for a position where you have the freedom to outdo yourself on a regular basis, read on.
Your Role at Creatix
We are looking for SSIS ETL Engineer responsible for the design, development, execution, and delivery of all ETL needs for the company. We are seeking candidates who have experience in data analysis, extraction, loading and transformation of data that meet complex requirements of various business unit needs. The ETL Engineer will act as the owner of all ETL infrastructure including execution, documentation, maintenance, and metadata management. They will also support the development of the infrastructure necessary for full scale data science, predictive analytics and machine learning.
Your role:
• Design, develop and deploy Microsoft SSIS ETL jobs.
• Monitor, execute and report on all ETL jobs while working with appropriate teams to take corrective action quickly, in case of issues.
• Perform unit testing, system integration testing and assist with user acceptance testing.
• Adapt ETL code to accommodate changes in source data and new business requirements.
• Create and maintain documentation of the ETL technical detail design, operational support and maintenance procedures.
• Ensure data quality and compliance with development, architecture and reporting standards throughout entire ETL process.
• Ensure compliance with regulatory requirements for data transmission, storage, and data access.
• Collaborate with the rest of the BI Team, subject matter experts and department leaders to understand, analyze, build and deliver new ETL processes and/or reports.

Employee perks, benefits

Not Another Code Monkey!
At Creatix, you're not just another "code monkey". We're fully invested in you, your growth, and your well-being. Our equation is simple: Happy developers = happy technology = happy clients.

• Our People define us. Our mission is to make a positive impact in the lives of those we do work for, those who use what we produce, and those who make it a reality.
• Our employees are our most valuable asset and therefore we focus on creating a supreme work and human environment, their satisfaction and professional growth.
• We are a Family. The Team we started with in 2005 are still here today, fiercely loyal to each other and our clients. You'll find us in the office together, tackling challenges head-on. You'll also find us outside the office together, enjoying each other's company.

We Offer
When you join Creatix, we invest in you. We're passionate about to maximizing your potential and fueling your growth. While we'll push you to excel, we'll also make sure you're having a great time doing it. Here's what you'll enjoy if you join the team:

• Cool Projects
Every developer dreams of working on top-quality projects that leverage the newest technologies. Our partnerships with top companiesin the United States and Europe guarantee steady work on some of the coolest and most promising international projects.

• Competitive Pay & Growth
We offer compensation packages designed to help you relax about your finances and focus on what you do best, your incredible work. We make your professional growth a priority by investing in you. Our programs are designs to help you achieve your goals (annual performance bonus, free in-house English lessons, USA exchange work program, special budget dedicated for hard and soft skills, referral program and relocation bonus - to name just a few).

• Flexible Hours, Vacation & Remote Work
Like to brainstorm from your couch? Think best while walking? Need a change of scenery for inspiration? You don't need to be chained to a desk to do great things with us. It's important to stay energized, and we understand that sometimes means getting away for a bit!

• Professional Mentorship
We have worked on hundreds of projects since starting up in 2005, and we're willing and eager to share what we have learned along the way. We've also developed great relationships with industry experts who regularly share their vast knowledge with us at events and workshops.

• Work Hard, Play Hard
We demand a lot, but we'll always reward you for your hard work! When you need a break, you can relax and play a few games (from table football, table tennis to x-box) with your peers or hang out in our fully-stocked kitchen, enjoying a snack and a beer. You'll also get to know your talented co-workers better at our regular social events and team-building retreats (company heckathons with generous prices, family days, company breakfasts, parties and ad-hoc team events).

• New Gear & Fitness Perks
We'll provide you with the equipment you need to work comfortably and efficiently, from new laptops to standing desks. We even pay you if you prefer to use your own notebook. We also believe a healthy geek is a happy geek. We totally support all physical activities (from marathons, multisport cards, Golem cards to sponsored inhouse Yoga!) and offer discounted rates at local gym & wellness facilities.

Requirements for the employee

Candidates with education suit the position

University education (Bachelor's degree)
University education (Master's degree)

Language skills

English - Upper intermediate (B2)

Other knowledge

Microsoft SQL Server - advanced

Number of years of experience

2

Personality requirements and skills

We expect you to have:
• Bachelor's Degree in computer science, information systems, or computer engineering
• 2+ years of relevant experience
• Demonstrated ability with SSIS ETL tools
• Working experience with Python Development
• Familiarity with one or more of the following frameworks is a great plus: Airflow, Flask, pandas, numpy, scikit
• Strong understanding of data warehousing concepts and dimensional data modeling
• Hands-on experience with troubleshooting performance issues and fine-tuning queries using tools such as SQL Profiler, Performance Monitor and Database Engine Tuning Advisor
• Proven experience extracting data from structured data sources (SQL, Excel, CSV files) and unstructured data sources (Couchbase, Splunk)
• Advanced ability in MS SQL 2016 and above, experience in MySQL preferred but not required
• Experience with Apache (airbnb) Airflow is a great plus
• Proven experience extracting data from various data sources (MySQL, Excel, Access, SharePoint, Azure, Text files) both on-premise and in the cloud
• Experience consuming data from web services, SOAP and REST technologies, HTML, XML and JSON
• Knowledge of encryption technologies and secure file transmission products such as Posh-SSH, SSL, Open-SSL, GPG, PGP, Kleopatra, SFTP
• Familiarity with docker and docker-compose will be useful and is certainly a plus
• Understanding and experience of the software development lifecycle and code repositories such as git, including branching and merging flows
• Strong analytical and problem-solving ability with strong attention to detail and accuracy
• Ability to handle multiple tasks and adapt to a constantly changing environment
• Self-starter with the ability to work independently, take initiative, and learn new skills
• Excellent written and oral communication skills, with the ability to articulate complex processes to individuals of varying technical abilities
• Ability to work with the rest of the BI Team to cross-train and provide support for other BI tasks like SSRS and/or Power BI Development, Cube Maintenance, Data Analytics and Requirements Gathering.
• Excellent written and verbal communications skills in English (B2+)

Advertiser

Brief description of the company

Creatix is a Chicago-based digital product design and development firm with office in Bratislava, Slovakia. Creatix helps organizations bring innovative mobile and web-based software products to market as well as realize new value from existing products. From ideation to requirements to launch, Creatix offers its clients proven experience in supporting the complete digital product life cycle. Our focus is on ideation, strategy, user experience architecture, usability, user interface design, development and execution of these across the entire digital ecosystem. Visit Creatix at www.creatix.sk

Number of employees

25-49 employees

Company address

Creatix Slovakia, s.r.o.
Einsteinova 11
851 01 Bratislava
http://thinkcreatix.com

Contact

Contact person: Mgr. Michal Janik
Tel.:-=KONTAKT=-
E-mail:send CV
ID:3479715Dátum zverejnenia:27.8.-=KONTAKT=-Lokalita:Einsteinova 11, PetržalkaPozícia:Business Intelligence Specialist,IT Consultant,Programmer,Software Engineer,Systems EngineerSpoločnosť:Creatix Slovakia, s.r.o.Základná zložka mzdy (brutto) a ďalšie odmeny:Salary starting at: Junior minimum1300EUR. Mid-level minimum1800EUR. Senior minimum2600EUR. Salaries vary based on relevant experience & skills, 13th salary bonus based on individual & company performance.

Počet videní: 0
Ponúkaná mzda: 1300 EUR
Inzerent:Creatix Slovakia, s.r.o. [ ]
Zverejnené dňa:2018-08-27 (27 dní)
Zverejnené pre lokality:Slovensko Bratislavský kraj Bratislava
Pracovná ponuka nájdená za 0 milisekúnd.