Position: Cloud Data Consultant
Company: Hiring and Dealing
Category: Other
Experience required: 3y
English level: upper
Published: 2022-05-01T00:00:00+03:00

As a Data Consultant, 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. Usage of the Azure Big data services, SQL reports optimization, data flows, and troubleshooting are another significant part of our day-to-day responsibilities. The software solutions of the company tackle specific tech challenges across several industries. While the roots are in education, nearly half of the current projects are focused on healthcare.

As a top engineering employer, run by engineers, an outsourcing company provides challenging careers in a friendly, people-oriented environment. We value our employees and share our success through competitive pay and benefits, advancement opportunities, and flexible working models.

**What You’ll Do**

 - Align architecture with business requirements
 - Analyze, re-architect, and re-platform data warehouses
 - Develop, construct, test, and maintain data pipelines for multiple analytics functions
 - Identify ways to improve data reliability, efficiency, and quality
 - Troubleshoot and resolve complex issues
 - Prepare data for predictive and prescriptive modeling as well as for classic BI analytics
 - Mentor and train colleagues when necessary, by helping them learn and improve their skills, as well as innovate and iterate on best practices

**What You’ll Need**

 - 3+ years of experience in Azure Big Data services (Synapse Analytics, Databricks, Azure Data Factory, Azure Machine Learning, Azure Stream Analytics, Data Lake Analytics, Azure Database, Azure Cosmos DB, HDInsight)
 - 5+ years of experience in data engineering, software engineering, or other related roles
 - 5+ years of experience with ETL, data modeling, and data architecture
 - Strong experience in one or more of the following: SQL/ Python/ Scala
 - 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
 - Ability and desire to learn new languages and technologies
 - Attention to detail and strong documentation skills
 - Fluent English both written and verbal

**A significant advantage would be**

 - Experience in ETL tools like Airflow, Talend, Matillion, Informatica, ODI, SSIS
 - Usage of Big Data technologies such as Hadoop/ Databricks/ Spark
 - Oracle, MS SQL Server, MySQL, PostgreSQL, Snowflake
 - Design and implement batch and stream data processing pipelines
 - Certification of SQL, PL/SQL, T-SQL
 - Azure Certification

**Conditions **

 - 100% remote work
 - Full-time employment
 - The work schedule is flexible, nevertheless, as a team, we need to meet at some time, so we would want you to be able to join and be available for meetings until 8 PM GMT+2 when necessary
 - Work in a team of professionals, so we expect the same from you
 - Access to the most up-to-date industry tools and software
 - We use OpenAir for timesheet management
 - If you have reliable internet, you can work from anywhere in the world

**Selection process:**

 - 30-minute interview with Recruitment Consultant
 - Interview with HR
 - Interview with the team

If this sounds like your kind of thing – we want to talk to you!