Symphony Anywhere

Data Engineer

Symphony Solutions is a cloud transformation company headquartered in Amsterdam, with offices in the Netherlands, US, Ukraine, Macedonia, and Poland. Symphony Solutions recently celebrated 10 years of continuous service, and we attract many people with our open, welcoming culture and Dutch-inspired environment.

We are a company with a difference as we maintain a strong ethical culture and keep company values at the level of interpersonal and client-oriented relationships. Our philosophy is to establish close and strong relations with every client, employee, and candidate to succeed in our main directions (e.g. PHP, Java, C#, C++, SAP, Salesforce/Force.com, iOS, Android, BlackBerry).

Requirements:

  • Location – Lviv, Krakow, Rzeszow
  • Excellent knowledge of SQL server, T-SQL, SSIS, SSAS, SSRS, data transformation and ETL
  • Good hands on programmatic experience in writing complex stored procedures, queries, views, user defined functions, cursors and common table expressions
  • Strong relational database design experience
  • Ability to create ETL specifications, unit, and system test cases
  • Clear understanding of SSIS and ETL standards and best practices
  • Hands on experience with large scale data migration projects
  • Experience with KingswaySoft Data Integration Toolkit is a plus
  • Exposure to Dynamics 365 Data Model is a big plus

Responsibilities:

  • Responsible for analysis and mapping of legacy data structures to the Omnipresence Customer Experience Management platform (Dynamics 365)
  • Working as part of the project team, the Data Engineer will work closely with clients and IT teams to extract, correct, test and transfer legacy system data to the Omnipresence data model
  • Conduct analysis of legacy systems and databases and create functional requirements to facilitate migration of data into Dynamics 365
  • With training, become an SME on the Dynamics 365 & Omnipresence Data Models and develop Source-to-Staging-to-Target mappings and collaborate with Development, Test and Implementation efforts
  • Translate functional requirements into technical specifications for the development of ETL packages
  • Identify and test for bugs and bottlenecks in the ETL solution
  • Design data migration processes including collection of source data, data transfer mechanism and data upload mechanism
  • Execute data migrations incrementally and write reconciliation scripts to run over the Staging tables to report any invalid data
  • Work with client teams on identified data issues and track these through to resolution
  • Maintain appropriate levels of data security and privacy relating to customer data
  • Complete and encourage others to complete administrative tasks in an accurate and timely manner
  • Observe, comply and assist with developing policies procedures, strategy and quality management systems

We offer:

  • Medical Insurance
  • Personal Workstation
  • Competitive salary and compensation package
  • Friendly and professional team
  • Symphony Training Academy
  • Low hierarchy and open communication
  • 20 vacation days
  • Private Medical Care
  • See BENEFITS Section for the full line-up

×
pdf | doc | docx allowed, 5mb max

Thank You for Your Submission!

Our recruiter will contact you soon.

Share

Our Recruitment process

Recruitment proccess Recruitment proccess

Check also