Position: Data Engineer
Company: Softserve
Category: SQL
Experience required: no_exp
English level: intermediate

SoftServe team is working as an extension of our customer’s team, a US company that provides companies with predictive, data-driven guidance, enabling better pricing and sales decisions to help businesses make their numbers. The platform uses advanced science in its price optimization and sales effectiveness applications to drive measurable financial results for B2B companies. The flexible SaaS model enables customers to quickly and confidently improve their financial performance by integrating into existing systems and processes. It also helps companies price more profitably and sells more effectively, driving top-and bottom-line growth of 5 to 10 percent or more.
Its predictive models provide answers to key sales questions: which customers to call on, which products to sell and what prices to quote. The application delivers predictive guidance to optimize sales decisions, forecast the impact of pricing strategies, reverse customer churn and anticipate your buyers’ needs.
B2B price optimization solution capable of quantifying true price response. It gives unprecedented control over pricing strategies, objectives, and constraints — you’ll know what’s really going to happen before you make any price changes in the field. Generates optimal prices for all of the most pervasive B2B pricing modes, from negotiated price bands to matrix and list prices and agreements.
As a complement to powerful optimization science, extensive analytical capabilities are directly embedded into the application. User-friendly, easy-to-modify visualizations allow us to see and understand the basis for and expected impact of recommendations.
The project is quite complicated due to using of various technologies including Web Services, Spring, Hibernate, Java, JavaScript, MSSQL Server, SalesForce, Amazon, RackSpace, etc.


Requirements:
• 2+ years of experience with one of the relational DB (MS SQL), strong knowledge of SQL
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
• Understanding the principles of building ETL processes and their support
• Practical experience with at least one ETL tool
• Understanding the concept and principles of building and maintaining a data warehouse
• Would be plus experience with Matillion
• Would be plus experience with AWS technologies (S3, AWS Glue, Redshift Spark, EMR)
• Would be plus Experience with source control systems such as Git or Perforce
• Would be plus Understanding the principles of interaction through the API, working with Postman
Responsibilities:
Design, development and administration of MSSQL, REDSHIFT databases.
Performance monitoring, reporting, and tuning of databases.
Creation and maintenance of SQL queries and routines
Reviewing and tuning SQL.
Develop Matillion solution, configuring data load via AWS technics
Maintenance of database server, replication and client environments.
Security and access control.
Provisioning of (database) development and testing environments.
Working and preparing API request, fix API issues