Position: Data Engineer
Company: at IT-Rex - Staffing Services
Category: Data Engineer
Experience required: 3y
English level: upper

A custom development company is a design and software powerhouse with mature and established practices in Enterprise Web & Mobile Development, Technical Architecture, Human-Centered Design, Cloud & DevOps, Advanced Data Мanagement & Analytics. For our Data & Analytics Center of Excellence (DCOE) we are looking to hire experienced Data Engineers. 

As a Data Engineer in DCOE, your primary goal will be to offer non-standard solutions and unlock the potential of our clients. Through expert-level data management and analysis, the DCOE team facilitates resource management, database migration to new engine types, data unification, and company mergers. SQL reports optimization, Business Intelligence reports, and troubleshooting of data flows are another significant part of our day-to-day responsibilities. Our software solutions tackle specific tech challenges across several industries. While our roots are in education, nearly half of our current projects are focused on healthcare. We also innovate in finance, real estate, commerce, IoT, and others.

Requirements:
3+ years of experience with ETL, Data Modeling, and Data Architecture
Strong experience in generating data pipelines from multiple data sources, in collaboration with diverse team members
Experience in operating very large data warehouses or data lakes
Understanding of software development best practices, including query optimization, version control, code reviews, and documentation
Experience with building data pipelines and applications to stream and process large datasets at low latencies
English - В2 (at least)

A significant advantage would be an experience with:
Python
Scala
ETL tools like Airflow, Talend, Mattilion, Informatica, ODI, SSIS 
AWS/ Azure or OCI
Big Data technologies such as Hadoop/Databricks/Spark/EMR, Oracle, MS SQL Server, MySQL, PostgreSQL, AWS Redshift, Azure Synapse, Snowflake, DynamoDB
Certification of SQL, PL/SQL, T-SQL 

Responsibilities:
Develop, construct, test, and maintain data pipelines for multiple analytics functions
Align architecture with business requirements
Analyze, re-architect, and re-platform data warehouses
Data acquisition
Identify ways to improve data reliability, efficiency, and quality
Prepare data for predictive and prescriptive modeling as well as for classic BI analytics

Registration: contract or b2b

Stages of the interview: 
1 - hr approximately 40 minutes, 
2 - terms of reference 
3- with Lead about an hour.