Senior DWH/BI Engineer (Data Modeler 1707) (offline)

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

Requirements:
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 visualisation 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”

Responsibilities:
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

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

Advantages of Working with Exadel:
You can build your expertise with our Sales Support team, who provide assistance with existing and potential projects
You can join any Exadel Community or create your own to communicate with like-minded colleagues
You can participate in continuing education as a mentor or speaker
You can take part in internal and external meetups as a speaker or listener. We support broadening horizons and encourage knowledge sharing for all of our employees.
You can learn English with the support of native speakers
You can take part in cultural, sport, charity, and entertainment events
Working at Exadel means always upgrading skills and proficiency, so we provide plenty of opportunities for professional development. If you’re looking for a challenge that will lead you to the next level of your career, you’ve found the right place.
We work hard to ensure honest and open relations between employees and leadership, so our offices are friendly environments

About Olsys

OLSYS Ltd provides full-service solutions for mid-market and enterprise organizations.

With 15+ years of experience, 100+ projects and 50+ strong technical experts in the team, we continue to grow by expanding our development team in Europe, as well as expanding the base of new clients and projects.

As an enterprise software development company, we are building long term partnerships helping our clients accelerate their digital experiences with reasonable IT investments.
Our tailored approach, e-commerce focus, and flexible solutions allow us to design, develop, and deliver scalable, integrated commerce platforms that drive profits and boost the business.

Our industry focus:
— Banking and Finance (business continuity management, planning system, banking app development);
— Retail and E-Commerce (B2B Commerce, B2C Commerce, Digital/E-Commerce customer experience);
— Healthcare (website development for Healthcare organizations).

Our expertise includes:
— Commerce Solutions
— Development Services
— Creative Services
— Quality Assurance and Testing
— Maintenance and Support
— E-Commerce Consulting

Company website:
https://olsysltd.com/

DOU company page:
https://jobs.dou.ua/companies/olsys/