Senior BigData DW/BI Developer (1707) Welcome bonus 4000$ (вакансія неактивна)

3+ years of experience in Database/SQL (such as Oracle/SQL Server/MySQL/MongoDB)
Strong SQL writing skills
Capable of building conceptual, logical and physical data models in Erwin and/or ER Studio / or any similar visualization studio
Any experience working with big data and HIVE is an advantage
Strong technical expertise in database architecture, design & data modelling
Knowledge of data model types and terminology including OLTP/OLAP, (De)normalization, dimensional, star, snowflake modelling, cubes and graph/NOSQL
Expertise in gathering and analyzing system requirements and design conceptual and logical data models
Understand and apply data naming standards and explain your definition of “best practices in data modeling”
English level — Intermediate

Vacation is 20 working days / till 20 working days per year for sick leaves
Full payment of taxes
English courses
Flexible work schedule
Friendly environment
Medical insurance
Opportunity for career growth

Design and develop integration data models between multiple disparate data sources and consolidate them into a single common data model (enterprise data model)
Be responsible for maintaining version control of the data model(s), as well as ensuring consistency between the data model and deployed instances of the model

About the Customer:
The сustomer is a leading provider of vehicle lifecycle solutions, enabling the companies that build, insure, repair, and replace vehicles to power the next generation of transportation. The company delivers advanced mobile, artificial intelligence, and connected car technologies through its platform, connecting a vibrant network of 350+ insurance companies, 24,000+ repair facilities, OEMs, hundreds of parts suppliers, and dozens of third-party data and service providers. The customer’s collective set of solutions inform decision-making, enhance productivity, and help clients deliver faster and better experiences for end consumers. 

The сustomer’s company was ranked #17 in the Top 100 Digital Companies in Chicago in 2020 by Built in Chicago, an online community for digital technology entrepreneurs in Chicago, and was named one of Forbes best mid-sized companies to work for in 2019 — an important accolade and retention tool for the 2,600+ full-time company employees (alongside 350 dedicated contractors).

The сompany’s corporate headquarters is in downtown Chicago in the historic Merchandise Mart — a certified LEED (Leadership in Energy and Environmental Design) building that is also known to be a technology hub within the broader metro.

About the Project:
The customer has been working on the next generation analytics platform since 2018. The customer is currently working on Hortonworks and plans to move to Amazon EMR/Hadoop in 2021. The platform is where all the data is collected into one data lake so they can then perform next-generation analytics.

Project Advantages:
Cross-product analytics
Analytics for every new product the customer has. The analytics team’s products are how the customer’s company sells the products’ value to clients
Quarterly business review meetings use data to explain how the product is helping clients in their business
You’ll get to work with a cross-functional team
You will learn the customer’s business

Project Stage:
Active Development

Project Tech Stack:
Technologies used on the project are all open source Hadoop, Hive, PySpark, Airflow, Kafka