Position: Senior Data/BI Engineer (dbt)
Company: SoftServe
Experience required: 3y
English level: upper

**WE ARE**
SoftServe is cooperating with our client, a huge digital delivery service operating in over 650 American cities through approximately 250 fulfillment centers as of March 2021. Users can order items online or via the app and get the items delivered. The client has recently acquired another well-known delivery company to accelerate geographic growth and plans to significantly invest in new international markets, starting with the UK and Europe, and expand its global operations team. The area to work with is the customer-facing application (web, mobile Android, iOs) which has been recently localized with help of SoftServe's team.

Project Details
About 600 existing DBT models and lack of documentation slowed down the team task's to create a portfolio of gold data products. The overall idea is to decrease the number of DBT models from (600 DBT -> 40-80 DBT models), with good documentation that can be the foundation for curated self-service reporting strategy for each Client's functional business.

**YOU ARE**
A professional willing to write clean, correct, and efficient code having the below-mentioned skills, meeting these technical requirements

• 5+ years of databases development and data processing
• Good understanding of data warehousing principles and modeling concepts
• Experience with MPP databases (Redshift, Snowflake, Synapse)
• Hands-on practice with dbt tool (model, test, doc, exposure)
• Expertise with one of popular BI tools
• Knowledge of Looker, and Python (as a benefit)

**YOU WANT TO WORK WITH**
• Participation in the design of data model for data warehousing, alongside with Data Architect
• Creation of data processing using dbt tool
• Writing the code to transform the data to put it in the right shape and the suitable model
• Refactoring and developing gold dbt models to transform and cleanse the data
• Introduction of the governance and consistency around dbt models
• Creation of documentation using dbt Docs
• Validation and testing data and models, leveraging capabilities of dbt test
• A huge amount of dbt models to make them optimized and sharp
• Design specifications review, providing feedback and estimating efforts
• Participation in design reviews, code reviews, team meetings, and data quality sessions
• Dbt models and data processing approach validation
• Us by collaborating and building a trusted relationship with Client

**TOGETHER WE WILL**
• Enhance the existing data reporting functionality
• Implement new critical features into the existing data environment
• Rebuild core BI infrastructure to make it more scalable
• Operate across evolving technology stack
Discover the new opportunities and challenges and increase the client’s and team’s satisfaction