Senior DWH/BI Engineer

Exadel Poland

Żurawia 71, Białystok

5 d. temu

source : Just Join IT

About the Project :

The customer has been working on next generation analytics since 2018 and has migrated to cloud big data platform on Amazon EMR.

The customer provides software products and services to insurance companies, repair shops, OEMs, parts suppliers etc. and has a variety of products in auto physical damage, casualty, telematics and parts domain.

All these applications share data with analytics team to build enterprise data lake which also allows the customer to do next generation analytics on the amassed data.

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

Your 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

Our 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

Development opportunities we offer

external training

industry-specific e-learning platforms

intracompany training

mentoring

support of IT events

technical knowledge exchange within the company

What we offer

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 you in broadening your 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, sporting, charity, and entertainment events

Working at Exadel means always upgrading your 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

Benefits

sharing the costs of sports activities

private medical care

sharing the costs of foreign language classes

sharing the costs of professional training & courses

remote work opportunities

flexible working time

fruits

integration events

computer available for private use

no dress code

video games at work

coffee / tea

drinks

parking space for employees

leisure zone

employee referral program

Project Tech Stack :

Technologies used on the project are all open-source : Hadoop, Hive, PySpark, Airflow, Kafka, AWS

Exadel Poland sp. z o.o.

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.

Zgłoś tę pracę

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.