Position: Senior DWH/BI Engineer
Company: Exadel
Experience required: 2y
Category: Python
English level: intermediate
Published: 2021-10-01T00:00:00+03:00

We’re looking for an experienced Senior DWH/BI Engineer to join our team! The successful candidate should be proficient in data modeling techniques, as well as capable of discussing and communicating business rules and how to implement those rules in a data model. Collaborative approaches, good communication skills, a strong work ethic, and a willingness to pitch in and get the job done are essential characteristics.

Work at Exadel - Who We Are:
Since 1998, Exadel has been engineering its own software products and custom software for clients of all sizes. Headquartered in Walnut Creek, California, Exadel currently has 1700+ employees in development centers across America, Europe and Asia. Our people drive Exadel’s success, and they are at the core of our values, so Exadel is a people-first cultured company.

About Our 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 Our 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, and 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
Ability to 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)
Maintain responsibility of version control of the data model(s), as well as 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, AWS

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